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

Restricting Data Entry

Even the most carefully designed database is worthless if it contains inaccurate or inconsistent data. Unfortunately, the data-entry process is typically tedious, and even a highly motivated, well-trained worker can become tired or distracted. When fingers slip or the mind wanders, errors are inevitable. You can't prevent users from accidentally typing incorrect data, but you can define rules that prevent Access from storing errors.

TIP FROM

Some of the most effective data restrictions are side effects of the data type you specify for a field. Trying to enter text in a Numeric field or numbers in a Date/Time field, for example, results in an error message. Likewise, you can restrict the length of a Text string or control the number of decimal places allowed in a Number field by adjusting the Field Size property.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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