Monthly Archive for April, 2015

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: