Question 1

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 2

Which of the following is not true about validation text?

Accepted Answer

A)  It displays when a data violation has occurred. 
B)  It displays anytime a field is entered to aid in data entry. 
C)  It provides feedback on what was wrong with the data. 
D)  It is considered a custom error message. 
A)  It displays when a data violation has occurred. 
B)  It displays anytime a field is entered to aid in data entry. 
C)  It provides feedback on what was wrong with the data. 
D)  It is considered a custom error message.

Question 3

Between [Enter Start Date] And [Enter End Date] is a valid statement to use in a parameter query.

Accepted Answer

A) True 
 B)False

Question 4

Data validation is a ________.

Accepted Answer

A)  set of rules or constraints 
B)  set of formatting codes 
C)  set of masking characters 
D)  set of drop down options 
A)  set of rules or constraints 
B)  set of formatting codes 
C)  set of masking characters 
D)  set of drop down options

Question 5

You cannot change the Required field property after data has been entered.

Accepted Answer

A) True 
 B)False

Question 6

Match the following results with the proper DatePart formulas (assume a BirthDate of December 26, 1959 at 10:30 AM):
I. 1959
II. 12
III. 26
IV. 7
V. 10
A. =DatePart("h",[BirthDate])
B. =DatePart("w",[BirthDate])
C. =DatePart("d",[BirthDate])
D. =DatePart("m",[BirthDate])
E. =DatePart("yyyy",[BirthDate])

Accepted Answer

The answer of Match the following results with the proper...

Question 7

You can use the word Like in a data validation rule.

Accepted Answer

A) True 
 B)False

Question 8

When is validation text displayed?

Accepted Answer

A)  Whenever a field with a validation rule applied is entered 
B)  Each time there is not a validation rule violation 
C)  When a validation rule violation occurs 
D)  If the user presses F1 during data entry 
A)  Whenever a field with a validation rule applied is entered 
B)  Each time there is not a validation rule violation 
C)  When a validation rule violation occurs 
D)  If the user presses F1 during data entry

Question 9

To define how many decimal places should display, you can use the ________ function.

Accepted Answer

The answer of To define how many decimal places should...

Question 10

The default setting for the Required field property for most fields is ________.

Accepted Answer

The answer of The default setting for the Required field...

Question 11

Match the following types of data with the appropriate input masks:
I. Phone number
II. Long Time
III. Zip Code
IV. Short Time
V. Social Security Number
A. 00:00
B. 000-00-0000
C. 00000-9999
D. !(999) 000-0000
E. 99:00:00 >LL

Accepted Answer

The answer of Match the following types of data with...

Question 12

Data ________ is the process of controlling the data that is entered into a field.

Accepted Answer

The answer of Data ________ is the process of controlling...

Question 13

If you wanted to display just the month in a date, you would use the ________ function.

Accepted Answer

The answer of If you wanted to display just the...

Question 14

Match the following DatePart arguments with the data they would return:
I. "yyyy"
II. "n"
III. "h"
IV. "m"
V. "w"
A. Minute
B. Month
C. Year
D. Day of the Week
E. Hour

Accepted Answer

The answer of Match the following DatePart arguments with the...

Question 15

A field with a limited number of values is well suited for what type of field?

Accepted Answer

A)  Short Text 
B)  Calculated field 
C)  Lookup field 
D)  Hyperlink 
A)  Short Text 
B)  Calculated field 
C)  Lookup field 
D)  Hyperlink

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

Which of the following is not true about validation text?

Between [Enter Start Date] And [Enter End Date] is a valid statement to use in a parameter query.

Data validation is a ________.

You cannot change the Required field property after data has been entered.

You can use the word Like in a data validation rule.

When is validation text displayed?

To define how many decimal places should display, you can use the ________ function.

The default setting for the Required field property for most fields is ________.

Match the following types of data with the appropriate input masks: I. Phone number II. Long Time III. Zip Code IV. Short Time V. Social Security Number A. 00:00 B. 000-00-0000 C. 00000-9999 D. !(999) 000-0000 E. 99:00:00 >LL

Data ________ is the process of controlling the data that is entered into a field.

If you wanted to display just the month in a date, you would use the ________ function.

Match the following DatePart arguments with the data they would return: I. "yyyy" II. "n" III. "h" IV. "m" V. "w" A. Minute B. Month C. Year D. Day of the Week E. Hour

A field with a limited number of values is well suited for what type of field?

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters

Exam 5: Data Validation and Data Analysis

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

Which of the following is not true about validation text?

Between [Enter Start Date] And [Enter End Date] is a valid statement to use in a parameter query.

Data validation is a ________.

You cannot change the Required field property after data has been entered.

You can use the word Like in a data validation rule.

When is validation text displayed?

To define how many decimal places should display, you can use the ________ function.

The default setting for the Required field property for most fields is ________.

Match the following types of data with the appropriate input masks: I. Phone number II. Long Time III. Zip Code IV. Short Time V. Social Security Number A. 00:00 B. 000-00-0000 C. 00000-9999 D. !(999) 000-0000 E. 99:00:00 >LL

Data ________ is the process of controlling the data that is entered into a field.

If you wanted to display just the month in a date, you would use the ________ function.

Match the following DatePart arguments with the data they would return: I. "yyyy" II. "n" III. "h" IV. "m" V. "w" A. Minute B. Month C. Year D. Day of the Week E. Hour

A field with a limited number of values is well suited for what type of field?

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters