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
Q44: A value set in the Field Properties
Q45: A primary key field from one table
Q48: Field name display in database objects such
Q50: The "one" table in a one-to-many relationship
Q56: In a single table,all _ must be
Q61: Explain how a one-to-many relationship is created
Q62: The "many" side of a one-to-many relationship
Q66: Discuss at least three advantages of including
Q67: List six guidelines for designing databases.
Q69: _ values are never allowed by Access
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents