Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses london - Validation
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft access courses london - Validation
Resolved · Low Priority · Version Standard
Reply
Validation
What validation rules can I set in design mode for entering data into a field?For upcoming training course dates see: Pricing & availability
RE: Validation
Hi TomData 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
|
 |
|
» Forum post: Sum function |
How do you use the sum function?
