BusIM - Unit 3, Lesson 2, Part 1

Match it! Select the correct answer from the pull down...Good luck!

A system of rules that Access uses to ensure that relationships between records in related tables are valid, and that you don’t accidentally delete or change related data.

Records in a related table (on the “many” side) that are left unrelated if their related record in the primary table is deleted or changed so that the relationship is broken.

The association between two tables that share a field with matching values; the matching fields allow the tables to be joined, so that a query can select data from both tables.

One or more fields in a table whose values uniquely identify each record.

The table on the “many” side of a one-to-many relationship.

The table on the “one” side of a one-to-many relationship.

A relationship between two tables in which each table can have many related records in the other table is called a (?)

A relationship between two tables in which only one table (the primary table) can have many related records in the other table (the related table) is called a