Question: how to create a validation rule in access 2007?
Answer: Open the table for which you want to validate records.
On the Fields tab, in the Field Validation group, click Validation, and then click Record Validation Rule.
Use the Expression Builder to create the rule.