IFSM 201

Access lab/homework  K2


1.  Using the tables of Unit K: K-1.accdb (now called Outdoor Designs.accdb)file.
  --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.



2. Skills Review of pages 263-264, parts 6 and 7, using the K-2.accdb 
(now called Puzzle Universe.accdb) file.
 --print the query results of figure K-26.
Skip part 8.



3. Independent Challenge 1, parts g-l, using the K-3.accdb (now called Bay Town Sports Camp.accdb) file.
 --pint the Soccer Campers query results.
Also do the Advanced challenge Exercise.  
 --print the Camper Payments Due query results.



4. Visual Workshop of page 270 using the K-7.accbd file.