Exam 77-424: Microsoft Access 2013 2.0 Build Tables 2.4 Create and Modify Fields: Add Validation Rules to Fields (Required)

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