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.

← Exploring troubleshooting approaches in network issues The impact of regular json types and non native json types on querying →

More Posts: