MONTGOMERY COLLEGE
Computer Science, Information & Interactive Technology, Rockville

CA 240 - Advanced Database Applications
(This is a sample syllabus)

Course Syllabus

 

Course Description:
Intended for the intermediate database user, this course covers topics such as sub forms, integration of databases, with other applications, customization, and macros. It also introduces Visual Basic for Applications (VBA). Together with CA141 this course will create a complete and thorough database series. 3 semester hours

Pre- or Co requisites: CA 141 or consent of department.

Assessment Levels: EN101/101A, MA100, RD110

Text/Textbook Files/Materials/Software (required):
·Text and Textbook files:The Access 2007 Guidebook, 6th Edition, by Maggie Trigg and Phyllis Dobson (ISBN 9780321517012)
·Materials: Zip disk or Flash drive.
·Software: MS Access 2007 and WinZip (free)

Objectives: Students should be able to perform the following tasks upon completion of this course.
Queries
· Create parameter and summary queries
· Create a lookup field
· Create crosstabs, find duplicates, find unmatched, and find top value queries
· Create append, delete, make-table, and update queries
· Use table joins in a query
· Use special wizards
· Use SQL
Forms
· Create main and sub forms
· Create multipage forms
· Use hyperlinks
· Use list boxes, combo boxes, option groups, check boxes, and toggle buttons in a form
Reports
· Embed charts in a report
· Link reports to Word or export to Excel
· Create and use sub reports
Macros
· Create and run macros
· Use conditions in macros
· Write autoexec macros
· Create and use switchboards
Customization
· Use VBA to customize a database by creating functions, event procedures, etc.
· Set start-up options
· Create custom toolbar and attach them to forms

Some students will gain "real-world" database design and implementation experience by building a database application that services the business needs of a community organization.

Grading:
A=100-90% B= 89-80% C=79-70% D=69-60% F=60%-below

Course grades will be based upon 1 mid-term, 1 final project, and randomly collected homework assignments. The relative weights of these assignments are:

	% of Course Grade	Units Covered	Approximate Date
Mid-term	33.33	F-J	Week 7
Final Project	33.33	F-P	Week 16
Homeworks	33.33	Various	Varies

Academic Dishonesty:
Events of academic dishonesty will receive an automatic zero and will result in removal from the course.

Lack of Prerequisites:
A student who attempts this course without having the required assessment levels or passing prerequisite(s), does so at his/her own risk of failing the course.

Project/Homework Instructions:
All projects and homework assignments must be submitted to me at the beginning of the class on the due date. Any projects or assignments not submitted at such time will receive 10% off for each week it is late, unless the student has made other arrangements with me prior to the due date. Assignments later than one week will receive no credit.

Final Project:

• Your final project will consist of you designing and building a database of your choice.
• Your grade will depend on how well your project fulfills the project criteria, which will be provided to you well in advance of the project due date.
• You may build a database for work, school, or your own personal use, or you may choose a project from my list of non-profit organizations that need database assistance.
• All database designs (E-R diagrams) must be approved through me before work begins.
• Non-profit projects may be subject to a separate grading criteria.
• You must present your final project during the designated time to receive credit.

Make-Ups:
I do not allow make-up exams. If you miss an exam, you will take a comprehensive final at the end of the semester and it will count for the missed exam. The only exception to this rule is when a student notifies me one week prior to the exam, provides a valid reason with extenuating circumstances, and agrees to take the exam earlier than the scheduled time.

Class Attendance:
The following statement is in the Student Handbook and will be enforced: "Students are expected to attend all class sessions. When a student's absences are about to equal or have equaled the number of class sessions per week, the instructor may issue a warning; if the student is absent again, the instructor may drop the student from the class."

It is important that you attend every class. You will be responsible for all work assigned whether you are present or absent.

In the event that you do miss a class, it is your responsibility to obtain the missed information from a fellow classmate. Therefore, I highly recommend that you find at least two study buddies in this class to confer with when class information is missed.

Please make every effort to be on time for class.

Computer labs are available for course related work.

Course Location	Lab Location	Overflow Lab	Office Location/Phone
HU building	H314	H312	H307/ 279-5187
CS building	CS25/26 & CS21A	H314	CS19 / 279-5156

Labs are open Monday through Friday 8:30 am - 10:00 pm, Saturday 8:30 am - 4:00 pm, and Sunday 8:30 am - 2:00 pm. Labs open on the first day of the semester and close on the last day of finals and all College holidays. Any changes in hours will be posted. Rules and guidelines governing the use of labs are published by the Computer Lab Offices.

Policies:
All students are expected to comply with the Student Code of Conduct. Students should refer to the Student Handbook for the official wording of all academic, classroom, and collegewide policies. All such polices will be strictly enforced in the classroom as stated in the Student Handbook.

For complete statement of Academic Regulations and Student Code of Conduct visit http://www.montgomerycollege.edu/departments/academicevp/Student_PandP.htm

Disabilities:
Any student who may need an accommodation due to a disability, please see me either after class or during my office hours. A letter from Disability Support Services (122CB) authorizing your accommodation will be needed. The DSS Website can be found at http://www.montgomerycollege.edu/Departments/dispsvc/.

Any student who may need assistance in the event of an emergency evacuation must identify themselves to the Disability Support Services Office. Guidelines for emergency evacuations for individuals with disabilities are found at: http://www.montgomerycollege.edu/Departments/dispsvc/evacprocedures.htm.

Weather Alerts:
Occasionally it becomes necessary to delay the opening of school, send students home early, or close the College entirely because of bad weather. Area radio stations broadcast information about school closings or delayed openings beginning around 6 a.m. If Montgomery College plans to close early, radio and TV stations will broadcast the message. The stations DO NOT broadcast "open as scheduled".

For recorded announcement call (301) 217-8800 or (301) 279-5310 or see the Montgomery College website is http://www.montgomerycollege.edu/

Class Cancellation:
In the event that class must be cancelled, see the class discussion board for information regarding alternate assignments.