1. With the Health Plus database file open, create a new table named Suppliers with the following fields and assign the data type shown (you determine the Description):

Field Name Data Type

Supplier # = Text (field size = 2)

Supplier Name = Text (field size = 20)

Street Address = Text (field size =30)

City = Text (field size = 20)

State = Text (field size = 2)

Zip Code = Text (field size = 10) Use the Input Mask Wizard to specify a nine-digit Zip Code.

(Hint: At the first Input Mask Wizard dialog box, click Zip Code in the Input Mask

List box.)

2. After creating and saving the table with the fields shown above, enter the following data in the table, remember to do this in datasheet view.

Supplier # = 10

Supplier Name = VitaHealth, Inc.

Street Address = 12110 South 23^rd

City = San Diego

State = CA

Zip Code = 97432-1567

Supplier # = 18

Supplier Name = Mainstream Supplies

Street Address = 312 Evergreen Building

City = Seattle

State = WA

Zip Code = 98220-2791

Supplier # = 21

Supplier Name = LaVerde Products

Street Address = 1512 First Street

City = San Diego

State = CA

Zip Code = 97466-1222

Save and print out the datasheet.