Validation and Verification

• Validation is a computer check to make sure data entered is sensible.

• There are different types of validation:

Presence Check: This is when you check that a field is not empty.

Range Check: This is when you check that data entered into a field is within the range e.g. 90<100.

Format Check: This is when you check the data is in the right format.

Lookup Table: This is when you lookup acceptable values in a table

Check Digit: Looking at the last two numbers to see if the rest of the numbers are valid.

Length Check: Making sure values entered aren't too long or short.

Spell Check: Making sure data entered is spelt correctly.

• Verification is making sure the data matches the source it came from.

• There are different types of Verification:

Double Entry: Entering the data twice and comparing the two copies but this raises issues such as double costs and time.

Proof-reading Data: Reading the data over and checking it but this also consumes time and money.