Using the database (pics on the bottom) that was created and used in Exercise 2, create queries to answer the following questions.
1. How many sales did each salesperson sale on a Monday?
2. What salespeople sold dryers? Include who they sold the dryer to and on what date.
3. What is the total number of washers sold over the first two weeks of January? (Hint: The first two weeks refer to between January 1st and 14th. Also "total number" refers to washer units not numbers of sales. Some sales included more than one unit).
4. Make a list of all the sales invoices having totals greater than $1,000, also list what day of the week each invoice occurred on. Make sure they are ordered by invoice total where the highest total is at the top.
5. Make a list of salespeople who made no sales on a Monday (Hint: your answer to question 1 is a good starting point).
6. Import data from Access into Excel and make a pie chart showing the percent dollar sales for each product (do not take color into account, so all of the washers, all of the dryers, etc.). Include the Excel sheet with your submission.