Class Schedule
22 AUG | intro
27 AUG | clients
29 AUG | servers
05 Sep | networks
10 Sep | basics lab
12 Sep | structural layer
17 Sep | presentational layer
19 Sep | working with layers
24 Sep | behavior layer
26 Sep | images & design
01 Oct | website lab
03 Oct | object layers
08 Oct | graphics
10 Oct | document markup lab
15 Oct | spreadsheets
17 Oct | formulas & functions
22 Oct | thoughts about data display
18 Oct | Fall Break
24 Oct | database tools
29 Oct | spreadsheets lab
31 Oct | relational databases
05 Nov | tables
07 Nov | relationships
12 Nov | forms for input |
Task 05.03 |
reports for output |
Task 05.04 |
next session
14 Nov | SQL
19 Nov | complex queries
26 Nov | databases lab
21 Nov | Thanksgiving
28 Nov | presentation design
03 Dec | presentation delivery
05 Dec | presentation lab
12 Dec | 0800-1100 | final in class presentation
This work
is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.
home & schedule | class blog | syllabus | contact | grades
Make four forms -
one each to enter book, author, and publisher data to the database,
and one to order new copies of books already in the book table
Remember, the sole purpose for this form is to provide a method for someone to enter new author information into the Author table.
Remember, the sole purpose for this form is to provide a method for someone to enter new publisher information into the Publisher table.
This will be a bit more complex than the first two forms, so use the Form Wizard to generate the form.
remember, you must add books to the database before you can order them
This form has two purposes.
This will incorporate fields from several tables into this one form, so again, use the Form Wizard to generate the form.
Pay attention to the professional appearance of all forms. Make sure items in a column of the form are aligned.
Here are some new books to add to your database by using your books form. You may add others, but you must add these.
You may order any titles that exist in your Book table, but be sure to create at least ten separate orders.
Five of the orders should have a delivery date included; five should not have a delivery date yet.
Don't restrict yourselves in your orders. Make them for large numbers of copies in each order, so that your
queries will show large variances when you run them.