Question: how to create a validation rule in access?
Answer: Select the field that you want to validate.
On the Fields tab, in the Field Validation group, click Validation, and then click Field Validation Rule.
Use the Expression Builder to create the rule.