To create a 1:1 relationship between two tables in Microsoft Access ________.
A) the Indexed property of the foreign key column must be set to No
B) the Indexed property of the foreign key column must be set to Yes (Duplicates OK)
C) the Indexed property of the foreign key column must be set to Yes (No Duplicates)
D) the Data Type of the foreign key column must be set to AutoNumber
E) the Smart Tag property of the foreign key column must be set to Foreign Key

Question

Quizplus · Accepted Answer

In a 1:1 relationship, there should be no duplicate values in the foreign key column, as every record in the primary table should have a matching record in the related table. Therefore, setting the Indexed property of the foreign key column to Yes (No Duplicates) ensures that there are no duplicate values.

To Create a 1:1 Relationship Between Two Tables in Microsoft