click here for sitemap
Computer Applications Department Logo (Click for Home Page)CA home page Montgomery College, MarylandMontgomery College home pageC.A. site mapFAQ's - frequently asked questionssearch ""
Computer Applications Department...skills for your future
courses
. CA credit courses:
  o Web & Gaming
  o Microsoft Office

Online courses
Testing out
Current schedule
Non-credit courses

degrees
certificates
faculty & staff
internships
tutoring
computer labs
MOS certification
student gallery
resources
contact us


"All labor that uplifts humanity has dignity and importance and should be undertaken with painstaking excellence."

Martin Luther King, Jr.


List of CA Dept Courses
Computer Applications (CA) Courses:
(click to view sample syllabi)
Keyboarding99   Internship: 269
Microsoft Office: 106 | 120 | 141232 | 240242 | 252
Web & Gaming125 | 190 | 195 | 225 |  272 | 273 | 274 | 276 | 277 | 278 | 282288 | 299

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:

X
X
back to top

sitemap | search | contact us | FAQs
courses | certificates | degrees | faculty & staff
MOS certification | computer labs | tutoring | internships
student survey | student gallery | student resources | faculty resources
MC home page | CA home page
disclaimer


Email Prof. Solomon with suggestions for our site


Montgomery College..."Endless Possibilities" 240.567.5000