Chapter 4 - Section 3: Creating Relationships

Relationship

A link between two tables

Cascade Update Related Fields

A relationship option that changes data in a linked field automatically

Cascade Delete Related Records

A relationship option that deletes data in a linked field automatically

Enforce Referential Integrity

A relationship option that will not allow a record in the "one" table to be deleted or the primary key data to be changed if there are records in the "many" table that match that primary key

Primary Key

A unique identifier for a record

The _____ option in a relationship will delete records from one table that are related to records in another table.

Cascade Delete Related Records

The _____ option when creating a relationship will not allow data in a Primary Key field to be changed if the related table contains data from that Primary Key field.

Enforce Referential Integrity

If you delete a relationship, it is impossible to recreate it.

False

Lookup Field

Field that looks up and displays a list of data from another table or list that you type

Relationships create ______ between two tables.

Links

A ______ field is a field that displays a list of data from another table.

Lookup

The Lookup Wizard is used to create a _____ field.

Lookup

In a one-to-many relationship, the Foreign Key field is the _____ side of the relationship.

Many

In a one-to-many relationship, the Primary Key field is the _____ side of the relationship.

One

Foreign Key

The field that is not a Primary Key in a relationship

Lookup Wizard

Used to create a Lookup Field in the table Design View

Relationships window

Used to create, view, and edit relationships in a database

One-to-many relationship

When a Primary Key field in one table is linked to a field that is NOT a Primary Key in another table