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

microsoft access courses london - validation

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses london - Validation

microsoft access courses london - Validation

ResolvedVersion Standard

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?

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

Access tip:

Relationship maps

It is important to create proper relationships between tables. You can use Access to help check your designs and evaluate them by printing them in graphical format to help with design purposes


Click on the Tools menu, click Relationships.
On the File menu, click Print Relationships. View or print as required

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.1 secs.