Input Mask: Store the Data

Now, the Wizard will ask if you would like to save (store) the data in tblCustomers with or without the symbols in the mask.

 

This is a challenging question that the Computer Mama has struggled with in many database designs. Saving the symbols makes the data look like phone numbers in tblCustomers.

 

However, symbols make it difficult to look up a phone number because you have to type it exactly, with the parentheses and all that.

 

The default programming is to store the data without the symbols.

 

7. Try it: Store the Data

Select the Default Option: Without the symbols.
Click Next. Keep going...

Table Tools->Design->Tools->Builder->Input Mask Wizard

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.1.1. Create tables in Design View: Modify the Field Properties