Question: how to set a validation rule for a table in access?
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.