Creating an AutoNumber Field in Access
What is the data type used to instruct Access to insert a unique, sequential number each time a new record is added?
A. Currency
B. AutoNumber
C. OLE Object
D. Hyperlink
Final answer:
The data type used to instruct Access to insert a unique, sequential number each time a new record is added is AutoNumber.
The correct answer is B. AutoNumber. AutoNumber is a data type used in Microsoft Access to automatically assign a unique, sequential number to each new record added to a table. It is commonly used as a primary key to uniquely identify each record in the table.