|
Try This: Do the following steps
Or you
may download the sample database
Brown
Bag Lunch ver3.accdb
online.
2. Open tblCustomers in Design View.
3. Apply an Input Mask to the Phone Field.
Use the phone number input mask, with asterisks (*) for the
placeholder. Also store the data without symbols.
4. Set a default value for the State column.
Enter MI for the default value.
5. Rename the Primary Key as CustomerID.
6. Save tblCustomers.
7. Return to the Datasheet View and add the following customer data to
the Table.
Check that the Input Mask and Default Value work.
Company
FirstName
LastName
Address
City
State
Zip
Phone
Buzz Luv Marketing
Daryl
McGuire
4456 Wixom Road
Wixom
MI
48393
810-555-4793
Wire Spin Network Solutions
Selena
Sullivan
5575 Novi Road
Novi
MI
48374
517-555-5486
Moon Labs Gaming
Chester
Morrison
8945 W. Twelve Mile
Road
Novi
MI
48374
248-555-7511
8. Close the Brown Bag Lunch database. |
|||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||
