When you relate tables, Access uses a set of rules to ensure that there are matching values in the common field used to form the relationship, both at the time you create the relationship and as you enter data in the tables after you create the relationship. This set of rules is called ____.
A) referential integrity
B) security rules
C) match conditions
D) field rules

Question

Quizplus · Accepted Answer

Referential integrity ensures that each record in the related table has a matching value in the common field with at least one record in the primary table, preventing orphaned records and maintaining data consistency. It is a key feature of database design and helps ensure accurate query results and reports. The other choices are not accurate in describing this set of rules.

When You Relate Tables, Access Uses a Set of Rules