Database Programming and Management with Access - CIS61

Professor: Priscilla Grocer
Office: K-112

Course Description:

This course will teach the student to program using the programming language available in a relational database system. The student will learn to work with a variety of Access components including Structured Query Language and Access Data Objects. The student will analyze, design, develop, manage and execute projects in this powerful database environment. Prerequisite: CIS11 or CIS22 or permission of the instructor.

Course Objectives:

The objective of this course is to help the student become an effective database developer using Access. At the completion of this course, the following objectives should have been accomplished:

Course Outline:

  1. Review of Access interface
  2. Concepts for MOUS certification
  3. Relational databases
  4. Query languages
  5. Database System Architecture
  6. Macro concepts
  7. Basics of VBA Programming
  8. Data Definition Objects (DAO)
  9. Access and the Internet

Text Books:

Recommended Text:
Microsoft Access 2000 with Visual Basic for Applications (Advanced)
Kristie L Oxford
New Perspective Series by Course Technologies
ISBN 0-619-04466-7


There will be a mid-semester and final exam. If the class is producing a lot of work, the instructor may not feel that a mid-semester exam is needed. The mid-semester may become optional for those who are caught up or possibly the class can vote on having or not having a mid-semester. Quizzes will be given on an as needed basis. They will be announced or take-home quizzes. Development projects will be the main emphasis of the course. Weight will be based on complexity - programs at the beginning of the semester will not carry as much weight as the more complex programs at the end of the semester.
Students should check the Web site for schedule, assignments, programs and exams on a regular basis.


The student will be expected to complete all assigned work. In addition there will be a final exam.

Grading percents are:


Assignments and programs are graded using either number grades or letter grades based on the following (A=90-100), B=(80-89), C=(70-79), D=(60-69), F=below 60). The students grade for the course will use the same scale and will be based on the percentages explained in the grading section. Plus and minus grades will be given.
Many of the assignments in this class are open ended - the grading will be based on how well the project demonstrates mastery of the material. Students who do a minimum of work will be graded accordingly. Resubmission is allowed on open-ended projects to improve grades.
Note: Non open-ended assignments that are completed accurately, with no errors, according to the parameters of the assignment will be graded as A. To achieve an A+, students must have done sufficient extra work in design or implementation that makes the assignment standout. In doing assignments, students must do their own work. Relying too heavily on my examples or working too closely with someone else will be penalized.


The student is allowed to cut 6 hours of classes.


This SYLLABUS is not to be construed as a CONTRACT in any way, shape, manner or form. This SYLLABUS is a SUGGESTED course OUTLINE and will be GENERALLY followed, subject to change according to the INSTRUCTOR'S discretion and needs. Academic FLEXIBILITY is important!

Back to the Top
Return to home page
Return to previous page - CIS61