Jan 15, 2021  
2016-2017 Catalog 
2016-2017 Catalog [PAST CATALOG]

CTP 215 - Access Visual Basic Applications (VBA) Programming

3 credit hours - Two hours of lecture and two hours of laboratory weekly; one term.
(formerly CSI 222 - Access Visual Basic Applications (VBA) Programming)

Design, develop, implement and maintain customized database applications in a microcomputer environment. Create menu interfaces using multiple tables, query the database, and generate customized reports. Develop event-driven program code using programming elements such as variables, conditions, loops, conversions, formatting, data structures, procedures, SQL, macros, object-oriented programming, ADO (ActiveX Data Objects) and error handling. Lab fee $25.

Prerequisite(s): CTP 115  and CTA 115  or permission of the CTP department chair.

Course Outcomes
Upon successful completion of this course, students will be able to:

  • Develop a Database Consisting of Tables, Queries, Forms, Reports, and Macros
    • Review the Development of Tables, Queries, Forms, Reports, and Macros
    • Create tables, queries, forms, reports, and macros
  • Program Using Variables, Constants, & Data Types
    • Demonstrate the Use of Projects, Properties, and Naming Conventions
  • Use Modules, Functions, Subroutines, Events, Objects, and Dialog Boxes
    • Write Events Using Event-Driven Programming
    • Enhance the User Interface
    • Create VBA Modules, Functions, and Subroutines
    • Write, Debug, and Maintain Applications
  • Write Structured Query Language (SQL) Scripting
    • Write SQL (Structured Query Language) Scripting
  • Create Code Using ActiveX Data Objects (ADO) and Object Oriented Programming
    • Write Code to Program with ADO (ActiveX Data Objects)
    • Demonstrate Using Basic Object-Oriented Programming: custom objects and collections
Core Competencies
Core 1 Communication Core 2 Technology Fluency Core 3 Information Literacy Core 5 Self Management Core 10 Innovative and Critical Thinking