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