Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft access 2002 training - access

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access 2002 training - Access

microsoft access 2002 training - Access

ResolvedVersion Standard

Mark has attended:
Access Introduction course

Access

What is data validation for?

RE: 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

Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.