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
27 Sep | object layers
02 Oct | tools that read markup
04 Oct | document markup lab
09 Oct | spreadsheets
17 Oct | formulas & functions
22 Oct | 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 | input & output
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
You will be called upon to demonstrate specific relational database skills.
The task will be released as five parts,
one a day,
as we practice Access components.
Everything in this task is something we will have demonstrated and/or tried in class.
You are to create a book database for a private client, not too unlike Mr. Pitt on Seinfeld. The client has his own library and needs you to organize his holdings and be able to order new books for his library when he wants them.
You may work in teams on this task as you did on the previous tasks. When your team has completed the task, one member of the team will store it in that person's password protected directory. Each of the members of the team will place a hyperlink to it on their respective web sites (the individual storing it will have a relative link to it, the others will have absolute links to the finished task). When it's ready for me to download and grade, send me a note telling me to retrieve it from your websites.
Though there are several different commercial relational database software applications, we need to use Microsoft Access for this purpose because it will provide an appreciation for relational databases. Additionally, other database classes in SILS assume a working knowledge of Access as a baseline skill.
We will build this database step by step in class. The exercises you will have after each class will be part of the task.
It should meet the standards laid out on the task 05 gradesheet.
Everything on that gradesheet will be analogous to something we will have done in class.
Save the finished product using the standard file name structure for this class.