Marie Cresson of Hudson Bay Pharmacy needs additional reports for the other managers at the…

Marie Cresson of Hudson Bay Pharmacy needs additional
reports for the other managers at the pharmacy, and asks for your help in
creating the reports shown in Table 5.11.

Create queries as necessary to serve as the basis for the
reports. As you save the new reports, be certain to use the name specified in
the following steps, including the “rpt” prefix. Also consult your instructor
for instructions about submitting your results.

Complete the following:

Marie needs to develop a customer relations report. Depending
on their health plan, customers might need to submit a list of all
»

Marie Cresson of Hudson Bay Pharmacy needs additional
reports for the other managers at the pharmacy, and asks for your help in
creating the reports shown in Table 5.11.

Create queries as necessary to serve as the basis for the
reports. As you save the new reports, be certain to use the name specified in
the following steps, including the “rpt” prefix. Also consult your instructor
for instructions about submitting your results.

Complete the following:

Marie needs to develop a customer relations report. Depending
on their health plan, customers might need to submit a list of all
prescriptions for reimbursement. Marie wants to create a report that allows a
customer to specify a time period, and then generate a list of prescriptions
received during that period. Because a technician will print this report for a
single customer at a time, the technicians must be able to specify the customer
number and the time period before they produce the report. Create an on-demand
report showing drug purchases during a particular time period for insurance
reporting for a single customer. Base the report on a parameter query named
qryRxList. This report should also calculate the total cost of refill
purchases. Make sure that the report uses the theme specified for Hudson Bay
Pharmacy and that it is in good form. Save the report as rptRxList.

»