Test the Field Validation

Adding Fields and changing the Table Field Properties changes everything in a database.

 

So, does it work?  The only way you can tell if it worked is to try it. Pretend you are a User, not the Programmer, and add some data.

 

6. Try it: Test the Field Validation

tblCustomers is still open.

Select an ID: 2

Enter Address1: 123 Main Street

Enter the City: Brighton

Enter the State: MI

Enter the Zip: 48116

Enter the Home Phone: 8105551212.

So far, so good. 

 

Keep going...

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

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.2. Create and Modify Fields: Data Validation