Question 1

A(n) ________ forces data entry into a table or form to conform to a specific format.

Accepted Answer

The answer of A(n) ________ forces data entry into a...

Question 2

An Access expression that calculates lapsed time is called ________.

Accepted Answer

The answer of An Access expression that calculates lapsed time...

Question 3

[Enter city] on the criteria line of a query is an example of the criteria in a parameter query.

Accepted Answer

A) True 
 B)False

Question 4

Which data validation property specifies a value that is automatically entered into a field?

Accepted Answer

A)  Default value 
B)  Validation rule 
C)  Input mask 
D)  Required 
A)  Default value 
B)  Validation rule 
C)  Input mask 
D)  Required

Question 5

You can use Date() in the default value property to insert the current date when a new record is added.

Accepted Answer

A) True 
 B)False

Question 6

Assuming a hire date of February 15, 2017, which of the following date part functions would return the number of days since the beginning of the current year?

Accepted Answer

A)  DatePart("yyyy",[HireDate]) 
B)  DatePart("y",[HireDate]) 
C)  DatePart ("q",{HireDate]) 
D)  DarePart("w",[HireDate]) 
A)  DatePart("yyyy",[HireDate]) 
B)  DatePart("y",[HireDate]) 
C)  DatePart ("q",{HireDate]) 
D)  DarePart("w",[HireDate])

Question 7

________ is the first method for controlling data input in a field of a table.

Accepted Answer

A)  Selecting an appropriate data type 
B)  Creating an appropriate default value 
C)  Creating an appropriate validation rule 
D)  Creating a data macro 
A)  Selecting an appropriate data type 
B)  Creating an appropriate default value 
C)  Creating an appropriate validation rule 
D)  Creating a data macro

Question 8

When data is entered, a(n) ________ is used to have a consistent format.

Accepted Answer

A)  data macro 
B)  field property 
C)  data validation rule 
D)  input mask 
A)  data macro 
B)  field property 
C)  data validation rule 
D)  input mask

Question 9

When creating a lookup list for the State field, what must you also consider?

Accepted Answer

U.S. Postal Service recognizes

Question 10

Reports can be created based on the results of a parameter query.

Accepted Answer

A) True 
 B)False

Question 11

A(n) ________ allows the user to select a field value from a list of options.

Accepted Answer

A)  input mask 
B)  lookup field 
C)  field property 
D)  data macro 
A)  input mask 
B)  lookup field 
C)  field property 
D)  data macro

Question 12

Which data validation method provides an error message when a validation rule has been broken?

Accepted Answer

A)  Validation text 
B)  Required field 
C)  Input mask 
D)  Default value 
A)  Validation text 
B)  Required field 
C)  Input mask 
D)  Default value

Question 13

When two functions are not sufficient to evaluate an expression, you may need to use a(n):

Accepted Answer

A)  Nested function. 
B)  IsNull function. 
C)  Round function. 
D)  Parameter query. 
A)  Nested function. 
B)  IsNull function. 
C)  Round function. 
D)  Parameter query.

Question 14

Why would you set a default value for a field?

Accepted Answer

A default value is used when t

Question 15

An input mask can be used when there is a common value in many records.

Accepted Answer

A) True 
 B)False

Question 16

The options for a lookup field can be stored in a separate table.

Accepted Answer

A) True 
 B)False

Question 17

Which data validation method forces data entry in a field?

Accepted Answer

A)  Required 
B)  Default value 
C)  Data macro 
D)  Validation rule 
A)  Required 
B)  Default value 
C)  Data macro 
D)  Validation rule

Question 18

A(n) ________ accepts two or more options in a lookup field.

Accepted Answer

A)  multiple-value field 
B)  input mask 
C)  lookup list 
D)  required 
A)  multiple-value field 
B)  input mask 
C)  lookup list 
D)  required

Question 19

Which of the following function checks to see if a field has no value?

Accepted Answer

A)  IsNull 
B)  Sum 
C)  Average 
D)  IsNotNull 
A)  IsNull 
B)  Sum 
C)  Average 
D)  IsNotNull

Question 20

________ is the correct syntax for the Round function.

Accepted Answer

A)  Round(expression, precision) 
B)  Round(expression) 
C)  Round(expression, truepart, falsepart) 
D)  Round(expression, interval) 
A)  Round(expression, precision) 
B)  Round(expression) 
C)  Round(expression, truepart, falsepart) 
D)  Round(expression, interval)

A(n) ________ forces data entry into a table or form to conform to a specific format.

An Access expression that calculates lapsed time is called ________.

[Enter city] on the criteria line of a query is an example of the criteria in a parameter query.

Which data validation property specifies a value that is automatically entered into a field?

You can use Date() in the default value property to insert the current date when a new record is added.

Assuming a hire date of February 15, 2017, which of the following date part functions would return the number of days since the beginning of the current year?

________ is the first method for controlling data input in a field of a table.

When data is entered, a(n) ________ is used to have a consistent format.

When creating a lookup list for the State field, what must you also consider?

Reports can be created based on the results of a parameter query.

A(n) ________ allows the user to select a field value from a list of options.

Which data validation method provides an error message when a validation rule has been broken?

When two functions are not sufficient to evaluate an expression, you may need to use a(n):

Why would you set a default value for a field?

An input mask can be used when there is a common value in many records.

The options for a lookup field can be stored in a separate table.

Which data validation method forces data entry in a field?

A(n) ________ accepts two or more options in a lookup field.

Which of the following function checks to see if a field has no value?

________ is the correct syntax for the Round function.

Introduction to Access: Finding Your Way Through an Access Database

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters

Exam 5: Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

A(n) ________ forces data entry into a table or form to conform to a specific format.

An Access expression that calculates lapsed time is called ________.

[Enter city] on the criteria line of a query is an example of the criteria in a parameter query.

Which data validation property specifies a value that is automatically entered into a field?

You can use Date() in the default value property to insert the current date when a new record is added.

Assuming a hire date of February 15, 2017, which of the following date part functions would return the number of days since the beginning of the current year?

________ is the first method for controlling data input in a field of a table.

When data is entered, a(n) ________ is used to have a consistent format.

When creating a lookup list for the State field, what must you also consider?

Reports can be created based on the results of a parameter query.

A(n) ________ allows the user to select a field value from a list of options.

Which data validation method provides an error message when a validation rule has been broken?

When two functions are not sufficient to evaluate an expression, you may need to use a(n):

Why would you set a default value for a field?

An input mask can be used when there is a common value in many records.

The options for a lookup field can be stored in a separate table.

Which data validation method forces data entry in a field?

A(n) ________ accepts two or more options in a lookup field.

Which of the following function checks to see if a field has no value?

________ is the correct syntax for the Round function.

Introduction to Access: Finding Your Way Through an Access Database

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters