Assignments

Home Up Prospectus Assignments Lab Outline Homework Database Concepts Using Documentor The Power of Queries Table Relationships Mid Term Review Final Review Final Ex.Inf. Thurs Eve Grades

Assignments for Access, MDCC CGS 1541 and CGV 0250

Thurs 5:40-8:10PM, R.Merry Instructor, Room 3107

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 
29-Mar-01 12 Chap 17 Creating Great Looking Forms, Chap 18 Adding Data Validation Controls to Forms, Lab 10 Forms Properties 
05-Apr-01 13 Lab 11 Calculated Fields due Read chap 22 calculations & summaries
12-Apr-01 14 Review, Final Practical Exam Starts
19-Apr-01 15 Final Exam Access MC
26-Apr-01 16 Make up exams, grades available on the Website
    Best of luck in the future!
 

Home Prospectus Assignments Lab Outline Homework Database Concepts Using Documentor The Power of Queries Table Relationships Mid Term Review Final Review Final Ex.Inf. Thurs Eve Grades