CS102, Fall 2000, Day 11, Tuesday, November 21
IN CLASS: Continue with Tutorial 3.
If you finish, start
Tutorial 4 If you played around with searching and
sorting the file after Ch. 3, as I did, it may not give you the same record
numbers as below. You can just adjust, or you can get from me a copy
of the Restaurant file as they expected it to be after Tutorial 3.
Assignment 11 is just to work through the tutorial, printing out
some results.
Session 1: Creating and using forms, from a single table.
-
Before you start, be sure that the Order table is sorted on Order number,
smallest to largest, and you will probably get the book's results..
The form seems to preserve the same order for its records as the
table had when you made the form first. Reordering the table won't
change the record numbers in the form derived from it.
-
p. 4.8, wildcards: The * and ? are used as shown here, in
many other applications (also in Tut. 5). Worth remembering.
Session 2: Forms and Reports from related tables. Seemed straightforward
to me
-
The one-to-many relation between the Customer and the Orders the customer
makes leads us to a Form-with-subforms structure, and a Report structure
with the orders grouped by Customer. There aren't too many other
ways to organize this particular database. But check out carefully
the examples Access provides (p. 4.19) of groupings in a more complex
system with customers, orders, and sales reps who work with customers and
get orders.
-
pp. 4.28-29 Compacting the database: This is just throwing away
"deleted" stuff. If you do it with the database open, it will compact
and automatically save it under the same name. To get the sequence
in the text, be sure to do 1. Click the Close button on the Database
window title bar. Then you'll have an empty gray window, and when you
go to compact, you'll get to choose which file, what new name, etc.
For Assignment 11:
-
Print as it tells you to on p. 4.10.
-
On p. 4.26, print pages 1 to 5. 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. (You can check them in print preview--that's where
they were on my printer.) If you want to print just the single
pages--page 1, the page with customer 135, the page with customer 322,
you'll have to do the print command 3 separate times. The Access
print menu only accepts a range of pages, not separate ones.
To Sievers Home Page
CS102-Fall00/Day11.htm 11/19/00
This page belongs to Sally Sievers who is solely responsible
for its content. Please see our statement
of responsibility.