HomeworkLib
Question

Which data type in Access would be the most suitable for creating and storing a numeric...

Which data type in Access would be the most suitable for creating and storing a numeric unique identifier such as CustomerID?

a. AutoNumber

b. Number

c. Long Identifier

d. Long Text

business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

AutoNumber

AutoNumber is a type of data used in Microsoft Access tables to generate an automatically incremented numeric counter. It may be used to create an identity column which uniquely identifies each record of a table. Only one AutoNumber is allowed in each table. The data type was called Counter in Access 2.0.

0 0
Add a comment
Know the answer?
Add Answer to:
Which data type in Access would be the most suitable for creating and storing a numeric...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Is about Access 2016 15) Access does not allow the creation of formulas for computation.           ...

    Is about Access 2016 15) Access does not allow the creation of formulas for computation.               a) True               b) False 16) The columns of a table corresponds to               a) Field               b) Record               c) Folder               d) File 17) An Access data base can contain a maximum of              a) any number of the table              b) Four              c) Ten              d) Twenty five 18) Which of the following is true about creating Access 2016 Table....

  • Question 3 (1 point) Which type of error bars would be suitable for use if you...

    Question 3 (1 point) Which type of error bars would be suitable for use if you wished to describe your data set? a) Standard deviation b) Standard error Oc) Confidence intervals d) All of the above e) a and b only

  • Please I need Help with this question, 1. Which of the following is a method tocreatea...

    Please I need Help with this question, 1. Which of the following is a method tocreatea new table inMS Access? A All the answers b. Using Design View c. CreateTable Wizard d. Directly Entering Data 1. Which field type will you select if you need to enter long text in that field? a Currency b Text c Hyperlink d Memo 1. The columns in a microsoft access table are also called _______ a Fields b Rows c Records d Columns...

  • Question 4 (1 point) Which type of error bars would be suitable for use if you...

    Question 4 (1 point) Which type of error bars would be suitable for use if you wished to display a population's maximum and minimum values? a) Range Ob) Standard deviation O c) Standard error d) All of the above e) a and b only

  • 4. (1 pt) Determine which type of graph would most clearly depict the data described. a....

    4. (1 pt) Determine which type of graph would most clearly depict the data described. a. The number of tickets sold at one theater over the course of a year. b. The number of tickets sold at one theater for each movie showing during one week. c. The number of tickets sold at one theater for each movie this week, specifically comparing the movie choices of patrons aged 18-35 to the choices of patrons aged 36 and older. d. Ticket...

  • 16) What does Access do to denote action queries differently in the Navigation pane? A) It...

    16) What does Access do to denote action queries differently in the Navigation pane? A) It displays them in bold text. B) It displays them in a larger typeface. C) It displays them in a section called Action queries. D) It displays them using specific icons. 17) Which of the following is not a rule for using an Append query? A) Data types in both tables much match (with some exceptions). B) There must be the same number of fields...

  • Which type of discontinuous wavelength selector (from table) would be suitable for each of the following,...

    Which type of discontinuous wavelength selector (from table) would be suitable for each of the following, again using each choice once: a) IR Spectroscopy b) UV Spectroscopy c) Visible Spectroscopy Table: ZnSe, KBr, Fused Silica, Silicate Glass

  • Which subject line for this informational e-mail would be most suitable? a. The Upcoming Lunch & Learn...

    Which subject line for this informational e-mail would be most suitable? a. The Upcoming Lunch & Learn Program Is in March. b. Important Announcement About Nutrition! c. Lunch & Learn: Surviving in the Fast Food Lane

  • 10. As part of the SAP tutorial, you were granted access to most roles and profiles....

    10. As part of the SAP tutorial, you were granted access to most roles and profiles. In MM02 you created a master record for a vendor. Which exercise is the most incompatible to this procedure in a well-controlled process? a. Creating customer records b. Creating a reconciliation account c. Creating a purchase requisition for the vendor d. Creating additional vendor records

  • Based on costs alone which borrower below would find the FHA Loan the most suitable for...

    Based on costs alone which borrower below would find the FHA Loan the most suitable for their borrowing needs: a. A borrower with a credit score of 490 and 3.5% down payment b. A borrower with a credit score of 550 and 10% down payment c. A borrower with a credit score of 660 and 15% down payment d. A borrower with a credit score of 750 and 20% down payment

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT