IFSM 300
Access Assignment  Week 7

Look at 
http://davidwills.us/ifsm201/access_totals.txt
for summary of how to do statistical (or aggregate) functions in Access.

Do these:

1.  Using the tables of Unit K: your modified K-1.accdb file,

 a. print the results of a query that has the count, sum, average, min and max of YTD Orders.
 b. print the results of a query that has the count, sum, average, min and max of YTD Orders Grouped By State.
 c. print the results of a query that has the count, sum, average, min and max of YTD Orders Grouped By Rep ID.
 d. print the results of a query that has the count, sum, average, min and max of YTD Orders Grouped By Region.
 e. print the results of a query that has the count, sum, average, min and max of YTD Orders Grouped By Region, Grouped by State.


2. Using the tables of Puzzle Universe database (the former K-2.accdb)
a. print the results of a query that has the count, sum, and average of Units Sold.
b. print the results of a query that has the count, sum, and average of Units Sold Grouped By Category,
   after fixing the error.
c. print the results of a query that has the count, sum, and average of Units Sold Grouped By Target Age Group.
d. print the results of a query that has the count, sum, and average of Units Sold Grouped By Supplier Name.
e. print the results of a query that has the count, sum, and average of Units Sold Grouped By Supplier Name, Grouped By Category.

3. Using the tables of K-7.accdb (or Teen Charity Race database)
a. print the results of a query that shows for each Biker School the number of sponsors it has
   and the sum, average, and max of the Amounts it has.