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:

Create tblClinic by
»

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:

Create tblClinic by importing data from the file
hbpClin.xlsx. Be certain the table meets the following requirements:

• Add a ClinicID field and make it the table’s primary key.

• The ClinicName cannot exceed 50 characters.

• The Address1, Address2, and City fields cannot exceed 40
characters.

• The default value for the Prov field is “AB” and all
values entered into this field must be uppercase and two characters in length.

• Values in the PostalCode field must appear in the
following format: uppercase letter, number, uppercase letter, space, number,
uppercase letter, number (for example, T6H 8U7).

• The Phone field stores 15 characters, displays values in the
format of (###) ###- ####, and area code entry is required.

• All fields must have appropriate captions and field
descriptions.

»