data validation types

data validation types

1. feild length check

   • only allows a specific number of characters to be entered

2. type check

   • only allows a certain a certain type of data to be entered, eg text, number, currency,date/time,boolean(yes/no)

3. range check

   • number entered must be within a certain range, eg between 1-100.

4. list check

   • only specific data can be entered, eg male or female.

5. presence check

   • the field cannot be left empty.

6. format check

   • data must be entered in a specific way, eg including a space between the first and last part of a postcode.