This week you are requested by the management of your contracting business (Stat

This week you are requested by the management of your contracting business (Statewide Landscape Design, LLC) to create six reports regarding the prior year′s (2016) business data. Use the Access Report Wizard to create the six reports below. Most can be created using the Queries you created during the Midterm. Make sure you have corrected any queries your instructor made note of last week prior to beginning this assignment. When creating the following Access Reports, include a title at the beginning of each report. Expand the Report Naming convention given to create the Title for each report. As an example, the naming convention for report 3 is ″ContrTypeFinancials,″ so, title the report ″Contract Type Financial Report.″ Also, make sure that there is a page number in the footer. Also, note when there are category subtotals requested for reports where sub-groups are requested. Assignments Report 1. Use The ″CustData″ Query to create a report that alphabetically lists all customers for Statewide. Include Customer ID, Last Name, First Name, customer type, contract type, & Contract number – Organize the report alphabetically by Customer name (Report Name – CustData) Report 2. Use the ″ContrTypeFinancials″ Query to create a report that includes Customer ID, Contract number, Contract type, Contract amount, Contract profitability, Profit Generated – Organize the Report by contract type (All Landscape contracts first, then all Swimming Pool contracts following). Include an average contract amount, average contract profitability, and average Profit Generated at the end of each sub-group (Landscape and Swimming pool). What this provides is an analysis of the relative average contract amount, contract profitability and average profit generated during 2016 by type of contract (Landscaping and Swimming Pool installation) for the 2016 fiscal year (Report Name – ContrTypeFinancials) Report 3. Use the ″CustTypeFinancials″ Query to create a report that includes Customer ID, Contract ID, Customer type (Commercial or Residential), Contract Amount ($), Contract Profitability (%), and profit Generated ($) – Organize the report by customer type (All Commercial first, then Residential). Include an average contract amount, average contract profitability, and average Profit Generated at the end of each sub-group (Commercial and Residential). What this provides is an analysis of the relative average contract amount, contract profitability and average profit generated during 2016 by type of customer (Commercial or Residential) for the 2016 fiscal year (Report Name – CustTypeFinancials) Report 4. Modify the ″2016 CustHistory″ Query in order to create a report that includes Contract #, Customer Type, Repeat (yes or no), contract Amount ($) and Profit Generated ($) – Organize with ″Yes Repeats″ first, then ″No Repeats″ Insert a subtotal of Contract amount for the ″Yes Repeat″ sub-group and the ″No Repeat″ Subgroup. (Report Name – RepeatFinancials) Report 5. Modify the ″2016 CustHistory″ Query in order to create a report that includes Contract #, Customer Type, Referral (yes or no), contract Amount ($) and Profit Generated ($) – Organize with ″Yes Referrals″ first, then ″No Referrals″ Insert a subtotal of the Contract amount for the ″Yes Referral″ sub-group and the ″No Referral″ Subgroup. (Report Name – ReferralFinancials). Assignment Instructions: Submit one Access file for your Week 6 Assignment. It should include all of the following in the submission: (a) the two original databases, (b) 5 Queries and and (c) the 6 Access reports (listed above). When you receive your graded paperback from your instructor, make changes to your original as you will be using this file for your week 7 Assignment.