In Microsoft Access,referential integrity constraints are created:
A)by setting a property value on the primary key in the table which contains it.
B)by setting a property value on the foreign key in the table which contains it.
C)by setting a property value on the primary key in the Relationships window.
D)by setting a property value on the foreign key in the Relationships window.
E)by checking the Enforce Referential Integrity check box in the Edit Relationships dialog box.

Question

Quizplus · Accepted Answer

Referential integrity constraints can be created by checking the Enforce Referential Integrity checkbox in the Edit Relationships dialog box. This ensures that any data entered into the foreign key field matches a value in the primary key field of the related table. The other options may be related to setting specific properties on the keys, but they do not directly create referential integrity constraints.

In Microsoft Access,referential Integrity Constraints Are Created