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 ...
Get Special Edition Using Access 97, Second Edition 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.
