Identify the letter of the choice that best matches the phrase or definition.

Question

A. The Access option that permits a change in the value of the primary key in a table and changes the appropriate foreign key values in the related table.
B. The Access option that deletes a record in the primary table and also deletes all records in related tables that have matching foreign key values.
C. A primary key that consists of two or more fields in a table.
D. The term used when the same data is stored in more than one place which can cause inconsistencies in the database.
E. An Access feature available from the FIELDS tab that allows the user to add a group of related fields to a table at the same time.
F. The Access database view that allows users to define or modify a table structure or field properties in a table.
G. A record in a table that is related to a primary table but has no matching record established with the primary table.
H. The process that occurs when the field Description (Optional) property is changed in Design View and the Property Update Options tool is used to update the entire database everywhere the field is used, including forms and reports.
I. A group of fields added all at once using the Data Type gallery.
J. A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.

Answer 1

A. Cascade Update Related Fields Option
B. Cascade Delete Related Records Option
C. Composite key
D. data redundancy
E. Data Type gallery
F. Design
G. orphaned record
H. propagate
I. Quick Start selection
J. referential integrity