CA141 Introduction to Database Applications

Sample Syllabus (Word document)

Course Description

A practical introduction to the creation, design, and use of databases for practical business applications. The course focuses on the functions of database applications and the design, maintenance, and manipulation of a database, including the design of simple queries, forms and reports. 3 semester hours.

Prerequisites/Corequisites

CA106 Microcomputer Operating Systems, or consent of department.
Assessment levels:EN101/101A, MA100, RD110

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
• Databases
  • Explain what a database is and what it can help you do
• Tables
  • Use currently existing tables
  • Create new tables with the help of a wizard
  • Create new tables without using the wizard
  • Modify contents of a table-add records, delete records, modify records, use input masks and validation rules, import records
  • Work with multiple tables
  • Define table relationships
• Queries
  • Create select queries using one or more tables
  • Run queries
  • Sort and filter data in query
  • Create calculated fields in query
  • Use OR, AND, NOT as well as pattern matching in query
• Forms
  • Create a form with the help of a wizard
  • Create a form without the use of a wizard
  • Use a form to work with table data
  • Modify forms and controls
• Reports
  • Create a report without the help of a wizard
  • Create a report using a wizard
  • Modify reports and controls
  • Use grouping in a report
  • Add images to a report
• Web
  • Use the WWW with DBMS
  • Use hyperlink fields
    

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)