Class Schedule
21 Aug | intro
23 Aug | clients
28 Aug | servers
30 Aug | networks
04 Sep | basics lab
06 Sep | structural layer
11 Sep | presentational layer
18 Sep | working with layers
20 Sep | behavior layer
25 Sep | images & design
27 Sep | website lab
02 Oct | object layers
02 Oct | graphics
09 Oct | document markup lab
11 Oct | spreadsheets, formulas & functions
16 Oct | thoughts about data display
18 Oct | Fall Break
23 Oct | database tools
25 Oct | spreadsheets lab
30 Oct | relational databases
01 Nov | tables
06 Nov | relationships
08 Nov | forms for input |
Task 05.03 |
reports for output |
Task 05.04 |
next session
13 Nov | SQL
15 Nov | complex queries
20 Nov | databases lab
22 Nov | Thanksgiving
27 Nov | presentation design
29 Nov | presentation delivery
04 Dec | presentation lab
13 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.