IFSM 201

Access lab/homework  2

Do these:
Because these are all results of queries, paste
them into one Word document, clearly labeling
them as 1a 1b etc and submit the one Word document.

1.  Using the tables of Unit K: using the K-1.accdb file.
 a. paste the sorted Customers table of page 248.
 b. paste the filtered records of page 250.
 c. paste the query results of page 254.
 d. paste the query of the related tables of page 258.

2. Skills Review of pages 263-265, using the K-2.accdb file.
   a. Paste the query results as in figure K-25
   b. Paste the query results as in figures K-26
  Skip part 8.

3. Independent Challenge 1 on page 265-266, using the K-3.accdb file.
Paste part d and part f.
Paste the Soccer Campers query results.
Also do the Advanced challenge Exercise.  Paste the Camper Payments Due query results.

4. Visual Workshop on page 270, using the K-7.accdb file..