Validating Data Entry
The data entered in tables must be accurate if the database is to be valuable to you or your organization. Even the most experienced data-entry operators occasionally enter incorrect information. To add simple tests for the reasonableness of entries, add short expressions as a Validation Rule in the General page of Table Design view's Field Properties pane. If the entered data fails to conform to your validation rule, a message box informs the operator that a violation occurred. Validating data maintains the domain integrity of your tables.
Expressions are the core element of computer programming. Access enables you to create expressions without requiring that you be a programmer, although some familiarity with a programming ...
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.
Read now
Unlock full access