Course Overview
COMP 1175 has been replaced by COMP 2375. This course continues from MS Access Level 2, and covers the process of designing applications through the use of macros and VBA programming. Such features as building custom menus and toolbars will be discussed to enable students to build an effective database management system. Students will also learn about the fundamentals of VBA programming within Access. Specifically, students will understand how to create sub procedures, functions, modules, control structures and error handling procedures. Introduction to ADO objects and methods will also be discussed to enable students to manipulate data using recordsets.
- Not offered this term
- This course is not offered this term. Notify me to receive email notifications when the course opens for registration next term.
Learning Outcomes
Upon successful completion of this course, students will have a good understanding of:
- Implementing macros
- Designing and creating custom menus and toolbars
- Creating event procedures
- Using built in functions
- Using objects and properties
- Event driven programming and Access events
- VBA modules, functions, variables and constants
- Using the VBA debugging facility
- Working with collections and recordsets
Effective as of Winter 2005
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.