Montgomery College 2017-2018 Catalog 
    May 20, 2024  
Montgomery College 2017-2018 Catalog [ARCHIVED CATALOG]

Add to Favorites (opens a new window)

CMAP 245 - Advanced Database Applications

Intended for the intermediate database user, this course covers topics such as subforms, integration of databases with other applications, customization, and macros. It also introduces VBA. Together with CMAP 242  this will create a complete and thorough database series. PREREQUISITE(S): CMAP 242  or consent of department. Three hours each week. Formerly CA 240.

3 semester hours

Course Outcomes:
Upon course completion, a student will be able to:

  • Demonstrate advanced database design principles by designing a database with more than three related tables of different types; look-up, main and bridge tables
  • Utilize entity relationship diagramming to create and accurately describe the structure of a database
  • Identify and describe the three main types of relationships and the appropriateness of each; one-to-one, one-to-many and many-to-many
  • Explain the concept of referential integrity and its importance to database design and data accuracy
  • Explain the process of normalization and apply the process to correctly design a database
  • Create and use advanced queries such as parameter, action, summarizing (aggregating), find duplicate and find unmatched queries
  • Create simple one table queries using SQL. Students will correctly use SELECT, FROM, WHERE and ORDER BY clauses
  • Describe and use proper table joins in queries; inner, full outer, and left and right outer joins
  • Create a custom form without the use of a wizard that contains advanced form controls such as options groups and combo boxes
  • Create a form and corresponding subform with correct master/child relationship
  • Create a tabbed form
  • Create a custom report with advanced sorting and grouping options
  • Create calculated and summarized fields in a report
  • Create custom macros; conditional, macro groups and autoexec macros
  • Attach macros to object events and command buttons
  • Create a switchboard; custom and using the switchboard manager
  • Convert database to an ?application? by setting start-up options, creating a switchboard, and creating custom toolbars and menus

View Schedule of Classes

Add to Favorites (opens a new window)