• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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 language is helpful. Expressions are statements used to calculate values by using the familiar arithmetic symbols +, —, * (multiply), and / (divide). These symbols are called operators because they operate on (use) the values that precede and follow them. These operators are reserved symbols in Access VBA. The values operated on by operators are called operands.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint