Question 1

Which of the following is not a way to address data validation violations?

Accepted Answer

A)  Press the "Allow This Exception" button and keep going. 
B)  Correct the data. 
C)  Cancel the record entry. 
D)  Change the data validation rule. 
A)  Press the "Allow This Exception" button and keep going. 
B)  Correct the data. 
C)  Cancel the record entry. 
D)  Change the data validation rule.

Question 2

The default setting for the Required field property for most fields is ________.

Accepted Answer

The answer of The default setting for the Required field...

Question 3

Match the following results with the proper comparison operators:
I. Does not equal 5000
II. Is less than 5000
III. Is less than or equal to 5000
IV. Is greater than 5000
V. Is greater than or equal to 5000
A. =5000
D. >5000
E. 5000

Accepted Answer

The answer of Match the following results with the proper...

Question 4

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 5

You must set the Required field property to Yes for any field used as a Primary Key unless it has an AutoNumber data type.

Accepted Answer

A) True 
 B)False

Question 6

The Required field property only applies to new data, not to existing data.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following functions required no arguments?

Accepted Answer

A)  Date 
B)  Sum 
C)  Avg 
D)  Trim 
A)  Date 
B)  Sum 
C)  Avg 
D)  Trim

Question 8

To define how many decimal places should display, you can use the ________ function.

Accepted Answer

The answer of To define how many decimal places should...

Question 9

Access allows for the creation of custom input masks.

Accepted Answer

A) True 
 B)False

Question 10

The Date function is entered as Date().

Accepted Answer

A) True 
 B)False

Question 11

Match the following results with the proper formulas:
I. January
II. Wednesday
III. December
IV. Saturday
V. 1
A. =MonthName(1)
B. =WeekdayName(4)
C. =MonthName(12)
D. =WeekdayName(7)
E. =DatePart("m",#01/16/1959#)

Accepted Answer

The answer of Match the following results with the proper...

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

To create a parameter query, you would put the desired text in parenthesis in the criterion row of the desired field.

Accepted Answer

A) True 
 B)False

Question 15

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 16

The DatePart function always returns a number.

Accepted Answer

A) True 
 B)False

Question 17

Access identifies dates by enclosing them in ________.

Accepted Answer

hash tags,

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Which feature limits the data that is allowed to be entered into a field?

Accepted Answer

A)  Default value 
B)  Required 
C)  Caption 
D)  Validation rule 
A)  Default value 
B)  Required 
C)  Caption 
D)  Validation rule

Question 20

You cannot change the Required field property after data has been entered.

Accepted Answer

A) True 
 B)False

Which of the following is not a way to address data validation violations?

The default setting for the Required field property for most fields is ________.

Match the following results with the proper comparison operators: I. Does not equal 5000 II. Is less than 5000 III. Is less than or equal to 5000 IV. Is greater than 5000 V. Is greater than or equal to 5000 A. <5000 B. <=5000 C. >=5000 D. >5000 E. <>5000

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

You must set the Required field property to Yes for any field used as a Primary Key unless it has an AutoNumber data type.

The Required field property only applies to new data, not to existing data.

Which of the following functions required no arguments?

To define how many decimal places should display, you can use the ________ function.

Access allows for the creation of custom input masks.

The Date function is entered as Date().

Match the following results with the proper formulas: I. January II. Wednesday III. December IV. Saturday V. 1 A. =MonthName(1) B. =WeekdayName(4) C. =MonthName(12) D. =WeekdayName(7) E. =DatePart("m",#01/16/1959#)

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

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

To create a parameter query, you would put the desired text in parenthesis in the criterion row of the desired field.

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

The DatePart function always returns a number.

Access identifies dates by enclosing them in ________.

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

Which feature limits the data that is allowed to be entered into a field?

You cannot change the Required field property after data has been entered.

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 is not a way to address data validation violations?

The default setting for the Required field property for most fields is ________.

Match the following results with the proper comparison operators: I. Does not equal 5000 II. Is less than 5000 III. Is less than or equal to 5000 IV. Is greater than 5000 V. Is greater than or equal to 5000 A. <5000 B. <=5000 C. >=5000 D. >5000 E. <>5000

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

You must set the Required field property to Yes for any field used as a Primary Key unless it has an AutoNumber data type.

The Required field property only applies to new data, not to existing data.

Which of the following functions required no arguments?

To define how many decimal places should display, you can use the ________ function.

Access allows for the creation of custom input masks.

The Date function is entered as Date().

Match the following results with the proper formulas: I. January II. Wednesday III. December IV. Saturday V. 1 A. =MonthName(1) B. =WeekdayName(4) C. =MonthName(12) D. =WeekdayName(7) E. =DatePart("m",#01/16/1959#)

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

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

To create a parameter query, you would put the desired text in parenthesis in the criterion row of the desired field.

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

The DatePart function always returns a number.

Access identifies dates by enclosing them in ________.

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

Which feature limits the data that is allowed to be entered into a field?

You cannot change the Required field property after data has been entered.

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