CA240 Advanced Database Applications

Sample Syllabus (Word document)

Course Description

Prerequisites/Corequisites

Goals and/or Objectives

Upon successful completion of this course, the student should be able to

• Development and enhancement of non-technical skills
  • Speak and write about the course topics with sufficient proficiency
  • Apply critical thinking to a variety of topics in the course
• Queries
  • Create parameter and summary queries
  • Create a lookup field
  • Create crosstab, find duplicates, find unmatched, and top value queries
  • Create append, delete, make-table and update queries
  • Use table joins in a query
  • Use special wizards
• Forms
  • Create main and subforms
  • Create multipage forms
  • Use hyperlinks
  • Use list and combo boxes in forms
• Reports
  • Embed charts in a report
  • Link reports to Word or export to Excel
  • Create and use subreports Use SQL
• Macros
  • Create and run macros
  • Use conditions in macros
  • Write an autoexec macro
  • Create and use switchboards
• Customization
  • Use VBA to customize a database by creating functions, event procedures, etc.
  • Create custom toolbars and attach them to forms

Please note that the information provided here is only a guideline and may occasionally be out of date. Official current semester course description language can be found at:

• http://webdb.montgomerycollege.org/Internet/
  courses/SubjectSelect.cfm (current courses)
• http://www.montgomerycollege.edu/curricula/
  descriptions/cdcompapp.htm (current CA certificates and degree programs)
• http://www.montgomerycollege.edu/credit/ (current semester course schedule)