Question 1

Which of the following is not true about validation text?

Accepted Answer

A) It displays when a data violation has occurred. 
B) It displays anytime a field is entered to aid in data entry. 
C) It provides feedback on what was wrong with the data. 
D) It is considered a custom error message. 
A) It displays when a data violation has occurred. 
B) It displays anytime a field is entered to aid in data entry. 
C) It provides feedback on what was wrong with the data. 
D) It is considered a custom error message.

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

The ________ function check to see if a field has had no value entered into it.

Accepted Answer

The answer of The ________ function check to see if...

Question 4

Default values can be changed during data entry.

Accepted Answer

A) True 
 B)False

Question 5

To select to how many decimal places a value will display; you would use which function?

Accepted Answer

A) Int 
B) Decimal 
C) Round 
D) Currency 
A) Int 
B) Decimal 
C) Round 
D) Currency

Question 6

Which of the following is not true about the Date function?

Accepted Answer

A) Access updates it every time the system date changes. 
B) It requires no arguments. 
C) It takes the form Date(Now) 
D) It can be entered directly in a field row of a query. 
A) Access updates it every time the system date changes. 
B) It requires no arguments. 
C) It takes the form Date(Now) 
D) It can be entered directly in a field row of a query.

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

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

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 10

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 11

Match between columns
                        Premises: "h"
"w"
"n"
"m"
"yyyy"

Accepted Answer

The Answer of Year and Minute and Month and Day is...

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Between [Enter Start Date] And [Enter End Date] is a valid statement to use in a parameter query.

Accepted Answer

A) True 
 B)False

Question 14

Access identifies dates by enclosing them in ________.

Accepted Answer

hash tags,

Question 15

Match between columns
                        Premises: IIf
IsNull
Round
DatePart
Date

Accepted Answer

The Answer of When you need to do one action is...

Question 16

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 there...

Question 17

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

Which of the following is not true about validation text?

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

The ________ function check to see if a field has had no value entered into it.

Default values can be changed during data entry.

To select to how many decimal places a value will display; you would use which function?

Which of the following is not true about the Date function?

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

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

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

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

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

Between [Enter Start Date] And [Enter End Date] is a valid statement to use in a parameter query.

Access identifies dates by enclosing them in ________.

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

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

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 true about validation text?

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

The ________ function check to see if a field has had no value entered into it.

Default values can be changed during data entry.

To select to how many decimal places a value will display; you would use which function?

Which of the following is not true about the Date function?

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

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

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

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

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

Between [Enter Start Date] And [Enter End Date] is a valid statement to use in a parameter query.

Access identifies dates by enclosing them in ________.

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

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

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