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...