Revised June 2010
CS 135DB Course Description
Course Title: Advanced Database  
Course Number: CS 135db
Credits: 3
Institution: Clackamas Community College
Outline Developed by: Bill Allen
Course Description: 
This course is a continuation of CS-121 with design, construction and documentation of database management systems using MS Access 2007. This will include designing reports, customizing forms, advanced form technique, OLE fields, changing and customizing tables, creating and using macros, creating and using an application system. This class is also offered online.
Expected Student Outcomes:
Upon completing this course the student will be expected to know how to: 
•	Design, develop, update, modify and customize an Access relational database. (8C)
•	Design a database that follows design guidelines, reduces data input errors, and maintains referential integrity. 
•	Design, develop, update, modify and customize tables. 
•	Design, develop, update, modify and customize forms. 
•	Design, develop, update, modify and customize reports. 
•	Design, develop, update, modify and customize queries. 
•	Add, edit, and delete records. 
•	Use a variety of different data types and properties in creating a database. 
•	Use bound and unbound and calculated controls. 
•	Multiple tables with one-to-many versus many-to-many relationships. 
•	Use sub-forms and transaction detail tables when designing a relational database. 
•	Use macros, switchboard and Visual Basic for Application to create custom applications. 
•	Pass the Microsoft Users Certification exam.

Length of Course: 
One quarter with 3 lecture hours per week
Prerequisite: 
CS121 or equivalent experience.
Grading Method: 
Letter grades are assigned on the standard 10% increment scale. The course may also be taken as a Pass/No-Pass.
Required Text: 
New Perspectives: Microsoft Access 2007 Comprehensive; Adamski, Finnegan
Assessment Process: 
Twelve (12) projects
One (1) Final project
Multiple quizzes, midterms and one Final Exam
Final Project
The final project will be a comprehensive relational database developed by the student for a demonstration of knowledge of the processed covered in the class. Ideally this project will be one that the student will apply to his/her own personal use. The student will have the option of using a generic scenario if they do not have a specific personal basis for the project.  

CS 135DB Course Outline
 
I. Introduction    
II. Introduction to Microsoft Access 2000  
III. Maintaining a Database 
IV. Creating Forms and Reports  
V. Querying a Database 
VI. Creating Forms and Reports 
VII. Creating More Advanced Queries and Custom Forms 
VIII. Customizing Reports and Integrating Access with Other Programs 
IX. Working with HTML Documents, Data Access Pages, and Hyperlink Fields 
X. Using Query Wizards, Action Queries and Briefcase Replication 
XI. Using and Writing Visual Basic for Application Code 
Total 32 hours