Question 1

In the accompanying figure, item 2 points to a(n) ____.

Accepted Answer

A)  referential integrity symbol 
B)  orphan record symbol 
C)  subdatasheet symbol 
D)  primary key field symbol 
A)  referential integrity symbol 
B)  orphan record symbol 
C)  subdatasheet symbol 
D)  primary key field symbol

Question 2

You can edit or delete a relationship once it has been created in the Relationships window.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following is NOT defined in Table Design View?

Accepted Answer

A)  field names 
B)  field entries 
C)  data types 
D)  field properties 
A)  field names 
B)  field entries 
C)  data types 
D)  field properties

Question 4

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

Accepted Answer

A)  indexes 
B)  tables 
C)  links 
D)  properties 
A)  indexes 
B)  tables 
C)  links 
D)  properties

Question 5

Using the accompanying figure, list three principles of relational database design. Use the specific table and field names in your explanation.

Accepted Answer

1.  Design each table to contain fields

Question 6

A common place to use an Input Mask property would be for a Phone Number field.

Accepted Answer

A) True 
 B)False

Question 7

The Validation Rule property is not used with Text or Date/Time fields.

Accepted Answer

A) True 
 B)False

Question 8

The Input Mask property contains how many parts?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 9

Use the ____ property to display an explanatory message when a user tries to enter data that breaks a validation rule.

Accepted Answer

A)  Validation Rule 
B)  Description Rule 
C)  Input Mask 
D)  Validation Text 
A)  Validation Rule 
B)  Description Rule 
C)  Input Mask 
D)  Validation Text

Question 10

____ properties allow you to supply a drop-down list of values for a field.

Accepted Answer

A)  Key 
B)  Relationship 
C)  Lookup 
D)  Junction 
A)  Key 
B)  Relationship 
C)  Lookup 
D)  Junction

Question 11

Field descriptions may be entered in Table Design View. _________________________

Accepted Answer

A) True 
 B)False

Question 12

The ____ property provides a label used to describe the field.

Accepted Answer

A)  Format 
B)  Caption 
C)  Input Mask 
D)  Default Value 
A)  Format 
B)  Caption 
C)  Input Mask 
D)  Default Value

Question 13

The Enforce Referential Integrity button is found on the DESIGN tab of the ribbon.

Accepted Answer

A) True 
 B)False

Question 14

Kelsey wants to create queries to answer management questions from a relational database she does not have much experience with.  Why might a Relationships report help her create the queries?

Accepted Answer

A Relationship report would show her how

Question 15

A subdatasheet is used to modify field properties.

Accepted Answer

A) True 
 B)False

Question 16

Referential integrity allows the user to delete a record from the "one" table if it has matching records in the "many" table.

Accepted Answer

A) True 
 B)False

Question 17

Byte, Long Integer, Single, and Double are examples of entries for which property?

Accepted Answer

A)  Field Size 
B)  Format 
C)  Input Mask 
D)  Validation Rule 
A)  Field Size 
B)  Format 
C)  Input Mask 
D)  Validation Rule

Question 18

Which of the following is NOT a good candidate for a primary key field for a Customer table?

Accepted Answer

A)  Last Name 
B)  Customer Number 
C)  Employee Identification Number 
D)  Customer ID 
A)  Last Name 
B)  Customer Number 
C)  Employee Identification Number 
D)  Customer ID

Question 19

In the accompanying figure, item 4 references a(n) ____.

Accepted Answer

A)  infinity symbol 
B)  table name 
C)  relationship 
D)  link line 
A)  infinity symbol 
B)  table name 
C)  relationship 
D)  link line

Question 20

To quickly remove all Lookup properties, change the Display Control property to Combo Box. 
_________________________

Accepted Answer

A) True 
 B)False

In the accompanying figure, item 2 points to a(n) ____.

You can edit or delete a relationship once it has been created in the Relationships window.

Which of the following is NOT defined in Table Design View?

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

Using the accompanying figure, list three principles of relational database design. Use the specific table and field names in your explanation.

A common place to use an Input Mask property would be for a Phone Number field.

The Validation Rule property is not used with Text or Date/Time fields.

The Input Mask property contains how many parts?

Use the ____ property to display an explanatory message when a user tries to enter data that breaks a validation rule.

____ properties allow you to supply a drop-down list of values for a field.

Field descriptions may be entered in Table Design View. _________________________

The ____ property provides a label used to describe the field.

The Enforce Referential Integrity button is found on the DESIGN tab of the ribbon.

Kelsey wants to create queries to answer management questions from a relational database she does not have much experience with. Why might a Relationships report help her create the queries?

A subdatasheet is used to modify field properties.

Referential integrity allows the user to delete a record from the "one" table if it has matching records in the "many" table.

Byte, Long Integer, Single, and Double are examples of entries for which property?

Which of the following is NOT a good candidate for a primary key field for a Customer table?

In the accompanying figure, item 4 references a(n) ____.

To quickly remove all Lookup properties, change the Display Control property to Combo Box. _________________________

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 5: Modifying the Database Structure

In the accompanying figure, item 2 points to a(n) ____.

You can edit or delete a relationship once it has been created in the Relationships window.

Which of the following is NOT defined in Table Design View?

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

Using the accompanying figure, list three principles of relational database design. Use the specific table and field names in your explanation.

A common place to use an Input Mask property would be for a Phone Number field.

The Validation Rule property is not used with Text or Date/Time fields.

The Input Mask property contains how many parts?

Use the ____ property to display an explanatory message when a user tries to enter data that breaks a validation rule.

____ properties allow you to supply a drop-down list of values for a field.

Field descriptions may be entered in Table Design View. _________________________

The ____ property provides a label used to describe the field.

The Enforce Referential Integrity button is found on the DESIGN tab of the ribbon.

Kelsey wants to create queries to answer management questions from a relational database she does not have much experience with. Why might a Relationships report help her create the queries?

A subdatasheet is used to modify field properties.

Referential integrity allows the user to delete a record from the "one" table if it has matching records in the "many" table.

Byte, Long Integer, Single, and Double are examples of entries for which property?

Which of the following is NOT a good candidate for a primary key field for a Customer table?

In the accompanying figure, item 4 references a(n) ____.

To quickly remove all Lookup properties, change the Display Control property to Combo Box. _________________________

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters