26 Mar 2019
meets Tuesday and Thursday from 0800-0915
office hours in Manning 112
Class Schedule
10 Jan | intro
15 Jan | clients
17 Jan | servers
22 Jan | networks
24 Jan | basics lab
29 Jan | structural layer
31 Jan | presentational layer
05 Feb | working with layers
07 Feb | behavior layer |
12 Feb | images & design
14 Feb | website lab
19 Feb | document markup
21 Feb | graphics
26 Feb | document markup lab
28 Feb | spreadsheets
05 Mar | formulas & functions
07 Mar | data display
19 Mar | database tools
21 Mar | spreadsheets lab
26 Mar |
relational databases |
Access- a RDBMS |
create a database |
next session
28 Mar | tables
02 Apr | relationships
04 Apr | input & output
09 Apr | SQL
11 Apr | complex queries
16 Apr | databases lab
18 Apr | presentation design
23 Apr | presentation delivery
25 Apr | presentation lab
30 Apr | 0800-1100 | final in class presentation
School Information
This work
is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.
home & schedule | class blog | syllabus | contact | grades
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
- save it to your working folder under a descriptive filename
-
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]](images/rdbms.northwind.png)