1.A table named “Daily Sales” in a Microsoft Access database has the following fields:Product A Product BProduct CProduct DEach record on the table represents a day of total sales for each product and the data covers the last five years. Your boss asks you to create a visual report of the sales performance of each product during the last 12 months. Prepare a step-by-step description of how you would use Microsoft Excel to prepare the report and email it to your boss following these steps:Step 1 – Import data from Access to ExcelStep 2 – Summarize Monthly Data for each product during the last 12 monthsStep 3 – Create a visual representation of monthly dataStep 4 – Email the spreadsheet with your comments to your boss 2.You have been tasked with analyzing an extremely large amount of data and to ultimately produce a report to share with the Board of Directors. The data is currently in a text file and has over two thousand records of data. Explain how you would use Excel to analyze this data and organize it to prepare a written report. Be very specific on the variety of tools you would use and the steps you would go through to analyze the data and to ultimately prepare a detailed report with recommendations.
You can hire someone to answer this question! Yes, assignist.com has paper writers, dedicated to completing research and summaries, critical thinking tasks, essays, coursework, and other homework tasks. Its fast and safe.