O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required