SILS iSchool

01 Nov 2018

Value Added | daily

Class Schedule

Basics | sessions 01-05

21 Aug | intro
23 Aug | clients
28 Aug | servers
30 Aug | networks
04 Sep | basics lab

Web Development | sessions 06-11

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

Document Markup | sessions 12-14

02 Oct | object layers
02 Oct | graphics
09 Oct | document markup lab

Spreadsheets | sessions 15-19

11 Oct | spreadsheets, formulas & functions
16 Oct | thoughts about data display
 18 Oct  | Fall Break 
23 Oct | database tools
25 Oct | spreadsheets lab

Relational Database | sessions 20-26

30 Oct | relational databases

 01 Nov  | tables | 05.01 |  next session 

06 Nov | relationships
08 Nov | input & output
13 Nov | SQL
15 Nov | complex queries
20 Nov | databases lab
 22 Nov | Thanksgiving 

Presentation | sessions 27-30

27 Nov | presentation design
29 Nov | presentation delivery
04 Dec | presentation lab
13 Dec | 0800-1100 | final in class presentation





Glance over these readings to prepare yourselves for the relationships session.

Read over these

Access 2007: The Missing Manual, 1st Edition
  1. In Access 2007: The Missing Manual, 1st Edition,
    read 5. Linking Tables with Relationships.
  2. Guide to table relationships
  3. It wouldn't hurt to read the Wikipedia entry on Foreign key for background.
  4. Read this linked article again
    • you already read it prior to the first relational database session to have an idea about why relational databases are useful
    • now read it again after pondering the lecture on tables
    • in the next session we will discuss how and why to relate tables and we will create relationships between them

back to top