Question 1

Validation rules are entered in the ________ pane.

Accepted Answer

A)  Field Properties 
B)  Validation 
C)  Rules 
D)  Data macro 
A)  Field Properties 
B)  Validation 
C)  Rules 
D)  Data macro A

Question 2

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  False

Question 3

When a field is designated as required,it CANNOT be left blank.

Accepted Answer

A) True 
 B)False  True

Question 4

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 5

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 6

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 7

The Validation Text property is used to display a message when the corresponding validation rule is not met.

Accepted Answer

A) True 
 B)False

Question 8

You would use the ________ function to calculate the current date.

Accepted Answer

A)  Now() 
B)  Today() 
C)  Present() 
D)  Date() 
A)  Now() 
B)  Today() 
C)  Present() 
D)  Date()

Question 9

If a validation rule is not met,you CANNOT continue until the data value meets the rule.

Accepted Answer

A) True 
 B)False

Question 10

Using the Round function with only one parameter rounds the numerical value of the parameter to the nearest ________.

Accepted Answer

A)  whole number 
B)  tenth 
C)  hundredth 
D)  thousandth 
A)  whole number 
B)  tenth 
C)  hundredth 
D)  thousandth

Question 11

(___)___-____ is an example of a(n)________.

Accepted Answer

A)  data validation rule 
B)  default value 
C)  input mask 
D)  lookup field 
A)  data validation rule 
B)  default value 
C)  input mask 
D)  lookup field

Question 12

The ________ function is used to check whether a field contains no value.

Accepted Answer

A)  IsNull 
B)  Concat 
C)  IIf 
D)  IsNumeric 
A)  IsNull 
B)  Concat 
C)  IIf 
D)  IsNumeric

Question 13

When creating a parameter query,the prompt is enclosed in ________.

Accepted Answer

A)  parentheses ( ) 
B)  braces { } 
C)  brackets [ ] 
D)  quotations " " 
A)  parentheses ( ) 
B)  braces { } 
C)  brackets [ ] 
D)  quotations " "

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

The IIf function requires ________ parameters.

Accepted Answer

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

Question 16

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 17

The table that contains the values for a lookup field CANNOT be modified.

Accepted Answer

A) True 
 B)False

Question 18

When most people in a database reside in New York,you should make NY the ________ value for the State field.

Accepted Answer

A)  data validation rule 
B)  default 
C)  lookup field 
D)  input mask 
A)  data validation rule 
B)  default 
C)  lookup field 
D)  input mask

Validation rules are entered in the ________ pane.

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

When a field is designated as required,it CANNOT be left blank.

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

The DatePart function has ________ required parameters.

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

The Validation Text property is used to display a message when the corresponding validation rule is not met.

You would use the ________ function to calculate the current date.

If a validation rule is not met,you CANNOT continue until the data value meets the rule.

Using the Round function with only one parameter rounds the numerical value of the parameter to the nearest ________.

(_)_- is an example of a(n)____.

The ________ function is used to check whether a field contains no value.

When creating a parameter query,the prompt is enclosed in ________.

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

The IIf function requires ________ parameters.

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

The table that contains the values for a lookup field CANNOT be modified.

When most people in a database reside in New York,you should make NY the ________ value for the State field.

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

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

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

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 SQL in Access: Advanced Techniques

Filters

Exam 5: Data Validation and Data Analysis: Hands-On-Exercise Videos

Validation rules are entered in the ________ pane.

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

When a field is designated as required,it CANNOT be left blank.

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

The DatePart function has ________ required parameters.

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

The Validation Text property is used to display a message when the corresponding validation rule is not met.

You would use the ________ function to calculate the current date.

If a validation rule is not met,you CANNOT continue until the data value meets the rule.

Using the Round function with only one parameter rounds the numerical value of the parameter to the nearest ________.

(___)___-____ is an example of a(n)________.

The ________ function is used to check whether a field contains no value.

When creating a parameter query,the prompt is enclosed in ________.

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

The IIf function requires ________ parameters.

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

The table that contains the values for a lookup field CANNOT be modified.

When most people in a database reside in New York,you should make NY the ________ value for the State field.

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

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

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

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 SQL in Access: Advanced Techniques

Filters

(_)_- is an example of a(n)____.