1 / 12

Validation

Validation. Checks that the data entered is sensible. Input masks. 0 User must enter a digit (0 to 9). 9 User can enter a digit (0 to 9). # User can enter a digit, space, plus or minus sign. If skipped, Access enters a blank space. L User must enter a letter.

orpah
Download Presentation

Validation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Validation Checks that the data entered is sensible

  2. Input masks

  3. 0 User must enter a digit (0 to 9). • 9 User can enter a digit (0 to 9). • # User can enter a digit, space, plus or minus sign. If skipped, Access enters a blank space. • L User must enter a letter. • ? User can enter a letter. • A User must enter a letter or a digit. a User can enter a letter or a digit. • & User must enter either a character or a space. • C User can enter characters or spaces. • The character you select depends on your Microsoft Windows regional settings. • > Coverts all characters that follow to uppercase. • < Converts all characters that follow to lowercase. • ! Causes the input mask to fill from left to right instead of from right to left. • \ Characters immediately following will be displayed literally. • "" Characters enclosed in double quotation marks will be displayed literally.

  4. Tasks • LEVEL 1 Create an input Mask for a Postcode • LEVEL 2 Create an input Mask for a car registration • LEVEL 3User enters a first or last name with the first letter automatically capitalised. • LEVEL 4Or Own INPUT MASK

  5. EXPRESSION BUILDER A mathematical expression that checks that the data added is valid and within a ‘valid’ range =Now()

  6. EXPRESSION BUILDER

  7. Validation

  8. Validation

  9. Validation

  10. Tasks • LEVEL 1 Create a validation rule for Male and Female • LEVEL 2Create a validation rule for a numerical field (above or below a certain number) • LEVEL 3Create your own validation rule

  11. DATA VALIDATION LISTS

More Related