124k views
1 vote
The Microsoft Access 2019 data type of AutoNumber is used when there is a specific need for a ______.

A) foreign key.
B) primary key.
C) surrogate key

User Cantordust
by
7.3k points

1 Answer

3 votes

Answer: B) Primary key.

Explanation: In Microsoft Access 2019, the AutoNumber data type is used to create a unique identifier, or primary key, for each record in a table. The AutoNumber data type automatically generates a unique number for each new record, making it ideal for use as the primary key. This ensures that each record in a table has a unique identifier, which is important for maintaining data integrity and ensuring the accuracy of relationships between tables. A primary key is a key field that is used to uniquely identify each record in a table, and is often used to establish relationships between tables.

User Andre Coetzee
by
8.3k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.