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

Explanation of Limitations

Why would you place so many restrictions on the table you just created? You want your data to be as error-free as possible. You will discover that there are provisions in Access to check data after the fact, but why not check data as you input it? The users aren’t annoyed with any messages unless they type something that is incorrect. If the current month is March, it’s easy to accidentally type a 4 instead of a 3 for the month. Access doesn’t allow that entry with the validation rule you established. The user is notified of the problem and when it is corrected, he or she can continue.

Although you can’t totally eliminate human error, you can minimize the chances of errors occurring. When large amounts of data are entered, input speed can also be increased. For example, if a typist is entering social security numbers, having the dashes automatically entered into the field can increase typing speed. Even if it increases the speed by just a fraction of a second on every record, those fractions add up over a long period of typing.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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