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 ...
Get Access 2002 Programming by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
