SILS iSchool

29 Oct 2018

Value Added | daily

Class Schedule

Basics | sessions 01-05

22 AUG | intro
27 AUG | clients
29 AUG | servers
05 Sep | networks
10 Sep | basics lab

Web Development | sessions 06-11

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

Document Markup | sessions 12-14

03 Oct | object layers
08 Oct | graphics
10 Oct | document markup lab

Spreadsheets | sessions 15-19

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 |  next session 

Relational Database | sessions 20-26

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 

Presentation | sessions 27-30

28 Nov | presentation design
03 Dec | presentation delivery
05 Dec | presentation lab
12 Dec | 0800-1100 | final in class presentation





We will be turning to relational databases in the next session,
so do these readings to prepare yourselves.

Preparations for relational database session

Access 2007: The Missing Manual, 1st Edition

Read

In Access 2007: The Missing Manual, 1st Edition,
read 1. Creating Your First Database.

It wouldn't hurt to read

Read this linked article twice

  1. Read it prior to the first relational database session so you will have an idea about why relational databases are useful.
  2. Then read it again after the tables session and prior to the session about relationships

Although we will not get into relationships until the third relational database session, an understanding of how to decompose your task into related tables will help you decide how to create the tables you will later need to relate.

back to top

If you use a Mac, you have two choices to be able to use Access

Best choice: virtualization software

Good choice: virtual server support

Pick one choice and be ready with it by the next class session.

back to top