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:
- learn to develop a normalized relational database
- learn to setup and maintain a database
- learn to develop a database to meet a business need
- learn to write a SQL
- learn to write Visual Basic script
Course Outline:
- Review of Access interface
- Concepts for MOUS certification
- Relational databases
- Query languages
- Database System Architecture
- Macro concepts
- Basics of VBA Programming
- Data Definition Objects (DAO)
- Access and the Internet
Text Books:
Several optional books are available at the bookstore. The class will focus on the information available at this Web site. The student will find it beneficial to obtain a resource book on advanced Access. Additional site information will be provided.
Requirements:
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.
Grading:
The student will be expected to complete all assigned work. In addition there will be a final exam.
Grading percents are:
- 70% Homework, projects, quizzes
- 10% Class participation, involvement, attendance
- 10% Mid-semester exam (if not given, 10% added to homework, projects, quizzes)
- 10% Final
Evaluation:
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.
Attendance:
The student is allowed to cut 6 hours of classes.
Methodology:
- Class students: The course is given using the lecture method and the student is encouraged to ask questions at any point during the lecture. When appropriate, class exercises and problem solving techniques are used. The "computer on wheels" will be used for many classes.
Web students:
This course is available on the CIS61 Web site. Handouts, PowerPoint presentations, assignments and other resources will be available on the Web.
Back to the Top
Return to home page
Return to previous page - CIS61