Tables Queries Forms
Table Design Enhancement
Access Input Masks - Exercise
Working with input masks
Course project: Using the Input Mask Wizard
Get practice using the Input Mask Wizard to create an input mask.
You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the
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.
As we stated in the first module, the
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.
Open the Consultants table in Design mode.
Add a new field called SSN.
Set the Data Type property to
Set the Field Size property to
Using the Input Mask Wizard, set the Input Mask property to the Social Security input mask.