Exercise 2 Questions

Using the database (pics in 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.

Sort & Filter Records Clipboard Calendar (E Customer sales a Inventory Sales-Inventory Date Salesperson , Customer . Click to Add ID - Salesinvoice 101 102 1/5/2017 K. Parrilla 103 1/7/2017Z. Wu 104 1/9/2017 Z. Wu 105 1/11/2017 A. Talton 106 1/13/2017 Z. Wu 107 1/18/2017 K. Parrilla 108 1/19/2017Z. Wu 109 1/24/2017 A. Talton 110 1/24/2017 K. Parrilla 111 1/25/2017 K. Parrilla 112 1/27/2017 A. Talton 113 1/28/2017 A. Talton 114 1/30/2017 z. wu 115 1/31/2017 K. Parrilla 4/2017Z. Wu 152 151 153 153 153 153 152 152 152 152 153 151 152 150 10 12 13 14 15 (New)