Microsoft Access Validation Rules In Tables

Microsoft Access Validation Rules In Tables

A validation rule restricts or controls what a user can input in a table field. You can think of it as a set of layers which ensures that your users input data properly.

Here’s a quick video tutorial to get you going and very easy to apply.

httpvh://www.youtube.com/watch?v=ksdmVId5ip4

Microsoft Access provides several ways to validate data: data types, field sizes, table properties, and input masks. Among these, table properties provide specific types of data validation.

One example is setting the required property to YES which results to forcing the users to enter a value in that specific field.

Another technique is by using the Validation Rule property to require specific values, and the Validation Text property to alert your users to any errors. For example, putting a rule such as Continue reading “Microsoft Access Validation Rules In Tables”