microsoft access 2002 training - Access

Hi Mark
Data validation is a feature that allows you to validate data before it is entered into the Access database.
For example:
If you a field and you want to only allow a choice of four options, you could use validation to make sure that nothing else apart from those four options is entered.
Or
Date format - if you want dates in dd/mm/yyyy you can add validation to enforce that format.

You can also use validation for making sure that people don't enter numbers for names and that the user enters a house number in an address field.

Hope this helps
David