• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Taming Access Data > Preventing Form Errors by Validating Data

Preventing Form Errors by Validating Data

If, as the cooks say, a recipe is only as good as its ingredients, a database is only as good as its data. Viewing, summarizing, and analyzing the data are meaningless if the table you’re working with contains erroneous or improper data. For basic data errors (for example, entering the wrong date or transposing a number’s digits), there’s not a lot you can do other than exhorting yourself or the people who use your forms to enter data carefully. Fortunately, you have a bit more control when it comes to preventing improper data entry. By “improper,” I mean data that falls into either of the following categories:

  • Data that is the wrong type. For example, entering a text string in a cell that requires a number.

  • Data that falls outside of an allowable range. For example, entering 200 in a cell that requires a number between 1 and 100.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint