Open the file saved in week 6 Select all Type of items, except for any Binder.
Produce a new extract from all of the stationary data which, for each Type of item, calculates:
The average purchase price
The average sale price
The number of items in stock Sort this data into descending order of average purchase price. Show how you performed the summary query and the results of the calculations. Save the database using your last name_first name_CT7 and take a screen shot to show performed task.
Sun | Mon | Tue | Wed | Thu | Fri | Sat |
---|---|---|---|---|---|---|
23 | 24 | 25 | 26 | 27 | 28 | 1 |
2 | 3 | 4 | 5 | 6 | 7 | 8 |
9 | 10 | 11 | 12 | 13 | 14 | 15 |
16 | 17 | 18 | 19 | 20 | 21 | 22 |
23 | 24 | 25 | 26 | 27 | 28 | 29 |
30 | 31 | 1 | 2 | 3 | 4 | 5 |
Get Free Quote!
289 Experts Online