Question 1

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 2

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 3

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

Data Type gallery is 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.

Question 4

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 a change in the value of the primary key in a table and changes the appropriate foreign key values in the related table to maintain referential integrity.

Question 5

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 6

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 7

List six guidelines for designing databases.

Accepted Answer

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

Question 8

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 9

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

Accepted Answer

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

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 Quick Start selection is a feature that allows users to add a group of fields all at once using the Data Type gallery.

Question 11

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 a table structure or field properties in a table.

Question 12

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 process described is known as "propagate," which involves updating the entire database to reflect changes made to a field's properties, ensuring consistency across all instances where the field is used.

Question 13

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 an Access feature that allows for the deletion of a record in the primary table and all related tables that have matching foreign key values. This helps to maintain referential integrity in the database.

Question 14

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 refers to the duplication of data in a database which can lead to inconsistencies and problems in data management.

Question 15

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.

Quiz 2: Building a Database and Defining Table Relationships

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?

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

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. -A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.

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

List six guidelines for designing databases.

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.

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

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 deletes a record in the primary table and also deletes all records in related tables that have matching foreign key values.

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