Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
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.
A primary key that consists of two or more fields in a table.
A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.
A record in a table that is related to a primary table but has no matching record established with the primary table.
The term used when the same data is stored in more than one place which can cause inconsistencies in the database.
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.
The Access database view that allows users to define or modify a table structure or field properties in a table.
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.
A group of fields added all at once using the Data Type gallery.
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.
Responses:
Quick Start selection
Data Type gallery
Cascade Update Related Fields Option
referential integrity
Composite key
data redundancy
Cascade Delete Related Records Option
Design
propagate
orphaned record
Correct Answer:
Premises:
Responses:
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.
A primary key that consists of two or more fields in a table.
A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.
A record in a table that is related to a primary table but has no matching record established with the primary table.
The term used when the same data is stored in more than one place which can cause inconsistencies in the database.
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.
The Access database view that allows users to define or modify a table structure or field properties in a table.
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.
A group of fields added all at once using the Data Type gallery.
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.
Premises:
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.
A primary key that consists of two or more fields in a table.
A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.
A record in a table that is related to a primary table but has no matching record established with the primary table.
The term used when the same data is stored in more than one place which can cause inconsistencies in the database.
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.
The Access database view that allows users to define or modify a table structure or field properties in a table.
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.
A group of fields added all at once using the Data Type gallery.
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.
Responses:
Related Questions
Q12: Access does not require a table to
Q16: Field name display in database objects such
Q17: The _ property specifies the number of
Q21: Performing a(n)_ is the process of relating
Q26: The way field values are stored,displayed,and processed
Q31: _ is the default name for a
Q37: One rule of _ is that Access
Q50: A field used to connect one table
Q60: A relationship between Access tables that is
Q61: Which symbols would be used to create