Validation Rules

Diving Line

If you need to print this page out, type your name in the box below.

Your Name : 


Data Validation is used to check that the data being entered is reasonable and in the correct format.  Validation is not able to check if the data is accurate.

Here are the most common validation checks ...

Validation Check What it Does Example of when to Use
Presence Check Checks that data has been entered into a field Where first name has to be entered into the database
Length Check Checks that the data has the specified umber of characters, or not too many characters A telephone number must have 11 characters
Range Check Checks that the data entered is between two values Test score is between 1 and 10
Lookup Check Gives a list of values that can be entered Mr, Mrs, Miss, Ms
Format Check Makes sure that the data is entered in the correct format 27-01-2020 for a date
Input Mask Controls how data can be entered into the field When a telephone number is entered, the area code must be entered first and must start with a 0


Check your understanding of validation rules by completing the activity below.

DoIT  Validation Rules

PrintIT  Print out this Page

Next  Validation Rules

Last modified: Friday, 6 November 2020, 12:38 PM