In the Steps To Success for Level 1, you created the database for Hudson Bay Pharmacy and created…

In the Steps To Success for Level 1, you created the
database for Hudson Bay Pharmacy and created the nine tables: tblClass,
tblCustomer, tblDoctor, tblDrug, tblEmployee, tblHealthPlan, tblHousehold,
tblJobTitle, and tblRx. The only table that contains data at this point is
tblJobTitle. Don asks you to create the remaining tables in the database
(tblClinic, tblEmployeeTraining, and tblRefill) and to populate the database
with data using various sources that he has provided to you. You also need to
relate the appropriate tables to each other.

Complete the following:

Populate the existing
»

In the Steps To Success for Level 1, you created the
database for Hudson Bay Pharmacy and created the nine tables: tblClass,
tblCustomer, tblDoctor, tblDrug, tblEmployee, tblHealthPlan, tblHousehold,
tblJobTitle, and tblRx. The only table that contains data at this point is
tblJobTitle. Don asks you to create the remaining tables in the database
(tblClinic, tblEmployeeTraining, and tblRefill) and to populate the database
with data using various sources that he has provided to you. You also need to
relate the appropriate tables to each other.

Complete the following:

Populate the existing database tables. The files you need
are saved in the STS folder. Remember that you might need to delete input masks
and make other adjustments as necessary for importing to work.

a. Use the file hbpClass.xlsx to populate tblClass.

b. Use the file hbpHhold.xlsx to populate tblHousehold.

c. Use the file hbpCust.xlsx to populate tblCustomer.

 d. Use the file hbpHPlan.xlsx to populate tblHealthPlan.

e. Use the file hbpDrug.xlsx to populate tblDrug.

f. Use the file hbpRx.xlsx to populate tblRx.

g. Use the file hbpEmp.xlsx to populate tblEmployee.

h. Copy and paste the records in the Doctor table in the
hbpDoc.accdb database into tblDoctor in the Hudson.accdb database.

»