Access 2016 Intermediate

Lesson 1 – Setting Field Properties

Access 2016

Steps

Practice Data

8. Select the Input Mask box.

Press [Tab]

The insertion point appears in the Input Mask box.

9. Type the custom input mask.

Type !00-0000

The text appears in the Input Mask box.

10. Select the Placeholder box.

Press [Tab]

The insertion point appears in the Placeholder box.

11. Type the desired placeholder. The character appears in the Placeholder box.

Type _

12. Select the Sample Data box.

Press [Tab]

The insertion point appears in the Sample Data box.

13. Type some sample data.

Type 346278

The characters appear in the Sample Data box.

14. Select Close .

Click

The Customize Input Mask Wizard dialog box closes, and the custom input mask appears in the Input Mask list. 15. Select the custom input mask from the Input Mask list. The custom input mask is selected.

Scroll as necessary and click Product Number

16. Select Finish .

Click

The Input Mask Wizard dialog box closes, and the custom input mask appears in the Input Mask box.

Save the changes to the table and switch to Datasheet view. Create a new record, type 153434 into the Product ID field, and press [Enter] ; notice the custom input mask.

Press [Esc] to delete the new record and close the Items table.

Page 26

OFFICEPRO, Inc.