Access: Now Playing (Page 1) 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

Test the Table

Try it: Add a New Record

All good databases need to be tested. Open the customer table in Datasheet View. Please enter your name, address and phone number,

 

Did you notice:

The CustomerID is an AutoNumber that increments automatically. Can you type any number in that field?

 

Did the phone field display the placeholders when you typed the number? Did the table store the phone numbers with, or without, the input mask? Could you choose MyTown from the list box?

 

Dos the email field have a caption? What happens if you type a date in the email field?

 

That was a good start. There's more...

 

 
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 2. Creating and Formatting Database Elements

  2.4.2.  Modify field properties: Set data validation rules