SILS iSchool

08 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
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 

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 to prepare yourselves
for the session on creating queries to retrieve data from tables.

To prepare yourselves for the - next session ...

Access 2007: The Missing Manual, 1st Edition

Look over these for simple queries

  1. In Access 2007: The Missing Manual, 1st Edition,
    read 6. Queries That Select Records.
  2. Introduction to queries
  3. You may find the Wikipedia entry on Structured Query Language (or SQL) useful for background, but don't get too deeply wrapped up in it right now.

You might also want to look at Microsoft's tutorial on queries.

back to top