Question 1

Which of the following provides for uniformity and consistency of data?

Accepted Answer

A)  Lookup field 
B)  Cell validation 
C)  Field validation 
D)  One-to-One relationships 
A)  Lookup field 
B)  Cell validation 
C)  Field validation 
D)  One-to-One relationships A

Question 2

Which of the following is a primary reason for manually setting up data validation?

Accepted Answer

A)  To make sure that two identical entries are not entered as the primary key 
B)  To make sure that fields, like phone numbers, display in a consistent format 
C)  To make sure that text is not entered into number fields 
D)  To reduce user entry errors 
A)  To make sure that two identical entries are not entered as the primary key 
B)  To make sure that fields, like phone numbers, display in a consistent format 
C)  To make sure that text is not entered into number fields 
D)  To reduce user entry errors D

Question 3

In the Round function, if you leave the precision level blank, Access will default to how many decimal places?

Accepted Answer

A)  0 
B)  1 
C)  2 
D)  You cannot leave the precision level argument blank. 
A)  0 
B)  1 
C)  2 
D)  You cannot leave the precision level argument blank. A

Question 4

Access identifies dates by enclosing them in ________.

Accepted Answer

hash tags,

Question 5

For which of the following data types can you not change the Required field property?

Accepted Answer

A)  Hyperlink 
B)  AutoNumber 
C)  Long text 
D)  Calculated 
A)  Hyperlink 
B)  AutoNumber 
C)  Long text 
D)  Calculated

Question 6

A(n) ________ query relies on the user providing the criterion when the query is run.

Accepted Answer

The answer of A(n) ________ query relies on the user...

Question 7

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 8

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 9

If you wanted a parameter query to prompt for a partial value, you can use the ________ operator.

Accepted Answer

The answer of If you wanted a parameter query to...

Question 10

A(n) ___ field is a predefined list of values.

Accepted Answer

The answer of A(n) ___ field is a predefined list...

Question 11

When is the criterion entered in a parameter query?

Accepted Answer

A)  When the query is created 
B)  When the query is saved 
C)  When the query is run 
D)  When the query is in SQL view 
A)  When the query is created 
B)  When the query is saved 
C)  When the query is run 
D)  When the query is in SQL view

Question 12

You do not have to set the Required field property for AutoNumber fields.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following data types cannot have an input mask applied?

Accepted Answer

A)  Number 
B)  Long Text 
C)  Short Text 
D)  Date/Time 
A)  Number 
B)  Long Text 
C)  Short Text 
D)  Date/Time

Question 14

An input mask is used to consistently format data.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is often not true about tables used to supply data in a lookup field?

Accepted Answer

A)  It has no relationship set up. 
B)  It has no primary key. 
C)  It may just have one field. 
D)  It is locked so no additional entries can be made. 
A)  It has no relationship set up. 
B)  It has no primary key. 
C)  It may just have one field. 
D)  It is locked so no additional entries can be made.

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

When the Enable Data Integrity check box in the Lookup Field Wizard is checked ________.

Accepted Answer

A)  you can type in the data source manually 
B)  values can be deleted from the lookup table 
C)  new values can be added to the lookup table 
D)  only values found in the lookup table can be used 
A)  you can type in the data source manually 
B)  values can be deleted from the lookup table 
C)  new values can be added to the lookup table 
D)  only values found in the lookup table can be used

Question 19

If you wanted to just display the year in a date field, you would use which function?

Accepted Answer

A)  PartDate 
B)  DatePart 
C)  Date 
D)  YearPart 
A)  PartDate 
B)  DatePart 
C)  Date 
D)  YearPart

Question 20

The Lookup ________ helps you create a lookup field.

Accepted Answer

The answer of The Lookup ________ helps you create a...

Which of the following provides for uniformity and consistency of data?

Which of the following is a primary reason for manually setting up data validation?

In the Round function, if you leave the precision level blank, Access will default to how many decimal places?

Access identifies dates by enclosing them in ________.

For which of the following data types can you not change the Required field property?

A(n) ________ query relies on the user providing the criterion when the query is run.

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

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

If you wanted a parameter query to prompt for a partial value, you can use the ________ operator.

A(n) ___ field is a predefined list of values.

When is the criterion entered in a parameter query?

You do not have to set the Required field property for AutoNumber fields.

Which of the following data types cannot have an input mask applied?

An input mask is used to consistently format data.

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

Which of the following is often not true about tables used to supply data in a lookup field?

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

When the Enable Data Integrity check box in the Lookup Field Wizard is checked ________.

If you wanted to just display the year in a date field, you would use which function?

The Lookup ________ helps you create a lookup 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 provides for uniformity and consistency of data?

Which of the following is a primary reason for manually setting up data validation?

In the Round function, if you leave the precision level blank, Access will default to how many decimal places?

Access identifies dates by enclosing them in ________.

For which of the following data types can you not change the Required field property?

A(n) ________ query relies on the user providing the criterion when the query is run.

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

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

If you wanted a parameter query to prompt for a partial value, you can use the ________ operator.

A(n) ___ field is a predefined list of values.

When is the criterion entered in a parameter query?

You do not have to set the Required field property for AutoNumber fields.

Which of the following data types cannot have an input mask applied?

An input mask is used to consistently format data.

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

Which of the following is often not true about tables used to supply data in a lookup field?

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

When the Enable Data Integrity check box in the Lookup Field Wizard is checked ________.

If you wanted to just display the year in a date field, you would use which function?

The Lookup ________ helps you create a lookup 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