In Microsoft Access,referential integrity constraints are created ________.
A)by checking the Enforce Referential Integrity check box in the Edit Relationships dialog box
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.

Question

Quizplus · Accepted Answer

Referential integrity constraints are created by checking the Enforce Referential Integrity check box in the Edit Relationships dialog box in Microsoft Access. This ensures that related tables are kept synchronized and ensures that there are no orphaned records in the database. Setting a property value on the foreign key or primary key alone does not establish referential integrity constraints.

In Microsoft Access,referential Integrity Constraints Are Created ________