Question 1

The Attachment data type is exactly the same as the OLE data type of previous versions of Access.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

The Answer of Single and Long integer and Byte and is...

Question 4

The Field Size property is not available for Currency fields.

Accepted Answer

A) True 
 B)False

Question 5

Property Tags are buttons that automatically appear in certain conditions.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

Anne Michael is working with the table shown below.  Explain what will happen when she works with the PaymentNo field in Datasheet View.

Accepted Answer

The PaymentNo field is an Auto

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

The Relationships button is found on the Design tab of the ribbon.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is a clue that a database needs to be redesigned?

Accepted Answer

A)  Key fields are defined for each table. 
B)  One-to-many relationships are defined for each table. 
C)  There are multiple tables in the database. 
D)  There is redundant data in one or more tables. 
A)  Key fields are defined for each table. 
B)  One-to-many relationships are defined for each table. 
C)  There are multiple tables in the database. 
D)  There is redundant data in one or more tables.

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

The Row ____________________ Lookup property stores the values for the drop-down list of a Lookup field.

Accepted Answer

The answer of The Row ____________________ Lookup property stores the...

Question 16

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 17

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

Accepted Answer

A)  09/06/2017 
B)  9/6/2017 
C)  9/6/17 
D)  09/06/17 
A)  09/06/2017 
B)  9/6/2017 
C)  9/6/17 
D)  09/06/17

Question 18

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 19

Which of the following is NOT a possible entry for the Field Size property of a Number field?

Accepted Answer

A)  Currency 
B)  Byte 
C)  Long Integer 
D)  Single 
A)  Currency 
B)  Byte 
C)  Long Integer 
D)  Single

Question 20

(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

The Attachment data type is exactly the same as the OLE data type of previous versions of Access.

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

The Field Size property is not available for Currency fields.

Property Tags are buttons that automatically appear in certain conditions.

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

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

Anne Michael is working with the table shown below. Explain what will happen when she works with the PaymentNo field in Datasheet View.

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

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

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

The Relationships button is found on the Design tab of the ribbon.

Which of the following is a clue that a database needs to be redesigned?

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

The Row ____________________ Lookup property stores the values for the drop-down list of a Lookup field.

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

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

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 a possible entry for the Field Size property of a Number field?

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

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 5: Modifying the Database Structure

The Attachment data type is exactly the same as the OLE data type of previous versions of Access.

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

The Field Size property is not available for Currency fields.

Property Tags are buttons that automatically appear in certain conditions.

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

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

Anne Michael is working with the table shown below. Explain what will happen when she works with the PaymentNo field in Datasheet View.

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

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

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

The Relationships button is found on the Design tab of the ribbon.

Which of the following is a clue that a database needs to be redesigned?

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

The Row ____________________ Lookup property stores the values for the drop-down list of a Lookup field.

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

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

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 a possible entry for the Field Size property of a Number field?

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

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters