Creating Effective Reports for NHD Development Group Inc. In this project, you continue working on..

Creating Effective Reports for NHD Development Group Inc.

In this project, you continue working on the database for an
antiques mall, Memories Antiques in Cleveland, Tennessee. You have been working
with Linda Sutherland, the manager of the mall, and with Tim Richards, the
chief information officer of the NHD Development group, who owns this mall and
several other malls across the country. Tim and Linda are ready to consider
what types of written reports they will be able to obtain through the database.
In this project, you design several reports that Tim will send to the NHD
corporate
»

Creating Effective Reports for NHD Development Group Inc.

In this project, you continue working on the database for an
antiques mall, Memories Antiques in Cleveland, Tennessee. You have been working
with Linda Sutherland, the manager of the mall, and with Tim Richards, the
chief information officer of the NHD Development group, who owns this mall and
several other malls across the country. Tim and Linda are ready to consider
what types of written reports they will be able to obtain through the database.
In this project, you design several reports that Tim will send to the NHD
corporate headquarters about the Memories Antiques Mall. His main goal is to
create reports that are clear, appealing, and well organized, using a format
that makes information easily accessible.

Complete the following:

At the meeting, Tim plans to discuss the classes that are
offered at the mall and brainstorm ideas for new classes. He believes that
additional classes could boost the mall’s profit significantly. He asks you to
create a report showing the current class offerings, along with the name of the
instructor (in the form Last, First), the number of customers who are currently
enrolled and have paid, the cost of the course, and the total amount that has
been received for each class. (Hint: You can use a query as the basis of this
report.) The final page of the report should show the grand total of all
collected class fees. Because this grand total is the most important
calculation in the report, Tim suggests that you format it so that it stands
out from the other information. Name the report rptClassEnrollment.

»