Lesson 3: Table Relationships

Question 1

In MS Access, what helps you combine data from two different tables?

Answer 1

Relationship

Question 2

It keeps data accurate and ensures that you do not accidentally change or delete related data in one table but not in the other.

Answer 2

Referential Integrity

Question 3

When you enforce referential integrity and choose the _________ option then you update a primary key, MS Access automatically updates all fields that reference the primary key.

Answer 3

Cascade Update Related Fields

Question 4

When we create a foreign key using this option, it deletes the referencing rows in the child table when the referenced row is deleted in the parent table which has a primary key.

Answer 4

Cascade Delete Related Records

Question 5

It is the first field in each table of the database.

Answer 5

Primary Key

Question 6

MS Access uses this number to quickly pull information together when you run queries or reports.

Answer 6

Primary Key

Question 7

It is a field that is the primary field in its own table but shows up in another table.

Answer 7

Foreign Key

Question 8

A type of table relationship where a single record in the first table is related to only one record in the second table and vice versa.

Answer 8

One-to-One

Question 9

A type of table relationship where a single record in the first table can be related to one or more records in the second table, but a single record in the second table can be related to only one record in the first table.

Answer 9

One-to-Many

Question 10

A type of table relationship where a single record in the first table can be related to one or more records in the second tableanda single record in the second table can be related to one or more records in the first table.

Answer 10

Many-to-Many