Microsoft Office Tutorials and References
In Depth Information
Modifying Table Structure
Modifying an Access Database
Click here to start the Input Mask Wizard
The Input Mask Wizard.
Select a date/time type.
You can save data entry time if a particular field
has a frequently used text entry, value, number, or
even an abbreviation. By entering default data, all
new records will have the data, which of course,
you can override when you enter the record.
Used with Text and Date field types, you can create
a template with punctuation marks that can make
your data entry easier. Input masks are often used
with telephone numbers or social security
numbers so they appear in a commonly used format
and also help prevent many data entry errors.
Validation Rules are an invaluable tool for avoiding
data entry errors. For example, suppose you are
keeping an employee database and all salaries fall
between $40,000 and $150,000. By creating a data
validation rule restricting the salary between those
two numbers, the data entry operator can’t
accidently enter a salary of $350,000.
In the Input Mask text box, you enter a 0 where you
want numbers and any punctuation marks or spaces
where they belong. For example, to enter a mask for
telephone numbers, you enter (000) 000-0000 and
for social security numbers, you enter 000-00-0000.
If you need additional help with creating a mask,
click the three dots on the right side of the Input
Mask text box. You may be prompted to save your
table and then the Input Mask Wizard seen in Figure
19-13 appears. Choose an option then click Next.
Review the questions on the second page of the
Wizard and click Next. Review and select any options
from each Wizard page and then click Finish.
Most validation rules use the Greater Than (>), Less
Than (<), Equal to (=), or Not Equal To (< >)
symbols and you can combine the Greater Than or the
Less Than with the Equal to. So in the previous
example, you need a validation rule that says the
data must be greater than or equal to 40,000 and