Question 1

Which of the following comparative operators cannot be used in a data validation rule?

Accepted Answer

A)   
B)  Between 
C)  = 
A)   
B)  Between 
C)  =

Question 2

How many arguments does the IIf function have?

Accepted Answer

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

Question 3

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 4

The ________ function calculates the current date.

Accepted Answer

The answer of The ________ function calculates the current date....

Question 5

Storing the options used in a lookup field in a separate table makes adding options easier.

Accepted Answer

A) True 
 B)False

Question 6

How will the parameter query request display when the query is run?

Accepted Answer

A)  Pop-up message 
B)  Status Bar message 
C)  Pop-up menu of options 
D)  Help message box 
A)  Pop-up message 
B)  Status Bar message 
C)  Pop-up menu of options 
D)  Help message box

Question 7

What is a primary reason for setting up a default value?

Accepted Answer

A)  Guarantees data accuracy 
B)  Reduce data redundancy 
C)  Reduce the number of options available 
D)  Reduce data entry time 
A)  Guarantees data accuracy 
B)  Reduce data redundancy 
C)  Reduce the number of options available 
D)  Reduce data entry time

Question 8

When you change the lookup field's source table, the options will be updated when the user tries to change data in the future.

Accepted Answer

A) True 
 B)False

Question 9

You can restrict the data type that will be accepted in a parameter query by ________.

Accepted Answer

A)  limiting the number of parameters in a query 
B)  choosing a data type for each parameter 
C)  choosing the field for the parameter query carefully 
D)  You cannot restrict what a user enters in a parameter query. 
A)  limiting the number of parameters in a query 
B)  choosing a data type for each parameter 
C)  choosing the field for the parameter query carefully 
D)  You cannot restrict what a user enters in a parameter query.

Question 10

Match the following with where they are found:
I. Parameters
II. Run (a query)
III. Criteria (in a query)
IV. Input Mask
V. Validation Text
A. Table Tools tab; Design tab; Field Properties; Input Mask row
B. Query Tools tab; Design tab; Show/Hide group
C. Table Tools tab; Design tab; Field Properties; Validation Text row
D. Query Tools tab; Design tab; Criteria row
E. Query Tools tab; Design tab; Results group

Accepted Answer

The answer of Match the following with where they are...

Question 11

Which of the following features helps to insure that improper information is not entered in a field?

Accepted Answer

A)  Cell validation 
B)  Data validation 
C)  Field validation 
D)  AutoCorrect Data 
A)  Cell validation 
B)  Data validation 
C)  Field validation 
D)  AutoCorrect Data

Question 12

Default values can be changed during data entry.

Accepted Answer

A) True 
 B)False

Question 13

When using the Lookup Field Wizard, how wide should the columns be?

Accepted Answer

A)  You cannot adjust the column width from the wizard. 
B)  Up to the maximum width of the field 
C)  To display neatly on the screen 
D)  To display the longest value 
A)  You cannot adjust the column width from the wizard. 
B)  Up to the maximum width of the field 
C)  To display neatly on the screen 
D)  To display the longest value

Question 14

A(n) ________ field is often used when there are a limited number of values in a field.

Accepted Answer

The answer of A(n) ________ field is often used when...

Question 15

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 16

Which of the following functions required no parameters?

Accepted Answer

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

Question 17

What is not a reason for avoiding making the state field a two-character lookup field?

Accepted Answer

A)  You might miss states that have more than one abbreviation. 
B)  You might miss areas like the District of Columbia. 
C)  You might miss other countries with two letter abbreviations recognized by the post office. 
D)  You might miss abbreviations for military areas. 
A)  You might miss states that have more than one abbreviation. 
B)  You might miss areas like the District of Columbia. 
C)  You might miss other countries with two letter abbreviations recognized by the post office. 
D)  You might miss abbreviations for military areas.

Question 18

To help limit the file size, the textbook recommends that all symbols in an input mask not be stored with the data.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following functions evaluates whether a value has been entered into a field?

Accepted Answer

A)  IsEmpty 
B)  IsVoid 
C)  IsNull 
D)  Null 
A)  IsEmpty 
B)  IsVoid 
C)  IsNull 
D)  Null

Question 20

________ validation helps to make sure that incorrect information is not entered in a field.

Accepted Answer

The answer of ________ validation helps to make sure that...

Which of the following comparative operators cannot be used in a data validation rule?

How many arguments does the IIf function have?

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#)

The ________ function calculates the current date.

Storing the options used in a lookup field in a separate table makes adding options easier.

How will the parameter query request display when the query is run?

What is a primary reason for setting up a default value?

When you change the lookup field's source table, the options will be updated when the user tries to change data in the future.

You can restrict the data type that will be accepted in a parameter query by ________.

Which of the following features helps to insure that improper information is not entered in a field?

Default values can be changed during data entry.

When using the Lookup Field Wizard, how wide should the columns be?

A(n) ________ field is often used when there are a limited number of values in a field.

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 functions required no parameters?

What is not a reason for avoiding making the state field a two-character lookup field?

To help limit the file size, the textbook recommends that all symbols in an input mask not be stored with the data.

Which of the following functions evaluates whether a value has been entered into a field?

________ validation helps to make sure that incorrect information is not entered in a 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

Which of the following comparative operators cannot be used in a data validation rule?

How many arguments does the IIf function have?

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#)

The ________ function calculates the current date.

Storing the options used in a lookup field in a separate table makes adding options easier.

How will the parameter query request display when the query is run?

What is a primary reason for setting up a default value?

When you change the lookup field's source table, the options will be updated when the user tries to change data in the future.

You can restrict the data type that will be accepted in a parameter query by ________.

Which of the following features helps to insure that improper information is not entered in a field?

Default values can be changed during data entry.

When using the Lookup Field Wizard, how wide should the columns be?

A(n) ________ field is often used when there are a limited number of values in a field.

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 functions required no parameters?

What is not a reason for avoiding making the state field a two-character lookup field?

To help limit the file size, the textbook recommends that all symbols in an input mask not be stored with the data.

Which of the following functions evaluates whether a value has been entered into a field?

________ validation helps to make sure that incorrect information is not entered in a 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