In Access, what Indexed option do you select to create an index on a field that might contain duplicate values but is not a primary key field?
A)Yes (Duplicates OK)
B)No
C)Yes (No Duplicates)
D)Yes (Duplicates Only)

Question

Quizplus · Accepted Answer

The correct option is "Yes (Duplicates OK)" because it allows the field to be indexed while permitting duplicate entries, which is necessary for fields that are not primary keys and might contain duplicates.

In Access, What Indexed Option Do You Select to Create