Question 1

Validation rules serve as warnings; they do not actually prevent invalid data entry.

Accepted Answer

A) True 
 B)False  False

Question 2

Match the following terms with their descriptions:
i. Date function
II. Round function
III. DatePart function
IV. IIf function
v. IsNull function

Accepted Answer

A)  Checks to see if a field has no value entered into it 
B)  Calculates the current date 
C)  Returns a number to a certain number of decimal places 
D)  Evaluates a comparison as true or false and takes appropriate action 
E)  Examines a date and return a portion of it 
A)  Checks to see if a field has no value entered into it 
B)  Calculates the current date 
C)  Returns a number to a certain number of decimal places 
D)  Evaluates a comparison as true or false and takes appropriate action 
E)  Examines a date and return a portion of it B, C, E, D, A

Question 3

To enable the Input Mask Wizard, you press the Build button.

Accepted Answer

A) True 
 B)False  True

Question 4

Which of the following would not be a valid parameter query criterion?

Accepted Answer

A)  >=[Enter contract value] 
B)  [Enter contract value] 
D)  [Enter contract value] 
A)  >=[Enter contract value] 
B)  [Enter contract value] 
D)  [Enter contract value]

Question 5

Match the following terms with their descriptions:
I. Input mask
II. Lookup field
III. Lookup Wizard
IV. Parameter query
V. Input Mask Wizard
A. Predefined list of values presented in a menu
B. Criterion is provided when query is run
C. Took used to help create consistent formatting of data in a field
D. Helps create a list of predefined values
E. Setting that guarantees consistent formatting of data in a field

Accepted Answer

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

Question 6

Access automatically validates some data entry.

Accepted Answer

A) True 
 B)False

Question 7

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 8

Storing the characters in an input mask requires more disk space, so it is not recommended.

Accepted Answer

A) True 
 B)False

Question 9

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

Question 10

The Date function calculates the current date.

Accepted Answer

A) True 
 B)False

Question 11

Input masks can restrict the number of characters allowed in a field.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is often the first step in creating a lookup field?

Accepted Answer

A)  Create the lookup field. 
B)  Create a relationship between the lookup table and the table which has the lookup field. 
C)  Create a new table to hold the options. 
D)  Create a new query to hold the options. 
A)  Create the lookup field. 
B)  Create a relationship between the lookup table and the table which has the lookup field. 
C)  Create a new table to hold the options. 
D)  Create a new query to hold the options.

Question 13

What is a predefined list of values?

Accepted Answer

A)  Input mask 
B)  Input field 
C)  Lookup mask 
D)  Lookup field 
A)  Input mask 
B)  Input field 
C)  Lookup mask 
D)  Lookup field

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

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 16

Match the following with where they are found:
I. Parameters
II. Run (a query)
III. Criteria (in a query)
IV. Input Mask
V. Validation Text
A. Table Tools tab; Design tab; Field Properties; Input Mask row
B. Query Tools tab; Design tab; Show/Hide group
C. Table Tools tab; Design tab; Field Properties; Validation Text row
D. Query Tools tab; Design tab; Criteria row
E. Query Tools tab; Design tab; Results group

Accepted Answer

The answer of Match the following with where they are...

Question 17

Default values can be changed during data entry.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following functions evaluates whether a value has been entered into a field?

Accepted Answer

A)  IsEmpty 
B)  IsVoid 
C)  IsNull 
D)  Null 
A)  IsEmpty 
B)  IsVoid 
C)  IsNull 
D)  Null

Question 19

When is the criterion entered in a parameter query?

Accepted Answer

A)  When the query is created 
B)  When the query is saved 
C)  When the query is run 
D)  When the query is in SQL view 
A)  When the query is created 
B)  When the query is saved 
C)  When the query is run 
D)  When the query is in SQL view

Question 20

The ________ function calculates the current date.

Accepted Answer

The answer of The ________ function calculates the current date....

Validation rules serve as warnings; they do not actually prevent invalid data entry.

Match the following terms with their descriptions: i. Date function II. Round function III. DatePart function IV. IIf function v. IsNull function

To enable the Input Mask Wizard, you press the Build button.

Which of the following would not be a valid parameter query criterion?

Access automatically validates some data entry.

Storing the characters in an input mask requires more disk space, so it is not recommended.

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

The Date function calculates the current date.

Input masks can restrict the number of characters allowed in a field.

Which of the following is often the first step in creating a lookup field?

What is a predefined list of values?

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

When is validation text displayed?

Default values can be changed during data entry.

Which of the following functions evaluates whether a value has been entered into a field?

When is the criterion entered in a parameter query?

The ________ function calculates the current date.

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

Validation rules serve as warnings; they do not actually prevent invalid data entry.

Match the following terms with their descriptions: i. Date function II. Round function III. DatePart function IV. IIf function v. IsNull function

To enable the Input Mask Wizard, you press the Build button.

Which of the following would not be a valid parameter query criterion?

Access automatically validates some data entry.

Storing the characters in an input mask requires more disk space, so it is not recommended.

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

The Date function calculates the current date.

Input masks can restrict the number of characters allowed in a field.

Which of the following is often the first step in creating a lookup field?

What is a predefined list of values?

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

When is validation text displayed?

Default values can be changed during data entry.

Which of the following functions evaluates whether a value has been entered into a field?

When is the criterion entered in a parameter query?

The ________ function calculates the current date.

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