Access Queries   «Prev  Next»
Lesson 1

Introduction to Table Design Enhancement

There is a common saying among database professionals: Garbage in, garbage out.
If you do not take steps to control the information being stored in your database, you will get erroneous information when displaying the data in reports.
The place to start controlling the insertion of bad data into your database is at the table level. By the end of this module, you will know how to:

  1. Use the Validation Rule property to test data
  2. Set the Validation Text property to display a custom message
  3. Use the Input Mask Wizard to specify data input formats
  4. Set up fields that display Combo Box and List Box controls for data input
  5. Use the correct data type for optimal performance
In the next lesson, you will learn how to use the Validation Rule property to test data.