Question 1

To edit the list of values for a Lookup Field in Datasheet View, click the Edit List Items button.
_________________________

Accepted Answer

A) True 
 B)False

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 a problem with duplicated data?

Accepted Answer

A)  It is error-prone. 
B)  It limits query capabilities. 
C)  It limits reporting capabilities. 
D)  It creates its own one-to-many relationships. 
A)  It is error-prone. 
B)  It limits query capabilities. 
C)  It limits reporting capabilities. 
D)  It creates its own one-to-many relationships.

Question 4

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 5

The table that joins to other tables that have many-to-many relationship is called the ____ table.

Accepted Answer

A)  junction 
B)  linking 
C)  primary 
D)  relational 
A)  junction 
B)  linking 
C)  primary 
D)  relational

Question 6

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 7

Modifying the Decimal Places property changes the way the data is presented.

Accepted Answer

A) True 
 B)False

Question 8

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 9

A printout of the Relationships window is called the ____________________ report.

Accepted Answer

Relationsh

Question 10

Changing the Decimal Places property for a field does not change the actual data stored in the field.

Accepted Answer

A) True 
 B)False

Question 11

-In the accompanying figure, identify the "one" and "many" tables. Identify the "parent" and "child" tables.

Accepted Answer

The Customers table is in the

Question 12

In the accompanying figure, the data type of the PaymentDate field is ____________________.

Accepted Answer

The answer of In the accompanying figure, the data type...

Question 13

Enforcing referential integrity guarantees that inaccurate data is not entered into any field.

Accepted Answer

A) True 
 B)False

Question 14

The ____ Lookup property determines whether you can enter a new value into a field with other Lookup properties.

Accepted Answer

A)  Row Source 
B)  Limit to List 
C)  Allow Value List Edits 
D)  Display Control 
A)  Row Source 
B)  Limit to List 
C)  Allow Value List Edits 
D)  Display Control

Question 15

Which Short Text field property should you use to specify whether an entry was required for the field?

Accepted Answer

A)  Default Value 
B)  Default 
C)  Required 
D)  Test 
A)  Default Value 
B)  Default 
C)  Required 
D)  Test

Question 16

(999)000-000;1;_ would be a possible entry for which field property?

Accepted Answer

A)  Format 
B)  Input Mask 
C)  Caption 
D)  Validation Rule 
A)  Format 
B)  Input Mask 
C)  Caption 
D)  Validation Rule

Question 17

The entry mm/dd/yyyy in a Date/Time field's Format property would display September 6, 2016 as: ____.

Accepted Answer

A)  09/06/2016 
B)  9/6/2016 
C)  9/6/16 
D)  09/06/16 
A)  09/06/2016 
B)  9/6/2016 
C)  9/6/16 
D)  09/06/16

Question 18

-In the accompanying figure, the ____________________ field would be the best candidate for the primary key field.

Accepted Answer

The answer of  
-In the accompanying figure, the ____________________...

Question 19

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 20

The goal of building one-to-many relationships between tables is to minimize ____ data.

Accepted Answer

A)  redundant 
B)  textual 
C)  numeric 
D)  rarely used 
A)  redundant 
B)  textual 
C)  numeric 
D)  rarely used

To edit the list of values for a Lookup Field in Datasheet View, click the Edit List Items button. _________________________

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

Which of the following is NOT a problem with duplicated data?

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

The table that joins to other tables that have many-to-many relationship is called the ____ table.

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

Modifying the Decimal Places property changes the way the data is presented.

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

A printout of the Relationships window is called the ____________________ report.

Changing the Decimal Places property for a field does not change the actual data stored in the field.

-In the accompanying figure, identify the "one" and "many" tables. Identify the "parent" and "child" tables.

In the accompanying figure, the data type of the PaymentDate field is ____________________.

Enforcing referential integrity guarantees that inaccurate data is not entered into any field.

The ____ Lookup property determines whether you can enter a new value into a field with other Lookup properties.

Which Short Text field property should you use to specify whether an entry was required for the field?

(999)000-000;1;_ would be a possible entry for which field property?

The entry mm/dd/yyyy in a Date/Time field's Format property would display September 6, 2016 as: ____.

-In the accompanying figure, the ____________________ field would be the best candidate for the primary key field.

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?

The goal of building one-to-many relationships between tables is to minimize ____ data.

Getting Started With Microsoft Office 2013

Getting Started With Chapter 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 Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 6: Modifying the Database Structure

To edit the list of values for a Lookup Field in Datasheet View, click the Edit List Items button. _________________________

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

Which of the following is NOT a problem with duplicated data?

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

The table that joins to other tables that have many-to-many relationship is called the ____ table.

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

Modifying the Decimal Places property changes the way the data is presented.

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

A printout of the Relationships window is called the ____________________ report.

Changing the Decimal Places property for a field does not change the actual data stored in the field.

-In the accompanying figure, identify the "one" and "many" tables. Identify the "parent" and "child" tables.

In the accompanying figure, the data type of the PaymentDate field is ____________________.

Enforcing referential integrity guarantees that inaccurate data is not entered into any field.

The ____ Lookup property determines whether you can enter a new value into a field with other Lookup properties.

Which Short Text field property should you use to specify whether an entry was required for the field?

(999)000-000;1;_ would be a possible entry for which field property?

The entry mm/dd/yyyy in a Date/Time field's Format property would display September 6, 2016 as: ____.

-In the accompanying figure, the ____________________ field would be the best candidate for the primary key field.

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?

The goal of building one-to-many relationships between tables is to minimize ____ data.

Getting Started With Microsoft Office 2013

Getting Started With Chapter 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 Modules and Vba

Administering the Database

Chapter Access and the Web

Filters