Table Design  «Prev  Next»

Access Input Masks - Exercise

Working with Input Masks in Access

Course project: Using the Input Mask Wizard

Objective: Get practice using the Input Mask Wizard to create an input mask.

Exercise scoring

You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the Submit buton to receive full credit.


Recall that you are the Access database administrator for the marketing and documentation departments of companies in the software and networking business. For one of your large clients, you need to set a database to have an input mask to receive Social Security information.

Download files

As we stated in the first module, the Consulting307.mdb database is included in the compressed download file available on the Resources page. If you have already downloaded the database, continue to work in that version.


  1. Open the Consultants table in Design mode.
  2. Add a new field called SSN.
  3. Set the Data Type property to Text.
  4. Set the Field Size property to 9.
  5. Using the Input Mask Wizard, set the Input Mask property to the Social Security input mask.