IFSM 201

Access lab/homework  K

Either:
 Print each lettered part result.
   OR 
 Copy and paste each lettered part all into one Word document. 
 This means that each "print" becomes a copy and paste of the resulting table into the Word document.
 Label each pasted part. Print the Word document.

Do these:

1.  Using the tables of Unit K: K-1.accdb file.
 a.  print the filtered and sorted Customers table of page 250.
 b.  print the filtered records that are from 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.
 c.  print the query results of page 254. 
 d.  print the results of the query of page 258/259.
 e.  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.
 a. print the query results of part 4. (there is no figure).
 b. print the query results of part 5 (figure K-25).
 Ignore the X's on 6. 7. and 8. Do them.
 c. print the Top Puzzles by Supplier query results (figure K-26).


3. Independent Challenge 1 using the K-3.accdb file.
 a.  print part d.
 b.  print part f.
 c.  print the Soccer Campers query results.
 d. 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.