IFSM 201

Access lab/homework  2

Do these:

1.  Using the Customer tables of Unit K: K-1.accdb file.
  print the filtered records that are from the 5 western states and whose YTD Orders is more than $1000 
      and Prior Year Orders is less than $10,000, sorted by State and Zip.
  print the query results of page 254/255. 
  print the results of a query that has the count, sum, average, min and max of YTD Orders.
  print the results of a query that has the count, sum, average, min and max of YTD Grouped By State.
  print the results of a query that has the count, sum, average, min and max of YTD Grouped By Rep ID.
  print the results of the query of page 258/259.
  print the results of a query that has the count, sum, average, min and max of YTD Grouped By Region.
  print the Customers table with the added calculated field of page 260/261, filtered to show 
    Total Orders less than $10,000



2. Skills Review of pages 263-264 using the K-2.accdb file.
 print the query results of figure K-25.
 print the query results of figure K-26.
Skip part 8.



3. Independent Challenge 1 using the K-3.accdb file.
Print part d and part f.
Print the Soccer Campers query results.
Also do the Advanced challenge Exercise.  Print the Camper Payments Due query results.