meets Tuesday and Thursday from 0800-0915
office hours in Manning 112
Class Schedule
10 Jan | intro
15 Jan | clients
17 Jan | servers
22 Jan | networks
24 Jan | basics lab
29 Jan | structural layer
31 Jan | presentational layer
05 Feb | working with layers
07 Feb | behavior layer |
12 Feb | images & design
14 Feb | website lab
19 Feb | document markup
21 Feb | graphics
26 Feb | document markup lab
28 Feb | spreadsheets
05 Mar | formulas & functions
07 Mar | data display
19 Mar | database tools
21 Mar | spreadsheets lab
26 Mar | relational databases
28 Mar | tables
02 Apr | relationships
04 Apr |
forms for input |
05.03 |
reports for output |
05.04 |
next session
09 Apr | SQL
11 Apr | complex queries
16 Apr | databases lab
18 Apr | presentation design
23 Apr | presentation delivery
25 Apr | presentation lab
30 Apr | 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.