Question 1

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 2

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 3

Match the following common Number field properties with the correct description.
-Stores numbers times 10 to the -38th to +38th power

Accepted Answer

A) Long integer 
B) Single 
C) Byte 
D) Field size 
E) Double 
A) Long integer 
B) Single 
C) Byte 
D) Field size 
E) Double

Question 4

Match the following common Number field properties with the correct description.
-Stores numbers from 0 to 255

Accepted Answer

A) Long integer 
B) Single 
C) Byte 
D) Field size 
E) Double 
A) Long integer 
B) Single 
C) Byte 
D) Field size 
E) Double

Question 5

Match the following common Number field properties with the correct description.
-Stores numbers from -2,147,483,648 to 2,147,483,647

Accepted Answer

A) Long integer 
B) Single 
C) Byte 
D) Field size 
E) Double 
A) Long integer 
B) Single 
C) Byte 
D) Field size 
E) Double

Question 6

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

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

Accepted Answer

A) True 
 B)False

Question 8

You can enter optional field descriptions in Table ____ View.

Accepted Answer

A)  SQL 
B)  Query 
C)  Design 
D)  Layout 
A)  SQL 
B)  Query 
C)  Design 
D)  Layout

Question 9

-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 10

The Field Size property is not available for Currency fields.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 13

-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 14

The . jpg file extension is short for JPEG, an acronym for the Joint Photographic Experts Group. _________________________

Accepted Answer

A) True 
 B)False

Question 15

For a Date/Time field, use the Format property to display the date 1/17/2015 as January 17, 2015.

Accepted Answer

A) True 
 B)False

Question 16

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

Accepted Answer

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

Question 17

To move a field list in the Relationships window, drag the table's primary key field. _________________________

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is NOT true about field properties?

Accepted Answer

A)  Modifying them helps ensure database accuracy. 
B)  Some are required, and some are optional. 
C)  They are the same for each data type. 
D)  They can be used to change the way data is displayed. 
A)  Modifying them helps ensure database accuracy. 
B)  Some are required, and some are optional. 
C)  They are the same for each data type. 
D)  They can be used to change the way data is displayed.

Question 19

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 20

Match the following common Number field properties with the correct description.
-Stores numbers in the range of 10 to the -324th to +324th power

Accepted Answer

A) Long integer 
B) Single 
C) Byte 
D) Field size 
E) Double 
A) Long integer 
B) Single 
C) Byte 
D) Field size 
E) Double

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

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

Match the following common Number field properties with the correct description. -Stores numbers times 10 to the -38th to +38th power

Match the following common Number field properties with the correct description. -Stores numbers from 0 to 255

Match the following common Number field properties with the correct description. -Stores numbers from -2,147,483,648 to 2,147,483,647

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

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

You can enter optional field descriptions in Table ____ View.

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

The Field Size property is not available for Currency fields.

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

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

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

The . jpg file extension is short for JPEG, an acronym for the Joint Photographic Experts Group. _________________________

For a Date/Time field, use the Format property to display the date 1/17/2015 as January 17, 2015.

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

To move a field list in the Relationships window, drag the table's primary key field. _________________________

Which of the following is NOT true about field properties?

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

Match the following common Number field properties with the correct description. -Stores numbers in the range of 10 to the -324th to +324th power

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

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

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

Match the following common Number field properties with the correct description. -Stores numbers times 10 to the -38th to +38th power

Match the following common Number field properties with the correct description. -Stores numbers from 0 to 255

Match the following common Number field properties with the correct description. -Stores numbers from -2,147,483,648 to 2,147,483,647

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

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

You can enter optional field descriptions in Table ____ View.

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

The Field Size property is not available for Currency fields.

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

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

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

The . jpg file extension is short for JPEG, an acronym for the Joint Photographic Experts Group. _________________________

For a Date/Time field, use the Format property to display the date 1/17/2015 as January 17, 2015.

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

To move a field list in the Relationships window, drag the table's primary key field. _________________________

Which of the following is NOT true about field properties?

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

Match the following common Number field properties with the correct description. -Stores numbers in the range of 10 to the -324th to +324th power

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