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:

To prepare annual bonuses for employees, the first report
Tim needs is an employee compensation report. He’ll use this report to
determine an appropriate bonus amount for each employee, so it should include
detailed information. To compare salaries and wages fairly, the report should
group employees by position. Tim also wants the report to show summary
statistics for all positions, including the sum, average, maximum, and minimum
of the hourly rates. The report should also calculate the total salaries and
total wages at the end of the report. Name this report rptEmployeeSalaryDetail.

»