Data Validation

Data Validation

1. Check Digit

   • Using the last one or two digits in a code to check all other digits are correct
   • E.g. a Barcode reader at a supermarket

2. Format Check

   • Checks the data is in the right format
   • E.g. a date of birth = DD/MM/YYYY

3. Length Check

   • Checks the data is the right length
   • E.g. A password that has to be 6 letters long at least

4. Lookup Table

   • Looks up Acceptable Values in A table
   • E.g. Only 7 possible days in a week

5. Presence Check

   • Checks data has been entered into a field
   • In most databases a field with a * next to it cannot be left blank

6. Range Check

   • Checks that a value falls within the specified range
   • E.g. Number of hours worked must be less than 50 and more than 0

7. Spell Check

   • Looks up a word in a dictionary
   • E.g. when word processing