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 Edit Relationships dialog box.

Question

Quizplus · Accepted Answer

Referential integrity constraints are created by checking the "Enforce Referential Integrity" check box in the Edit Relationships dialog box. This ensures that data in the related tables are consistent with each other by enforcing rules such as preventing deletion of a record in a primary key table if there are related records in a foreign key table.

In Microsoft Access,referential Integrity Constraints Are Created