Access assignments, CS102

Access Assignments, CS102, Fall 2000

To main CS102 page, look there for due dates.

For Access, it is IMPORTANT to copy the file you need, from C:\Class Material\CS102\ Access tutorials, to your own floppy, before opening the file in Access. This is because the "Save" process is different in Access from any other package we have used--it saves the database periodically on its own, and automatically when you close. Opening the file and using Save As to get a copy with a different name is NOT an option.
One way to copy: Right click on the Start button, choose Explore. Use the tree structure to find the file, copy it, paste it to your floppy.
Case 1 files are in Class Materials\CS102\Access 1-4\Disk 2\Cases

Assignment 8: On Tutorial 1, sessions 1-2 (Read ahead between classes to the end.) Do the Quick Checks for yourself, don't hand in. (Answers to Quick Checks for tutorials 1-4 are on p. A 4.35)
Hand in:

p. 1.24, Case 1, all (uses MallJobs file)
p. 1.25, Case 3, all (Uses Walks file)

Assignment 9: On Tutorial 2. Do the Quick Checks for yourself, don't hand in.
Hand in:

p. 2.30-31, Case 1, all (uses MallJobs, Openings files)
p. 2.32-33, Case 3, all (Uses Walks, Pledge files)

Assignment 10: On Tutorial 3. Do the Quick Checks for yourself, don't hand in.
Hand in: pp. 3.36-3.37

p. 3.36, Case 1, all (uses MallJobs file)
p. 3.37, Case 3, all (Uses Walks file)

Assignment 11: On Tutorial 4. Do the Quick Checks for yourself, don't hand in.
Hand in: Printouts from the inclass tutorial:

p. 4.10, current form for record 82
p.4.26, pages 1 through 5 of the report. Pages 3 and 5 should have the records for customers 135 and 322, and reflect the changes you made to those customers' orders on p. 4.12.

Assignment 12: On Tutorial 5. Do the Quick Checks for yourself, don't hand in.
Hand in: Printouts from the inclass tutorial:

Section 1

p. 5.11, 5.12: PRINT these queries to HAND IN, but first go to Page Setup and change the Page orientation to Landscape, so it fits on one page.
After p. 5.15 PRINT to HAND IN the unpaid with late charge accounts from Michigan (MI)
Design a query that will get you all the orders for the Roadhouse Restaurant, and print it. It should include the new order you added on p. 5.7.

Sections 2, 3

PRINT TO HAND IN page 1 only of your form, at the end of section 5.2 (p. 5.34)
PRINT TO HAND IN page 1 (there should only be 1) of the results of your query, at the end of section 5.3 (p. 5.47)
If you made the subform, switch to the order tab (still in the query) and print that result instead.

To Sievers Home Page

CS102-Fall00/Accessassts.htm 11/29/00

This page belongs to Sally Sievers who is solely responsible for its content. Please see our statement of responsibility.