Question 1

A(n) ________ forces users to conform to a specific data entry format for a given field.

Accepted Answer

A)  input mask 
B)  validation rule 
C)  validation text 
D)  default value 
A)  input mask 
B)  validation rule 
C)  validation text 
D)  default value

Question 2

A ________ rule limits the type of data a user can enter into a field.

Accepted Answer

A)  validation 
B)  lookup 
C)  default 
D)  macro 
A)  validation 
B)  lookup 
C)  default 
D)  macro

Question 3

A required field indicates that a value for the field must be entered.

Accepted Answer

A) True 
 B)False

Question 4

A Multivalued Lookup field accepts numerous options instead of just one field choice.

Accepted Answer

A) True 
 B)False

Question 5

What is the purpose of adding an input mask to a field?

Accepted Answer

Restricting the data

Question 6

After setting a required property to an existing table, what does Access do to the existing records if the field is blank?

Accepted Answer

Access will leave the fields blank, but

Question 7

The DatePart function has ________ required parameters.

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 8

When one IIf function is used within another IIf function, they are referred to as nested IIf functions.

Accepted Answer

A) True 
 B)False

Question 9

The Date function calculates the current date.

Accepted Answer

A) True 
 B)False

Question 10

________ affects the display of the date without affecting the underlying value.

Accepted Answer

A)  Formatting 
B)  Rounding 
C)  Ruling 
D)  Nesting 
A)  Formatting 
B)  Rounding 
C)  Ruling 
D)  Nesting

Question 11

When creating a parameter query, you are limited to a single parameter in the Criteria row for a given field.

Accepted Answer

A) True 
 B)False

Question 12

When a field is required, it must have a default value.

Accepted Answer

A) True 
 B)False

Question 13

In Access, there are several ________ methods to help minimize data entry errors into tables and forms.

Accepted Answer

The answer of In Access, there are several ________ methods...

Question 14

Using the example of a hire date of October 5, 2017, what would the DatePart function be for the quarter?

Accepted Answer

DatePart("

Question 15

What does a IsNull function do?

Accepted Answer

An IsNull function checks to s

Question 16

What are the three options that need to be filled in for an IIF function to give correct results?

Accepted Answer

expression (the question you a

Question 17

What data validation method is designed to restrict the data values entered into a field?

Accepted Answer

A)  Validation rule 
B)  Validation text 
C)  Input mask 
D)  Lookup list 
A)  Validation rule 
B)  Validation text 
C)  Input mask 
D)  Lookup list

Question 18

Validation rules limit the type or range of data a user can enter into a field.

Accepted Answer

A) True 
 B)False

Question 19

The ________ function evaluates an expression and displays one value when the expression is true and another when the expression is false.

Accepted Answer

A)  IIF 
B)  Math 
C)  IsNull 
D)  DatePart 
A)  IIF 
B)  Math 
C)  IsNull 
D)  DatePart

Question 20

The ________ Wizard restricts how data is entered into a field.

Accepted Answer

The answer of The ________ Wizard restricts how data is...

A(n) ________ forces users to conform to a specific data entry format for a given field.

A ________ rule limits the type of data a user can enter into a field.

A required field indicates that a value for the field must be entered.

A Multivalued Lookup field accepts numerous options instead of just one field choice.

What is the purpose of adding an input mask to a field?

After setting a required property to an existing table, what does Access do to the existing records if the field is blank?

The DatePart function has ________ required parameters.

When one IIf function is used within another IIf function, they are referred to as nested IIf functions.

The Date function calculates the current date.

________ affects the display of the date without affecting the underlying value.

When creating a parameter query, you are limited to a single parameter in the Criteria row for a given field.

When a field is required, it must have a default value.

In Access, there are several ________ methods to help minimize data entry errors into tables and forms.

Using the example of a hire date of October 5, 2017, what would the DatePart function be for the quarter?

What does a IsNull function do?

What are the three options that need to be filled in for an IIF function to give correct results?

What data validation method is designed to restrict the data values entered into a field?

Validation rules limit the type or range of data a user can enter into a field.

The ________ function evaluates an expression and displays one value when the expression is true and another when the expression is false.

The ________ Wizard restricts how data is entered into a field.

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 users to conform to a specific data entry format for a given field.

A ________ rule limits the type of data a user can enter into a field.

A required field indicates that a value for the field must be entered.

A Multivalued Lookup field accepts numerous options instead of just one field choice.

What is the purpose of adding an input mask to a field?

After setting a required property to an existing table, what does Access do to the existing records if the field is blank?

The DatePart function has ________ required parameters.

When one IIf function is used within another IIf function, they are referred to as nested IIf functions.

The Date function calculates the current date.

________ affects the display of the date without affecting the underlying value.

When creating a parameter query, you are limited to a single parameter in the Criteria row for a given field.

When a field is required, it must have a default value.

In Access, there are several ________ methods to help minimize data entry errors into tables and forms.

Using the example of a hire date of October 5, 2017, what would the DatePart function be for the quarter?

What does a IsNull function do?

What are the three options that need to be filled in for an IIF function to give correct results?

What data validation method is designed to restrict the data values entered into a field?

Validation rules limit the type or range of data a user can enter into a field.

The ________ function evaluates an expression and displays one value when the expression is true and another when the expression is false.

The ________ Wizard restricts how data is entered into a field.

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