Even the most carefully designed database is worthless if it contains inaccurate or inconsis-
tent data. Unfortunately, the data-entry process is typically tedious, and even a highly moti-
vated, 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.
38
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.