microsoft access 2002 training - access
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

microsoft access 2002 training - Access

resolvedResolved · Low Priority · Version Standard

replyReply Mon 12 Nov 2007, 16:57Delegate Mark said...

Mark has attended:
Access Introduction course

Access

What is data validation for?

For upcoming training course dates see: Pricing & availability

replyReply Tue 13 Nov 2007, 12:54Trainer David said...

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

 


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard