DB Web Applications
WebsiteDeployment DistributedNetworks
prev next prev next
  Course navigation
 
Lesson 1
Enhancing table design
    There is a common saying among database professionals: Garbage in, garbage out.
This statement is so true! 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 garbage from getting 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.
  Course navigation