Test the Validation

7. Try This: Add an Incomplete Record.
This will be a test of what happens when a User does NOT add a phone number.

 

Create a new record. Click on (New).

Enter the First Name: Mary.

Enter the Last Name: Contrary.

Enter Address1: 24 Elm Street.

Enter the City: Pinckney

Enter the State: MI

Enter the Zip: 48169

Do NOT enter the Home Phone.

 

Click the pencil on the Record Selector to Save the new customer information.

What Do You See? Microsoft Access will prompt you to enter a value in the HomePhone Field, the one that is Required.


Click OK.

Enter the Hone Phone: 7345551212.
Save the record.

That's good enough.

Table Tools ->Fields->Field Validation->Validation

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.2. Create and Modify Fields: Data Validation