| Date |
No. |
Assignment |
| 04-Jan-01 |
1 |
Access Tutorial 1.1 DB
Concepts |
| 11-Jan-01 |
2 |
Read Chapters 1 and 2, What
is Access, Installing and Using Access. Do Lab Ex 1, Intro and 2, Creating
a Database |
| 18-Jan-01 |
3 |
Read Chap 3&4, Database
Concepts and Tour of Access 2000. Start Lab Excercise 3 Table Design. |
| 25-Jan-01 |
4 |
Read Chap 5, Database
Design, & 6,Creating Database Tables. Lab 4, Access Objects: Queries,
Forms, Reports (See
homework sheet or Lab for Details) Lab,
. |
| 01-Feb-01 |
5 |
Read
Chap. 7 Entering/Changing/Deleting/Displaying Data and Ch 8 Creating and
Using Simple Data-Entry Forms. In Lab:
Lab 5 Controlling Users Input |
| 08-Feb-01 |
6 |
Read Chap 9 Queries and 10
Printing Reports Start Lab 7 Forms Design. |
| 15-Feb-01 |
7 |
Mid Term Practical Exam. Be able to create Databases, Tables, Forms, Queries, and Data Access Pages |
| 22-Feb-01 |
8 |
Go over Practical Exam. Do Multiple Choice Exam |
| 01-Mar-01 |
- |
Teachers Conference, No Class |
| 08-Mar-01 |
9 |
Read Chap 11 Relationships Chap 12 Using Operators, Functions & Expressions. Lab 6 Relationships |
| 15-Mar-01 |
10 |
Chap 13 Creating Relations & Joins in Queries Ch 14 Creating Select Queries.
Lab 8 Exploring and Analyzing Data |
| 22-Mar-01 |
11 |
Chap 15 Understanding Controls & Properties. Chap 16 Creating & Customizing Data-Entry Forms, Lab 9&15 |