Access 2016 Intermediate

Access 2016

Lesson 1 – Setting Field Properties

12. Select

.

13. Select

.



Step-by-Step

Create an input mask.

If necessary, open the Customers table in Design view.

Steps

Practice Data

1. Select the field to which you want to apply an input mask. The field is selected. 2. Select the General tab in the Field Properties pane, if necessary. The General tab appears.

Scroll as necessary and click in the Phone Number field Click the General tab, if necessary

3. Select the Input Mask property.

Click in the Input Mask box

The Build button appears to the right of the Input Mask box.

4. Click the Build button.

Click

The Input Mask Wizard opens.

5. Select the desired option from the Input Mask list. The input mask option is selected.

Click Phone Number , if necessary

6. Select Next .

Click

The next page of the Input Mask Wizard appears.

7. Select the Placeholder character list. A list of available placeholders appears. 8. Select the desired placeholder. The placeholder appears in the Placeholder character box.

Click Placeholder character

Click _

9. Select Next .

Click

The next page of the Input Mask Wizard appears.

OFFICEPRO, Inc.

Page 19