Skip to Main Content
Microsoft® Office Access 2003 Step by Step
book

Microsoft® Office Access 2003 Step by Step

by Online Training Solutions Inc.
August 2003
Beginner content levelBeginner
368 pages
10h 49m
English
Microsoft Press
Content preview from Microsoft® Office Access 2003 Step by Step

Using Validation Rules to Restrict Data

A validation rule is an expression that can precisely define the information that will be accepted in one or several fields in a record. You might use a validation rule in a field containing the date an employee was hired to prevent a date in the future from being entered. Or if you make deliveries to only certain local areas, you could use a validation rule on the phone field or ZIP code field to refuse entries from other areas.

You can type validation rules in by hand, or you can use the Expression Builder to create them. At the field level, Access uses the rule to test an entry when you attempt to leave the field. At the table level, Access uses the rule to test the content of several fields when you attempt ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Access 2003 Inside Out

Microsoft® Office Access 2003 Inside Out

John L. Viescas

Publisher Resources

ISBN: 0735615179Supplemental ContentCatalog PageErrata