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. This exercise is auto-scored.
When you have completed the steps below, click Submit to receive full credit.
Background overview
You are the Access database administrator for the marketing and documentation departments of companies in the software and networking business.
A large client needs the database to enforce a consistent format for Social Security Number (SSN) values.
- Download files
The Consulting307.mdb database is included in the compressed download file available on the Resources page.
If you already downloaded the database, continue using that version.
Instructions
- Open the Consultants table in Design View.
- Add a new field named SSN.
- Set Data Type to
Short Text (or Text, depending on your Access version).
- Set Field Size to
9.
- Use the Input Mask Wizard to set the Input Mask property to the Social Security input mask.