• Pictures

• The Groovy Girls
  
• Resumes

• Family

• Poetry

• Tulsa
  Community
  College

• Home

DATABASE FOR MICROCOMPUTERS

ACCESS 2002 (XP)
SYLLABUS Fall 2002 

Prerequisite:   
 CSC 1203 or Instructor approval.

Next Course(s) In Sequence
Advanced Database for Microcomputers.

Textbooks and Other Materials

• MICROSOFT ACCESS 2002,
  By Adamski, Hommel/Finnegan,  Course Technology Publishers

• 2 diskettes - 3 1/2"  High Density

• Zip disk

Notice
It is a violation of the law to create unauthorized duplication of copy-righted microcomputer software.  Tulsa community college makes every effort to support these copyright agreements and does not support illegal duplication of any copyrighted material.

Catalog Description
An introduction to a microcomputer database software package including how to create, update, or query a database, generate reports, set up a command file, and organize a database.  Students should have a working knowledge of the operating system in which they will be interacting.  Lecture 2 hours, lab 2 hours.

Objectives of the Course
To introduce the student to database using Access XP.  To provide a graphical user interface making a more user-friendly environment.  To learn the terms associated with database concepts working with a relational database.  Learning how to plan, create, and maintain Access databases.

Classroom Learning Experiences
Class time will be devoted to lecture, demonstrations, questions, discussion, and lab problems.

Grading Scale
Semester grades will be calculated on a total point accumulation basis, derived as follows:

Three exams will be given.  The last exam will not be comprehensive.  Grades will be based on a percentage of the total points applied to the 90-80-70-60 system.

Class Policies and Procedures

• Policy on class attendance.  Students are expected to attend ALL classes.  Often, material is provided in class that is not found in the text and missed class results in missed material.  When you miss class, You are responsible for getting notes and assignments from another class member.

• Missing an exam.  No make-up exams are given unless the student has been excused PRIOR to the absence.  You may call the instructor at any hour and leave a message on voice mail if necessary or you may email at any hour if necessary.  Make-up exams must be conducted in evening programs by prior arrangement.

• Dropping a class.  Non-attendance of class does not constitute official withdrawal.  Formal withdrawal procedures are the responsibility of the student.

• Academic Dishonesty.  Any dishonesty during an examination will result in 0 points on the 1st occurrence.  2nd occurrence will result in a failing grade for the class.  

Access 2002 - Final Project

 Why?
To apply your Access 2002 knowledge by creating a database from start to finish.

What?
Design and Develop a database to capture, collect, manipulate and report information that is of value to you.  This may be something for work, second jobs, recipes, groceries, expenses, hobbies, collections, and fun…

When?
This project will be presented on December 11, 2002

How?
There will be several minimum requirements that are mandatory for a ‘C’ grade.  You may complete more than the minimum for a higher grade.  

The requirements are:

1. At least 2 different tables
2. The tables must be joined by a common field with referential integrity
3. At least 1 query which displays data from both tables (sorts, groupings, aggregate functions, conditions are a plus).
4. At least 1 form to add, edit and delete data from both tables (additional functionality, main form/sub-forms, extra controls are a plus).
5. At least 1 report to display your data in a printable format (sorting, groupings, sub-reports are a plus).
6. An interface/switchboard to guide users through your database.
7. You may not use an Access 2002 database

2002 Fall Semester Calendar

Week 1....................... Aug 21....................... Introductions, Overview

Week 2....................... Aug 28....................... Tutorial 1,2

Week 3....................... Sept 4....................... No Class

Week 4....................... Sept 11....................... Tutorial 3

Week 5....................... Sept 18 ....................... Tutorial 4

Week 6....................... Sept 25....................... Exam 1

Week 7....................... Oct 2....................... Tutorial 5

Week 8....................... Oct 9....................... Tutorial 6

Week 9....................... Oct 16....................... Tutorial 7

Week 10....................... Oct 23....................... Exam 2

Week 11....................... Oct 30....................... Tutorial 8

Week 12....................... Nov 6....................... Tutorial 9

Week 13....................... Nov 13....................... Exam 3

Week 14....................... Nov 20....................... Thanksgiving Break

Week 15....................... Nov 27....................... Tutorial 10-11

Week 16....................... Dec 4....................... Open Lab Time

Week 17....................... Dec 11....................... Final Project Presentation

LAST DAT TO WITHDRAW FOR CLASS OR CHANGE FROM CREDIT TO AUDIT IS FRIDAY NOVEMBER 8^TH