Question

Which of the following is automatically fills in a unique number for each record ?

• A. AutoText
• B. AutoNumber
• C. AutoMemo
• D. OLE

Answer 1

Answer:

B. AutoNumber

Data type

A data type determines the type of data that the field can store. Data types include the following:

• Text                  : Stores text , number or a combination of both upto 255 characters
• Memo              : Stores long text entries upto 64000 characters long
• Number           : Stores numbers that can be used in calculations
• AutoNumber   : Automatically fills in a unique number for each record
• Date/Time       : Stores Dates , Times or both
• Currency          : Stores numbers and symbols that represent money
• Yes/No             : Stores one of the two values such as Yes/No
• OLE                 : Object-Stores objects created in other programs such as a graphic , word                           document or Excel spread sheet
• Hyperlink           : Stores links to webpages in internet or files in internet
• Attachment       : Attachment allows us to attach files and images to our database
• Lookup Wizard  : A wizard that helps us to create a field whose values are selected from                                another table , query or list of values