When a relationship is defined to enforce referential integrity and Cascade ________ Related Fields,Access will automatically change the data through all related tables when a revision is made to the data in the table that contains the primary key.
A) Update
B) Change
C) Delete
D) Remove

Question

Quizplus · Accepted Answer

When Cascade Update Related Fields is selected, Access will automatically update any related fields in other tables when a change is made to the primary key in the main table. This helps to maintain referential integrity across the database.

When a Relationship Is Defined to Enforce Referential Integrity and Cascade