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.
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 1 Communication Core 2 Technology Fluency Core 3 Information Literacy Core 5 Self Management Core 10 Innovative and Critical Thinking