IFSM 201

Access lab/homework  2 (K, first part)

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 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.
Skip parts 6,7,8.



3. Independent Challenge 1 using the K-3.accdb file.
 --print part d and part f.