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:

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