Question 1

Access automatically validates some data entry.

Accepted Answer

A) True 
 B)False

Question 2

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 3

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 4

In proper database design, you should set the Required field property to Yes for ________ fields.

Accepted Answer

The answer of In proper database design, you should set...

Question 5

Validation ________ helps the data entry person know why the entry is being rejected.

Accepted Answer

The answer of Validation ________ helps the data entry person...

Question 6

To display the minute portion of a date, what would you put in the interval argument in the DatePart function?

Accepted Answer

A)  "n" 
B)  "m" 
C)  "t" 
D)  "min" 
A)  "n" 
B)  "m" 
C)  "t" 
D)  "min"

Question 7

The Date function calculates the current date.

Accepted Answer

A) True 
 B)False

Question 8

A(n) ________ mask specifies the exact formatting of data entry.

Accepted Answer

The answer of A(n) ________ mask specifies the exact formatting...

Question 9

If you wanted to display the day of the week using the DatePart function, you would put ________ in the interval argument.

Accepted Answer

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

Question 10

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 11

Which of the following is not data that can have an Input Mask applied without creating a custom mask?

Accepted Answer

A)  Phone number 
B)  Social Security number 
C)  Credit card number 
D)  Zip Code 
A)  Phone number 
B)  Social Security number 
C)  Credit card number 
D)  Zip Code

Question 12

Which of the following is not true about a parameter query?

Accepted Answer

A)  It reduces development time. 
B)  It can be run repeatedly. 
C)  The criterion parameters are fixed. 
D)  The criterion can vary each time it is run. 
A)  It reduces development time. 
B)  It can be run repeatedly. 
C)  The criterion parameters are fixed. 
D)  The criterion can vary each time it is run.

Question 13

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 14

Access allows for the creation of custom input masks.

Accepted Answer

A) True 
 B)False

Question 15

A parameter query is not a type of select query.

Accepted Answer

A) True 
 B)False

Question 16

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

Tables are a good source for data in a lookup field.

Accepted Answer

A) True 
 B)False

Access automatically validates some data entry.

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

What is a predefined list of values?

In proper database design, you should set the Required field property to Yes for ________ fields.

Validation ________ helps the data entry person know why the entry is being rejected.

To display the minute portion of a date, what would you put in the interval argument in the DatePart function?

The Date function calculates the current date.

A(n) ________ mask specifies the exact formatting of data entry.

If you wanted to display the day of the week using the DatePart function, you would put ________ in the interval argument.

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

Which of the following is not data that can have an Input Mask applied without creating a custom mask?

Which of the following is not true about a parameter query?

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

Access allows for the creation of custom input masks.

A parameter query is not a type of select query.

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

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

Which of the following is not affected by inconsistent data?

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

Tables are a good source for data in a lookup 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

Access automatically validates some data entry.

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

What is a predefined list of values?

In proper database design, you should set the Required field property to Yes for ________ fields.

Validation ________ helps the data entry person know why the entry is being rejected.

To display the minute portion of a date, what would you put in the interval argument in the DatePart function?

The Date function calculates the current date.

A(n) ________ mask specifies the exact formatting of data entry.

If you wanted to display the day of the week using the DatePart function, you would put ________ in the interval argument.

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

Which of the following is not data that can have an Input Mask applied without creating a custom mask?

Which of the following is not true about a parameter query?

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

Access allows for the creation of custom input masks.

A parameter query is not a type of select query.

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

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

Which of the following is not affected by inconsistent data?

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

Tables are a good source for data in a lookup 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