• 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 pass your validation rule, a message box informs the operator that a violation occurred. You can customize the error message by adding the text as the value of the Validation Text property. Validating data maintains the entity integrity of your tables.

Expressions are the core element of computer programming. Jet lets you create expressions without requiring that you be a programmer, although some familiarity with a programming language is helpful. Expressions use 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 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