Database Reference
In-Depth Information
In this exercise, you'll create and test a field validation rule and a record validation rule in a
table.
SET UP
You need the GardenCompany06 database you worked with in the preced-
ing exercise to complete this exercise. If necessary, open the database. Then display the
FieldTest table in Database view, and follow the steps.
1
Point at the left end of the
fPhone
field, and when the pointer changes to a thick
cross, click to select the contents of the field. Then replace the current entry with
6785550101
, allowing the mask to format the entry for you.
2
With the
fPhone
field still selected, on the
Fields
tool tab, in the
Field Validation
group, click the
Validation
button to display a list of options.
6
The top set of options is for validating the field and the bottom set is for validating
the entire record.
3
Click
Field Validation Rule
to open the
Expression Builder
dialog box.
