Question 1

List six guidelines for designing databases.

Accepted Answer

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

Question 2

Match between columns
                        Premises: The term used when the same data is stored in more than one place which can cause inconsistencies in the database.

Accepted Answer

The Answer of Cascade Delete Related Records Option and data is...

Question 3

Match between columns
                        Premises: 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.

Accepted Answer

The Answer of data redundancy and Cascade Delete Related Records is...

Question 4

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 5

Match between columns
                        Premises: A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.

Accepted Answer

The Answer of data redundancy and Quick Start selection and is...

Question 6

Match between columns
                        Premises: 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.

Accepted Answer

The Answer of Cascade Update Related Fields Option and Quick is...

Question 7

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 8

Match between columns
                        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.

Accepted Answer

The Answer of orphaned record and Cascade Update Related Fields is...

Question 9

Match between columns
                        Premises: A record in a table that is related to a primary table but has no matching record established with the primary table.

Accepted Answer

The Answer of Composite key and propagate and orphaned record is...

Question 10

Match between columns
                        Premises: The Access database view that allows users to define or modify a table structure or field properties in a table.

Accepted Answer

The Answer of Design and Data Type gallery and Cascade is...

Question 11

Match between columns
                        Premises: 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.

Accepted Answer

The Answer of Cascade Delete Related Records Option and Design is...

Question 12

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

Accepted Answer

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

Question 13

Match between columns
                        Premises: A group of fields added all at once using the Data Type gallery.

Accepted Answer

The Answer of Data Type gallery and Design and propagate is...

Question 14

Match between columns
                        Premises: A primary key that consists of two or more fields in a table.

Accepted Answer

The Answer of referential integrity and Quick Start selection and is...

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

List six guidelines for designing databases.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

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.

Identify the letter of the choice that best matches the phrase or definition.

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?

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

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

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

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