access/database

THE PREVIOUS ASSIGNMENT THE TEACHER WAS SUPPOSE TO DO:

CIS 286 – Assignment 5

The last assignment looked at writing queries – we want to now use some of those queries and create reports based on them. For each report that I list below, put in a header with the report name and the date the report was run. Likewise, create a footer that has the page number of the report on it. Columns of data should have appropriate headings put on them too. Make sure that any currency columns are formatted with $ , and . Dates should be formatted in a consistent style as well. Some reports can be handled through the wizard and others will need to be hand designed – let me know which way you created each report.

1) After sorting via the “order by” clause, print the employees that work for Subsidiary 001 by Last_Name, group them by Job_Class_Code in a report. Note: this is a modification of a query from assignment 4.

2) Create a report that has a calculated field of Budgeted_Hours_Per_Pay * Hourly_Base_Pay for the employees that work at Subsidiary 002 – only print the employee’s name, budgeted_hours_per_pay, hourly_base_pay and the calculated field. This query exists from assignment 4.

3) Build a query that will count the number of employees at each subsidiary who work in a given department (given by Job_Class_Code). In other words, we want to create a group total on a department. The query should print the Subsidiary_Name, Job_Class_Code and a count of how many employees work in that particular department at that particular subsidiary. This query exists from assignment 4.

4) You wrote a query in assignment 4 that looked across all subsidiariess and answered which employee(s) earns the most money per hour? I would like a wage report that prints the high, low and average amount earned at each subsidiary.

5) Produce a report that shows the number of departments that each company has and the names of each department (Job_Class_Name). This query exists in assignment 4.

6) Write a report that groups employees at subsidiary 002 by the city that they live in. You will need to add this query. Format this report using one of the report themes so that it looks different from the other reports.