microsoft access courses london - Validation

Hi Tom

Data validation is quite a large area within access, thus I can only give a few examples of data validation, otherwise this will be an extremely long post. Basically you validate anything that is not random, for example:

The first few characters within the 1st line of an address can either be a number or a letter, then the rest must be letters.

A phone number must be number entries (you can even set a pattern for entry)

A post code must start with a letter

Hope this helps

David