Microsoft Access Tips: Validation Rule

Access is designed for users to enter data into a database easily but sometimes people type in the wrong data and this can affect the tables and final reports.In this blog post we will be looking how to create a Validation Rule in Access 2007, 2010, and 2013.

 

To stop this you are able to implement Validation Rules to stop this from happening. The Validation Rule limits the values that can be entered into a field. So for example you are able to stop a number greater than 100 being entered in.

 

You can put a validation rule on any field in a table and this is found on the design view of that table, under the general tab.

 

Validation Rule 1

 

You can see there are 2 fields for Validation, Rule and Text. The rule is where you put in your “Rule” here are some examples below:

 


Rule Explanation
>30 Only numbers greater than 30
<20 Only numbers less than 20
Between 20 and 30 Numbers between 20 and 30

 

 

Validation text is where you put the text for the message box that will appear if the rule has been broken. This can be any message and you will always get a OK, Cancel Message box that will appear.

 

Validation Rule 2

3 Responses to “Microsoft Access Tips: Validation Rule”