SILS iSchool

30 Oct 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 | Access- a RDBMS | create a database | next session

01 Nov | tables
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





Create an empty database, which you will later populate with imported and created data.

The database is a vessel that holds multiple, related objects

To become familiar with Access,
start by creating a new blank database to use as the basis for Task 05

save it to your working folder using a descriptive filename

you don't have to build the structure just yet, but have it ready for use

back to top

Create a second new blank database to use for practice

  1. save it to your working folder under a descriptive filename
  2. if you wish, you may download the Northwind database and look it over to familiarize yourself with some of the Access tools
    • this database is far more complex than anything you will be doing, but the relationships between tables in Northwind are examples of how you need to tie your tables together to make them work in a relational manner
[MSAccess Northwind Database]

back to top