Microsoft® Office Access™ 2007 Plain & Simple

Validating Data Entry

Some categories of data, such as credit limits or the date someone joined a club, have to meet certain criteria. You can make sure data entered into fields meets those criteria (for example, all credit limits are $5,000 or less) by performing data validation. When a user tries to enter data that isn’t appropriate for the field, you can display a message letting the user know what went wrong.

Perform Data Validation

1. Open a table in Design view.

2. Click the field for which you want to validate data entry.

3. Click Validation Rule.

4. Click ...