Lesson 3: Table Design

Try This: Do the following steps
1. Open the Brown Bag Lunch database you have been programming.

Or you may download the sample database Brown Bag Lunch ver3.accdb online.

1. Go to All Access Objects->Tables.

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.

 

Practice Activities