Create a visual representation of monthly data

Assignment Help Database Management System

Reference no: EM13758125

A table named "Daily Sales" in a Microsoft Access database has the following fields:

Product A

Product B

Product C

Product D

Each 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 Excel

Step 2 - Summarize Monthly Data for each product during the last 12 months

Step 3 - Create a visual representation of monthly data

Step 4 - Email the spreadsheet with your comments to your boss.

Reference no: EM13758125

Questions Cloud

Develop a network diagram : Getting a degree from a college or university can be a long and difficult task. Certain courses must be completed before other courses may be taken. Develop a network diagram in which every activity is a particular course that you must take for yo..

Problem related to the lease : Digi Ltd. a company that manufactures sells and leases cranes has entered into an agreement to lease a crane to Alum Ltd. The crane cost Digi Ltd 570,000 to make and has a fair value of $75.400 on 1 July 2013. Alum is having difficulties meeting i..

Supplies to reconnect the two computers : You checked your network supplies closet and found that you have various networking equipments and supplies including routers, switches, hubs, Ethernet NICs, 801.11b USB Network Adapter, various cables and connectors, etc. What can you use from yo..

Goals and implement an effective deployment plan : To establish project goals and implement an effective deployment plan, To gain insight into your company's transactions with data mining

Create a visual representation of monthly data : Create a visual representation of monthly data, Summarize Monthly Data for each product during the last 12 months

Compare mestiza and cultural issues found in two writer work : Compare the mestiza, borderlands, and cultural issues found in two writers' work.

Write a argumentative essay on british literature : Write a Argumentative Essay on British Literature.

Solicit some type of financial contribution : Write an email that will be sent to Americans to solicit some type of financial contribution and steal their credit card information. Identify the source of the recipient list that you will use to maximize your return and explain why. Make screen ..

Capital budgeting analysis : A project in South Korea requires an initial investment of 2 billion South Korean won. The project is expected to generate net cash flows to the subsidiary of 3 billion and 4 billion won in the two years of operation, respectively.

User Account

All Pages