Using Data Validation

Question 1

In the input mask format (999) 000-0000, what do the 9s represent?

Revolt · Accepted Answer

optional numbers

Question 2

What steps will create a validation rule error message? Use the drop-down menus to explain.

Revolt · Accepted Answer

1. Open the table in view.: Design; 3. On the Field Properties General tab, in the box, type the message.: Validation Text

Question 3

FormatInput Mask ✔ Validation TextValidation Rule

Revolt · Accepted Answer

✔ Validation Text

Question 4

In the validation rule =6 OR =13 OR =NULL, what do the equal signs mean?

Revolt · Accepted Answer

The field must include 6, 13, or blank.

Question 5

How is a value list created?

Revolt · Accepted Answer

by the user typing in values for the list

Question 6

What steps will create a validation rule error message? Use the drop-down menus to explain.

Revolt · Accepted Answer

✔ Design; 1. Open the table in view.: Design; 3. On the Field Properties General tab, in the box, type the message.: Validation Text

Using Data Validation Answers