Database management computre science questions

Department Staff and Facility Usage Report

Create the report rptEmployeeSales, with subreports subRptEmployeeSalesByRoomType and subRptReservations, as per the following specifications.

a$)$ Description of Layout: See image later in this document

b$)$ Data source:

i$)$ The main report should use the Employees table, display the employees full name in the format $$FirstName MiddleName LastName$$

ii$)$ The subRptReservations subreport draws its information from the Reservations table, the length of the stay is the difference between the check in and check out time in days.

iii$)$ The subRptEmployeeSalesByRoomType subreport draws its information from a crosstab query that shows how sales were for each room type by the facility.

c$)$ Report details:

i$)$ Prompt the user for a Employee Number and only show results for that Employee. For example, if ID $1$ was entered only data related to that ID would show.

ii$)$ The report title should be $$Employee Number: X Sales Report$($replace X with the entered employee number$)$ and should appear at the top of the first page only. Report titles must be size $16$ font, bold, and centred in the report.

iii$)$ The date the report was generated, and the page number should appear at the bottom of every page.

iv$)$ The subRptEmployeeSalesByRoomType subreport should show the room types and the total revenue for each for that specific employee. Sort ascending by room type.

The order of the totals along the top should be Main Campus Housing A$,$ Main Campus Housing B$,$ South Campus Housing C$,$ and North Satellite Housing D$.$pe$.$