Question 1

Identify the letter of the choice that best matches the phrase or definition.
-The term used when the same data is stored in more than one place which can cause inconsistencies in the database.
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

Accepted Answer

Data redundancy is the term used when the same data is stored in more than one place which can cause inconsistencies in the database.

Question 2

Identify the letter of the choice that best matches the phrase or definition.
-A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.
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

Accepted Answer

Referential integrity is a set of rules that Access uses to maintain consistency between related tables when data is updated in a database.

Question 3

Identify the letter of the choice that best matches the phrase or definition.
-A group of fields added all at once using the Data Type gallery.
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

Accepted Answer

The answer of Identify the letter of the choice that...

Question 4

Identify the letter of the choice that best matches the phrase or definition.
-The Access database view that allows users to define or modify a table structure or field properties in a table.
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

Accepted Answer

The "Design" view in Microsoft Access allows users to modify the structure of a table, including adding, removing, or modifying fields and their properties.

Question 5

Identify the letter of the choice that best matches the phrase or definition.
-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.
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

Accepted Answer

The answer of Identify the letter of the choice that...

Question 6

Identify the letter of the choice that best matches the phrase or definition.
-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)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

Accepted Answer

The Cascade Update Related Fields Option allows for changes in the primary key value to be propagated to corresponding foreign key values in related tables.

Question 7

Identify the letter of the choice that best matches the phrase or definition.
-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.
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

Accepted Answer

The Cascade Delete Related Records Option is 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. This helps maintain referential integrity in the database.

Question 8

____________________ values are never allowed by Access in the primary key field.

Accepted Answer

The answer of ____________________ values are never allowed by Access...

Question 9

Identify the letter of the choice that best matches the phrase or definition.
-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)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

Accepted Answer

The answer of Identify the letter of the choice that...

Question 10

The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.

Accepted Answer

The answer of The "many" side of a one-to-many relationship...

Question 11

Identify the letter of the choice that best matches the phrase or definition.
-A record in a table that is related to a primary table but has no matching record established with the primary table.
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

Accepted Answer

An orphaned record is a record in a table that is related to a primary table but has no matching record established with the primary table.

Question 12

Identify the letter of the choice that best matches the phrase or definition.
-A primary key that consists of two or more fields in a table.
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

Accepted Answer

A composite key is a primary key that consists of two or more fields in a table. It is used to uniquely identify a record in a database table.

Question 13

List six guidelines for designing databases.

Accepted Answer

The answer of List six guidelines for designing databases....

Question 14

Explain how a one-to-many relationship is created using an Access database with two or more tables.Why is it useful to create a relationship between tables?

Accepted Answer

The answer of Explain how a one-to-many relationship is created...

Question 15

Discuss at least three advantages of including a primary key in a table.

Accepted Answer

The answer of Discuss at least three advantages of including...

Quiz 2: Building a Database and Defining Table Relationships

Identify the letter of the choice that best matches the phrase or definition. -The term used when the same data is stored in more than one place which can cause inconsistencies in the database.

Identify the letter of the choice that best matches the phrase or definition. -A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.

Identify the letter of the choice that best matches the phrase or definition. -A group of fields added all at once using the Data Type gallery.

Identify the letter of the choice that best matches the phrase or definition. -The Access database view that allows users to define or modify a table structure or field properties in a table.

Identify the letter of the choice that best matches the phrase or definition. -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.

Identify the letter of the choice that best matches the phrase or definition. -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.

____________________ values are never allowed by Access in the primary key field.

Identify the letter of the choice that best matches the phrase or definition. -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.

The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.

Identify the letter of the choice that best matches the phrase or definition. -A record in a table that is related to a primary table but has no matching record established with the primary table.

Identify the letter of the choice that best matches the phrase or definition. -A primary key that consists of two or more fields in a table.

List six guidelines for designing databases.

Explain how a one-to-many relationship is created using an Access database with two or more tables.Why is it useful to create a relationship between tables?

Discuss at least three advantages of including a primary key in a table.