The property of the primary key in a table in Microsoft Access should be set to:
A) The required field = "Yes", the Indexed field = "Yes (No Duplicates)"
B) The Required field = "NO" and the Indexed field = "Yes (No Duplicates)"
C) The Required field = "Yes" and the Indexed field = "Yes (Duplicated)"
D) The Required field = "NO" and the Indexed field = "No (Duplicates)"

Question

Quizplus · Accepted Answer

The primary key in a table should be set as a required field to ensure that every record has a value for the primary key, and it should be indexed with the option "Yes (No Duplicates)" to ensure that each value in the primary key is unique.

The Property of the Primary Key in a Table in Microsoft