| Validation Checks
|
| Presence Check
| Checks that data has been entered into a cell and that it has not been left blank.
| 
|
| Type Check
| Checks that an entered value is of a particular type. e.g. check
that age is numeric.
|
|
| Length Check
| Checks than an entered value e.g. surname is no longer than a
set number of characters.
|
|
| Range Check
| Checks that an entered value falls within a particular range. For
example the age of a person should be in the range 0 to 130 years.
|
|
| Format Check
| Checks that an entered value has a particular format. e.g. a
new-style car registration number should consist of a letter followed by 1 to
3 numbers followed by 3 letters.
|
|
| Table Lookup Check
| Checks that an entered value is one of a pre-defined list of
valid entries which should be allowed.
|
|
