Access 2016 Intermediate

Lesson 1 – Setting Field Properties

Access 2016

You can impose restrictions on data entered into your table by creating validation rules in the Validation Rule box of one or more fields. When you enter data into a new record or modify data in an existing record, Access checks each field for existing validation rules. If an entry does not meet the conditions of the corresponding validation rule, a warning box notifies you of the error. When you set a validation rule, you use the Validation Text box to specify the text you want to appear in the warning box. Setting a validation rule is different from setting the data type or field size properties. Access uses data type and field size properties to determine that the correct type of data is entered. Validation rules are more specific in their restrictions. For example, you can create a validation rule to ensure that numbers entered in a particular field are between 500 and 1000.

Creating a validation rule with validation text

NOTE You can also use the Expression Builder to set a validation rule.



Procedures

1. Open the desired table in Design view. 2. Select the field for which you want to set a validation rule. 3. Select the General tab in the Field Properties pane, if necessary. 4. Select the Validation Rule property.

Page 16

OFFICEPRO, Inc.