Question: how to set validation rule in ms access?
Answer: Select the field you want to add a validation rule to. ...  Select the Fields tab, then locate the Field Validation group. ...  The Expression Builder dialog box will appear. ...  Once you're satisfied with the validation rule, click OK. ...  Click the Validation drop-down command again.