When you create a table in Datasheet view, Access automatically creates an ID field with the AutoNumber data type as the primary key field.

Name: When you create a table in Datasheet view, Access automatically creates an ID field with the AutoNumber data type as the primary key field.
Brand: Quizplus
Rating: 4.9 (28 reviews)

Question

Quizplus · Accepted Answer

In Microsoft Access, when you create a new table in Datasheet view, it automatically includes an ID field with the AutoNumber data type, which serves as the primary key by default.

When You Create a Table in Datasheet View, Access Automatically