The inability to delete a parent record if it has subordinate or "child records" in a relational database is enforced by using "Referential Integrity" in Microsoft Access.

Question

Quizplus · Accepted Answer

Referential Integrity is a feature in relational databases that ensures that relationships between tables remain consistent. One aspect of referential integrity is preventing the deletion of a parent record if it has child records. In Microsoft Access, this is enforced by setting up a relationship between the tables and enabling "Cascade Delete Related Records" or "Restrict Delete Enforced".

The Inability to Delete a Parent Record If It Has