microsoft access courses london - Validation

The UK's most regular instructor-led training courses.
Training information: microsoft access courses london · Courses in microsoft access · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

1 post

ReplyThu 15 Mar 2007, 09:46Delegate Tom said...

Tom has attended:
Access Intermediate course
Access Advanced course

Validation

What validation rules can I set in design mode for entering data into a field?

Version	Date	Location	Places available	Book	Next place rate (£)		List price
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2007	Tue 3 Aug 2010	Bloomsbury	1		£215	£220	£235
2003	Fri 20 Aug 2010	Bloomsbury	7		£190	£195	£235
2007	Fri 27 Aug 2010	Bloomsbury	9		£180	£185	£235
2010	Thu 16 Sep 2010	Bloomsbury	7		£250	£255	£299
2007	Wed 29 Sep 2010	Bloomsbury	8		£176	£181	£235
2003	Fri 8 Oct 2010	Bloomsbury	10		£142	£157	£235
Full Schedule: See all 35 Access Intermediate course dates. Bookings currently available until 28th September 2011.

428 posts

ReplyThu 15 Mar 2007, 15:21Trainer David said...

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

· Data validation in MS Access
· Microsoft Access Training Opens Doors
· Practice Microsoft Access Database Decorum To Reap The Rewards
· Access Corruption Avoidance Tip #3: Stay Connected
· Microsoft Access, an Efficient Database Tool

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips