Question 1

Which of the following data types cannot have an input mask applied?

Accepted Answer

A) Number 
B) Long Text 
C) Short Text 
D) Date/Time 
A) Number 
B) Long Text 
C) Short Text 
D) Date/Time

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

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 5

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 6

The DatePart function always returns a number.

Accepted Answer

A) True 
 B)False

Question 7

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 8

The ________ function evaluates whether an expression is true or false.

Accepted Answer

The answer of The ________ function evaluates whether an expression...

Question 9

Which of the following provides for uniformity and consistency of data?

Accepted Answer

A) Lookup field 
B) Cell validation 
C) Field validation 
D) One-to-One relationships 
A) Lookup field 
B) Cell validation 
C) Field validation 
D) One-to-One relationships

Question 10

Which of the following comparative operators cannot be used in a data validation rule?

Accepted Answer

A)  
B) Between 
C) = 
A)  
B) Between 
C) =

Question 11

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

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 13

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 14

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 15

Although you can type an input mask manually,it is easier to use the Input Mask ________.

Accepted Answer

A) Template 
B) Wizard 
C) Guide 
D) Options 
A) Template 
B) Wizard 
C) Guide 
D) Options

Question 16

Match between columns
                        Premises: Is greater than 5000
Is less than or equal to 5000
Does not equal 5000
Is greater than or equal to 5000
Is less than 5000

Accepted Answer

The Answer of <5000 and >=5000 and <>5000 and >5000 is...

Question 17

Match between columns
                        Premises: Validation Text
Run (a query)
Parameters
Criteria (in a query)
Input Mask

Accepted Answer

The Answer of Query Tools tab; Design tab; Show/Hide group is...

Question 18

In the Round function,the precision cannot be a negative number.

Accepted Answer

A) True 
 B)False

Question 19

In a parameter query,if you do not specify a comparison operator,Access will assume equal to.

Accepted Answer

A) True 
 B)False

Question 20

An input mask is used to consistently format data.

Accepted Answer

A) True 
 B)False

Which of the following data types cannot have an input mask applied?

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

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

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

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

The DatePart function always returns a number.

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

The ________ function evaluates whether an expression is true or false.

Which of the following provides for uniformity and consistency of data?

Which of the following comparative operators cannot be used in a data validation rule?

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

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

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

When is validation text displayed?

Although you can type an input mask manually,it is easier to use the Input Mask ________.

In the Round function,the precision cannot be a negative number.

In a parameter query,if you do not specify a comparison operator,Access will assume equal to.

An input mask is used to consistently format data.

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

Which of the following data types cannot have an input mask applied?

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

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

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

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

The DatePart function always returns a number.

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

The ________ function evaluates whether an expression is true or false.

Which of the following provides for uniformity and consistency of data?

Which of the following comparative operators cannot be used in a data validation rule?

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

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

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

When is validation text displayed?

Although you can type an input mask manually,it is easier to use the Input Mask ________.

In the Round function,the precision cannot be a negative number.

In a parameter query,if you do not specify a comparison operator,Access will assume equal to.

An input mask is used to consistently format data.

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