|
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 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. |
|||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||
