Don just received a request from Paul to develop a database for a new pharmacy that Paul is opening.

Don just received a request from Paul to develop a database
for a new pharmacy that Paul is opening in Edmonton, Alberta, Canada. Because
the data collected about customers, employees, and drugs is slightly different
in Canada, Don decides to create the databases simultaneously, but separately, so
he can account for the individual differences in each version. Don wants you to
create the database for Hudson Bay Pharmacy. (You will create nine tables in
this exercise using the skills you have learned so far. You will create three more
tables in the Level 2 Steps To Success exercises.) He will
»

Don just received a request from Paul to develop a database
for a new pharmacy that Paul is opening in Edmonton, Alberta, Canada. Because
the data collected about customers, employees, and drugs is slightly different
in Canada, Don decides to create the databases simultaneously, but separately, so
he can account for the individual differences in each version. Don wants you to
create the database for Hudson Bay Pharmacy. (You will create nine tables in
this exercise using the skills you have learned so far. You will create three more
tables in the Level 2 Steps To Success exercises.) He will provide you
additional information so you know how to account for the differences in the
Canadian version of the database.

Complete the following:

Examine the 4Corners database tblDoctor table shown in
Figure 2.2, and then create a table in Design view in the Hudson database. The
tblDoctor table is not related to any other database table yet (you will create
relationships in the next level). The fields for the doctor’s first name and
last name should store 30 characters each. The fields that store phone numbers
should store 15 characters each and format values with an input mask that
formats values with the following format: (###) ###-####. Note that these pound
signs simply indicate numeric values, not a valid Access input mask. The
ClinicID field is a foreign key to tblClinic, which you will create in the next
level. (Hint: Create this field in Design view.) Store ClinicID values as long
integers. Use the Description property to document each field and enter appropriate
captions to fields that require them.

»