A set of rules that Access uses to make sure that the relationships you are forming between the records in your tables make sense are called ________.
A) table integrity
B) referential integrity
C) cascade rules
D) relationship rules

Question

Quizplus · Accepted Answer

Referential integrity rules ensure that records in related tables are linked correctly and that there are no orphan records. If you try to create a relationship that violates referential integrity, Access will not allow it. Table integrity refers to rules like data type and field size constraints. Cascade rules determine what happens to related records when a record in a primary table is deleted or updated. Relationship rules refer to the specific type of relationship you are creating, such as one-to-many or many-to-many.

A Set of Rules That Access Uses to Make Sure