RelationalDBDesign
SiteMap
Data Manipulation
Access Features
Building Database
Tables Queries
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Table Design
«Prev
Next»
Tables Queries Forms
Table Design Enhancement
Table Field Validation
Custom Validation Messages
Input Mask Mechanics
Specifying Input Mask
Access Lookup Fields
Data Type Aadvantages
Specifying Field Length
Enhancing Table Design
Refining Queries
Access Database Filters
Multiple Access Queries
Query Field Properties
Specifying Join Properties Queries
Total Queries Access
Crosstab Queries
Building Modifying Forms
Create Access Form
Add Format to Access Form
Insert Graphic Access Form
Access Form Properties
Changing Form Properties
Custom Form Properties
Aligning Sizing Multiple Controls
Customize Access Forms
Building Modifying Forms
Access Controls
Combo Box
Option Groups
Subform Control
Create Multipage Forms
Adding Chart to Form
Activex Controls
Calendar activex Control
Access Controls
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.
Background/overview
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.
Instructions
Open the Consultants table in Design mode.
Add a new field called SSN.
Set the Data Type property to
Text
.
Set the Field Size property to
9
.
Using the Input Mask Wizard, set the Input Mask property to the Social Security input mask.