CMAP 245 - Database Applications

Covers the creation and design of databases, creation and manipulation of database objects to include tables, forms, queries, reports, macros, and modules for practical business applications. Topics also include integration of databases with other applications, customization, and also introduces VBA. PREREQUISITE(S): CMAP 120 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:

Apply objects and collections in the Access/VBA environment.
Apply programming actions initiated in response to Access events.
Employ macros in Access and determine circumstances where they are applicable.
Perform exercises exploring advanced topics regarding database creation.
Prepare a comprehensive database project reviewing prior knowledge.
Prepare program procedures including decision structures, looping structures, and error handling.
Utilize VBA to develop customized applications with Access including modules, functions and event procedures.

View Schedule of Classes