Access 2016 Intermediate

Access 2016

Lesson 1 – Setting Field Properties

5. Enter the desired validation rule. 6. Select the Validation Text property . 7. Enter the desired validation text.



Step-by-Step

Set a validation rule.

If necessary, open the Customers table in Design view.

Steps

Practice Data

1. Select the field for which you want to set a validation rule. The field is selected. 2. Select the General tab in the Field Properties pane, if necessary. The General tab appears. 3. Select the Validation Rule property. The insertion point appears in the Validation Rule box, and the Build button appears. 4. Enter the desired validation rule. The text appears in the Validation Rule box. 5. Select the Validation Text property. The insertion point appears in the Validation Text box. 6. Enter the desired validation text. The text appears in the Validation Text box.

Scroll as necessary and click in the Credit Limit field Click the General tab, if necessary

Click in the Validation Rule box

Type <=10000

Click in the Validation Text box

Type The Credit Limit may not exceed $10,000.

Save the table; a Microsoft Office Access warning box informs you that data integrity rules have been changed. Select Yes .

Switch back to Datasheet view. Create a new record; scroll as necessary, enter 15000 in the Credit Limit field, and press [Enter] . Select OK .

OFFICEPRO, Inc.

Page 17