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 = "Yes (Duplicated)".

Question

Quizplus · Accepted Answer

The primary key should be a required field to ensure that each record has a unique identifier. It should also be indexed to improve query performance. The option "Yes (No Duplicates)" ensures that duplicate values cannot be entered as the primary key.

The Property of the Primary Key in a Table in Microsoft