Question 1

Reports cannot be based on parameter queries.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following input masks would produce the following formatting: the letters AC followed by a plus sign following by four required numbers?

Accepted Answer

A)  AC+0000 
B)  "AC+"0000 
C)  "AC+"9999 
D)  AC+9999 
A)  AC+0000 
B)  "AC+"0000 
C)  "AC+"9999 
D)  AC+9999

Question 3

If you wanted to just display the year in a date field, you would use which function?

Accepted Answer

A)  PartDate 
B)  DatePart 
C)  Date 
D)  YearPart 
A)  PartDate 
B)  DatePart 
C)  Date 
D)  YearPart

Question 4

A(n) ________ field is often used when there are a limited number of values in a field.

Accepted Answer

The answer of A(n) ________ field is often used when...

Question 5

Storing the options used in a lookup field in a separate table makes adding options easier.

Accepted Answer

A) True 
 B)False

Question 6

Match the following functions with when they would be used:
i. Date
II. DatePart
III. IIf
IV. Round
v. IsNull

Accepted Answer

A)  When you need to use today's date 
B)  When you need to display a number to four decimal places 
C)  When you need to do one action if a condition is true and another if a condition is false 
D)  When you need to see if a field was skipped in data entry 
E)  When you need to use only the month within a date 
A)  When you need to use today's date 
B)  When you need to display a number to four decimal places 
C)  When you need to do one action if a condition is true and another if a condition is false 
D)  When you need to see if a field was skipped in data entry 
E)  When you need to use only the month within a date

Question 7

Match the following terms with their descriptions:
I. Data validation
II. Validation text
III. Validation Rule
IV. Default value
V. Input Mask Wizard
A. Provides custom error message when incorrect data is entered
B. Value entered automatically when a record is created
C. A setting that limits what values can be entered in a field
D. Set of rules that help control the accuracy of data entry
E. Tool used to help create consistent formatting of data

Accepted Answer

The answer of Match the following terms with their descriptions:
I....

Question 8

________ validation helps to make sure that incorrect information is not entered in a field.

Accepted Answer

The answer of ________ validation helps to make sure that...

Question 9

A(n) ________ field is a predefined list of values.

Accepted Answer

The answer of A(n) ________ field is a predefined list...

Question 10

Which of the following is considered a custom error message?

Accepted Answer

A)  Caption text 
B)  Required text 
C)  Default text 
D)  Validation text 
A)  Caption text 
B)  Required text 
C)  Default text 
D)  Validation text

Question 11

Which of the following is a primary reason for manually setting up data validation?

Accepted Answer

A)  To make sure that two identical entries are not entered as the primary key 
B)  To make sure that fields, like phone numbers, display in a consistent format 
C)  To make sure that text is not entered into number fields 
D)  To reduce user entry errors 
A)  To make sure that two identical entries are not entered as the primary key 
B)  To make sure that fields, like phone numbers, display in a consistent format 
C)  To make sure that text is not entered into number fields 
D)  To reduce user entry errors

Question 12

The ________ value is entered automatically when a new record is created.

Accepted Answer

The answer of The ________ value is entered automatically when...

Question 13

For which of the following data types can you not change the Required field property?

Accepted Answer

A)  Hyperlink 
B)  AutoNumber 
C)  Long text 
D)  Calculated 
A)  Hyperlink 
B)  AutoNumber 
C)  Long text 
D)  Calculated

Question 14

Which of the following is not affected by inconsistent data?

Accepted Answer

A)  Sorting 
B)  Filtering 
C)  Queries 
D)  File size 
A)  Sorting 
B)  Filtering 
C)  Queries 
D)  File size

Question 15

A(n) ________ rule limits the values that can be entered in a field.

Accepted Answer

The answer of A(n) ________ rule limits the values that...

Question 16

To make sure that data entry personnel can only pick from existing items in a lookup field, you would check the Enable ________ Integrity check box.

Accepted Answer

The answer of To make sure that data entry personnel...

Reports cannot be based on parameter queries.

Which of the following input masks would produce the following formatting: the letters AC followed by a plus sign following by four required numbers?

If you wanted to just display the year in a date field, you would use which function?

A(n) ________ field is often used when there are a limited number of values in a field.

Storing the options used in a lookup field in a separate table makes adding options easier.

Match the following functions with when they would be used: i. Date II. DatePart III. IIf IV. Round v. IsNull

________ validation helps to make sure that incorrect information is not entered in a field.

A(n) ________ field is a predefined list of values.

Which of the following is considered a custom error message?

Which of the following is a primary reason for manually setting up data validation?

The ________ value is entered automatically when a new record is created.

For which of the following data types can you not change the Required field property?

Which of the following is not affected by inconsistent data?

A(n) ________ rule limits the values that can be entered in a field.

To make sure that data entry personnel can only pick from existing items in a lookup field, you would check the Enable ________ Integrity check box.

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters

Exam 6: Data Validation and Data Analysis

Reports cannot be based on parameter queries.

Which of the following input masks would produce the following formatting: the letters AC followed by a plus sign following by four required numbers?

If you wanted to just display the year in a date field, you would use which function?

A(n) ________ field is often used when there are a limited number of values in a field.

Storing the options used in a lookup field in a separate table makes adding options easier.

Match the following functions with when they would be used: i. Date II. DatePart III. IIf IV. Round v. IsNull

________ validation helps to make sure that incorrect information is not entered in a field.

A(n) ________ field is a predefined list of values.

Which of the following is considered a custom error message?

Which of the following is a primary reason for manually setting up data validation?

The ________ value is entered automatically when a new record is created.

For which of the following data types can you not change the Required field property?

Which of the following is not affected by inconsistent data?

A(n) ________ rule limits the values that can be entered in a field.

To make sure that data entry personnel can only pick from existing items in a lookup field, you would check the Enable ________ Integrity check box.

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters