Access: Now Playing Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

 

 

4

Test the Table

All good databases need to be tested. Double click tblCustomers to open the table in Datasheet View. Add your name, address and phone number to the list.

 

Did you notice:

The first record began with AutoNumber 1 for the CustomerID

 

Did the Phone display the symbols and placeholders when you were typing?

How did it store the numbers?

 

Did you test the Input Mask for the Zip?

 

That was a good start. You created your own table and customized the field properties. You get the cookie.

DONE