CIS 202 Section 01 Fall 2000
Mr. Richardson
Tentative Class Schedule

Monday and Wednesday, AJT 206, 1:00 – 2:50 p.m.

Week 1:

August 28

Welcome
Introduction
Review Syllabus
Databases Jeopardy!

August 30

Review CIS 115 Database topics
PORTFOLIO ASSIGNMENT: Database Glossary
READ: Chapters 1 & 2 (pp. 3-82)

Week 2:

September 6

ASSIGNMENT:  Internet Scramble
ASSIGNMENT:  Assessment #'s 1-5 on pages A43-A46
READ: Chapter 3 (pp. 83-132)

Week 3:

September 11

Creating a database
Creating Simple Tables
Defining Relationships
Simple Form
Simple Reports
READ: Chapter 4 (pp. 133-166)
ASSIGNMENT: Assessment #'s 1-2 on pages A78-A79)

September 13

Integrating Access with other office products
DISCUSSION: Databases and the Internet
READ: Chapter 5 (pp. 167-192)

Week 4:

September 18

Simple Queries
Specifying Criteria
ASSIGNMENT: Assessment #1 & #2 on p. A188 & A189
Review For Test #1

September 20:

Test #1
READ: Expert Chapter 1 (pp. 3-25)

Week 5:

September 25

Review Answers for Test #1
Specifying Field Constraints

September 27

Advanced Table Relationships
READ: Expert Chapter 5 (pp. 129-154)

Week 6:

October 2

Case Study

October 4

Working with Forms in Design View
READ: Expert Chapter 2 (pp. 29-60)

Week 7:

October 9

Advanced Forms
Setting startup options
Intro to user interfaces - switchboards
READ: "Relational Database Design" from Class Website

October 11


Switchboards re-visited
READ: Expert Chapter 3 (pp. 61-92)

Week 8:

October 16

Advanced Queries
READ: Expert Chapter 4 (pp. 93-128)

October 18

Advanced Reports
Review for Test #2

Week 9:

October 23

Test #2

October 25

Review Answers to Test #2
Introduction to SQL
READ: SQL material on class website

Week 10:

October 30

Multi-table SQL
Using complex criteria in queries

November 1

Using subqueries
PORTFOLIO ASSIGNMENT: SQL Reference
Review for Test #3

Week 11:

November 6

Test #3

November 8

Review answers for Test #3
Designing a database application
Case Study
READ: Expert Chapter 7 (pp. 187-216)

Week 12:

November 13


READ: Expert Chapter 6 (pp. 155-186)

November 15

Briefcase Replication
 Access security
 Review for Test #4

Week 13:

November 20

Test #4

Week 14:

November 27

Review answers for Test #4
Access Macros

November 29

Using Visual Basic for applications with Access

Week 15:

December 4

Review for Test #5
Embedding SQL in VBA

December 6

Test #5

Week 16:

December 11

Review Answers for Test #5
Class Projects Due
Project Presentations Begin

December 13

Project Presentations Cont.
Review for Final Examination

Week 17:

December 20

Final Examination (11:00a.m.)