Question 1

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

Accepted Answer

Relationsh

Question 2

Each field must be given an associated field description.

Accepted Answer

A) True 
 B)False

Question 3

A good Field Size property value for a state abbreviation field is ____.

Accepted Answer

A)  2 
B)  10 
C)  50 
D)  255 
A)  2 
B)  10 
C)  50 
D)  255

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

A(n) Number data type is used to store values that represent money.

Accepted Answer

A) True 
 B)False

Question 6

The Input Mask property provides a pattern for data to be entered using three parts.

Accepted Answer

A) True 
 B)False

Question 7

You can modify the Field Size property of a Number field.

Accepted Answer

A) True 
 B)False

Question 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

(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 11

The Field Properties pane displays information for how many fields at the same time?

Accepted Answer

A)  Only the selected field. 
B)  However many are visible in the window. 
C)  All of the fields in that particular table. 
D)  All of the fields in the entire database. 
A)  Only the selected field. 
B)  However many are visible in the window. 
C)  All of the fields in that particular table. 
D)  All of the fields in the entire database.

Question 12

In the accompanying figure, the one side of a one-to-many relationship is referenced by which item?

Accepted Answer

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

Question 13

The ____________________ property provides an easy-to-use visual pathway to facilitate accurate data entry.

Accepted Answer

The answer of The ____________________ property provides an easy-to-use visual...

Question 14

Where do you modify field properties?

Accepted Answer

A)  In Table Layout View. 
B)  In Table Design View. 
C)  In Database Design View 
D)  As you are entering data in a form. 
A)  In Table Layout View. 
B)  In Table Design View. 
C)  In Database Design View 
D)  As you are entering data in a form.

Question 15

A(n) ____ key field is the field used on the "one" side of a one-to-many relationship.

Accepted Answer

A)  primary 
B)  first 
C)  foreign 
D)  infinity 
A)  primary 
B)  first 
C)  foreign 
D)  infinity

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

You can modify the Field Size property of a Short Text field.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A)  primary key field 
B)  foreign key 
C)  field property 
D)  table name 
A)  primary key field 
B)  foreign key 
C)  field property 
D)  table name

Question 20

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

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

Each field must be given an associated field description.

A good Field Size property value for a state abbreviation field is ____.

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

A(n) Number data type is used to store values that represent money.

The Input Mask property provides a pattern for data to be entered using three parts.

You can modify the Field Size property of a Number field.

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

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

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

The Field Properties pane displays information for how many fields at the same time?

In the accompanying figure, the one side of a one-to-many relationship is referenced by which item?

The ____________________ property provides an easy-to-use visual pathway to facilitate accurate data entry.

Where do you modify field properties?

A(n) ____ key field is the field used on the "one" side of a one-to-many relationship.

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

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

You can modify the Field Size property of a Short Text field.

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

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

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

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

Each field must be given an associated field description.

A good Field Size property value for a state abbreviation field is ____.

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

A(n) Number data type is used to store values that represent money.

The Input Mask property provides a pattern for data to be entered using three parts.

You can modify the Field Size property of a Number field.

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

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

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

The Field Properties pane displays information for how many fields at the same time?

In the accompanying figure, the one side of a one-to-many relationship is referenced by which item?

The ____________________ property provides an easy-to-use visual pathway to facilitate accurate data entry.

Where do you modify field properties?

A(n) ____ key field is the field used on the "one" side of a one-to-many relationship.

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

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

You can modify the Field Size property of a Short Text field.

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

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

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