Question 1

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 Access allows users to define or modify table structures or field properties in a table.

Question 2

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 3

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 4

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 5

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 6

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

Accepted Answer

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

Question 7

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 8

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...

Question 9

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

This option updates all related records in other tables when the primary key value is changed in the original table to maintain referential integrity.

Question 10

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 11

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 to maintain referential integrity in the database.

Question 12

List six guidelines for designing databases.

Accepted Answer

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

Question 13

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 14

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. This is used instead of a single field primary key in cases where a combination of fields uniquely identifies a record.

Question 15

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.

Quiz 2: Building a Database and Defining Table Relationships

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. - 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.

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?

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

Discuss at least three advantages of including a primary key 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.

List six guidelines for designing databases.

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 primary key that consists of two or more fields in a table.

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.