Question 1

If the primary key field on the "one" side of a one-to-many relationship has an AutoNumber data type, then the data type on the foreign key field must be set to AutoNumber .

Accepted Answer

A) True 
 B)False

Question 2

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 3

The ____ property determines whether users can add or edit the list of items in a Lookup field.

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

Which of the following is NOT shown on a Relationship report?

Accepted Answer

A)  table names 
B)  field names 
C)  primary key field data values 
D)  one-to-many relationship lines 
A)  table names 
B)  field names 
C)  primary key field data values 
D)  one-to-many relationship lines

Question 7

Which of the following is NOT a principle of relational database design?

Accepted Answer

A)  Design each table to contain fields that describe only one subject. 
B)  Identify a primary key field or key field combination for each table. 
C)  Data should be entered before table relationships are built. 
D)  Build one-to-many relationships between the tables of your database using a field common to each table. 
A)  Design each table to contain fields that describe only one subject. 
B)  Identify a primary key field or key field combination for each table. 
C)  Data should be entered before table relationships are built. 
D)  Build one-to-many relationships between the tables of your database using a field common to each table.

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Question 10

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 11

Field descriptions may be entered in Table Design View.

Accepted Answer

A) True 
 B)False

Question 12

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 13

When a Caption property is not entered, the field name is used to label the field.

Accepted Answer

A) True 
 B)False

Question 14

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 15

____ 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 16

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

Accepted Answer

A) True 
 B)False

Question 17

The ____ key field is the linking field on the "many" side of the relationship.

Accepted Answer

A)  record 
B)  table 
C)  link 
D)  foreign 
A)  record 
B)  table 
C)  link 
D)  foreign

Question 18

Match between columns
                        Premises: Stores numbers from 0 to 255
Stores numbers times 10 to the -38th to +38th power
Stores numbers from -2,147,483,648 to 2,147,483,647
Stores numbers in the range of 10 to the -324th to +324th power
Determines the largest number that can be entered in a field

Accepted Answer

The Answer of Double and Field size and Byte and is...

Question 19

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

Accepted Answer

The Customers table is in the

If the primary key field on the "one" side of a one-to-many relationship has an AutoNumber data type, then the data type on the foreign key field must be set to AutoNumber .

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

The ____ property determines whether users can add or edit the list of items in a Lookup field.

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.

Which of the following is NOT shown on a Relationship report?

Which of the following is NOT a principle of relational database design?

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

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

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

Field descriptions may be entered in Table Design View.

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

When a Caption property is not entered, the field name is used to label the field.

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

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

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

The ____ key field is the linking field on the "many" side of the relationship.

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

Getting Started With Microsoft Office 2013

Getting Started With Access 2013

Building and Using Queries

Using Forms

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Filters

Exam 5: Using Reports

If the primary key field on the "one" side of a one-to-many relationship has an AutoNumber data type, then the data type on the foreign key field must be set to AutoNumber .

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

The ____ property determines whether users can add or edit the list of items in a Lookup field.

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.

Which of the following is NOT shown on a Relationship report?

Which of the following is NOT a principle of relational database design?

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

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

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

Field descriptions may be entered in Table Design View.

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

When a Caption property is not entered, the field name is used to label the field.

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

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

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

The ____ key field is the linking field on the "many" side of the relationship.

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

Getting Started With Microsoft Office 2013

Getting Started With Access 2013

Building and Using Queries

Using Forms

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Filters