Week
|
Lectures
Topics & Assignments
Tentative
Schedule
|
Readings
|
1
|
April 3
Syllabus, database concepts, database design
|
April 5
Intro to MS Access and tables
|
See Assign 1
|
2
|
April 10
Queries and forms
|
April 12
Reports
|
See Assign 1
|
3
|
April 17
Visual basic editor
Assignment 1 Due, 4:45pm
|
April 19
Object model
|
Zak text: Tutorial 1 Concept Lesson, Tutorial 2
Concept Lesson
|
4
|
April 24
Object variables
|
April 26
String
variables
Assignment 2 Due Friday, April 27, 4:45pm
|
Zak text:
Tutorial 3 Concept Lesson,
Tutorial 4 Concept Lesson
|
5
|
May 1
Date variables
Review for midterm exam
|
May 3
Midterm Exam
|
Zak text:
Tutorial 5 Concept Lesson
Tutorial 6 Concept Lesson
|
6
|
May 8
Numeric variables
|
May 10
Selection structure
|
Zak text:
Tutorial 7 Concept Lesson
Tutorial 8 Concept Lesson
|
7
|
May 15
Select case statement
|
May 17
For Next and For Each structure
Assignment 3 Due Thursday, May 17, 4:45pm
|
Zak text:
Tutorial 9 Concept Lesson
Tutorial 10 Concept Lesson
|
8
|
May 22
Do Loop structure
|
May 24
Custom dialog boxes
|
Zak text:
Tutorial 12 Concept Lesson
|
9
|
May 29
Special dialog box controls
|
May 31
Special dialog box controls
Assignment 4 Due
Friday, June 1, 4:45pm
|
Zak text:
Tutorial 13 Concept Lesson
|
10
|
June 5
Automation
|
June 7
Review
Assignment 5 Due
Friday, June 8, 4:45pm
|
Zak text:
Tutorial 14 Concept Lesson
|
11
|
Thursday, June 14, 8:00am
Final Exam - Covers material since the midterm
exam
|