Course Outline
Introduction to VBA
- Overview of the VBA environment
- The VB Editor
- Navigating the Project Explorer
- The Toolbox
- Understanding Modules
- Defining Procedures and Functions
- Adding Comments
Core Programming Principles
- Data types, variables, and constants
- Controlling program flow
- Conditional logic: If…Then… Else
- Loops: Do…Loop, While, and Until
- Iterative loops: For…Next
- Input and Output methods, message boxes, and input boxes
- Form-based coding and control manipulation
- Passing arguments and handling return values
Debugging Techniques
- Understanding Run Time, Design Time, and Break Mode
- Setting Breaks and Watches
- Utilizing the Local Window
- Using the Immediate Window
Access: Object-Oriented Programming
- The Access object model
- Working with Objects and Collections
- Handling Events
- Methods and properties
- The Data Access Object Library
Access: User Interface Design
- Writing event-driven code
- Creating dynamic combo boxes
- Capturing user inputs
- Designing effective user interfaces
- Customizing menus
Access: SQL & Database Design
- Data filtering using various Where clause options
- Deriving data through calculated fields
- Inner table joins
- Outer table joins
- Sub-queries for filtering and creating virtual tables and columns
- Inserting data directly or through queries
- Updating and deleting records directly or via sub-queries
- Table creation and deletion
- Establishing relationships
- Applying primary and foreign keys
Excel: Object-Oriented Programming
- The Excel object model
- Working with Objects and Collections
- Handling Events
- Methods and properties
Excel: Programming Analysis Routines
- Sorting, filtering, and managing data across sheets and workbooks
- Controlling charts with VBA
- Managing pivot tables using VBA
- Running What If scenarios via VBA
- Importing data from external sources and the internet
Error Handling
- Step-by-step code execution
- Identifying syntax errors
- Utilizing Debug.Print
- Creating robust error-trapping routines
Requirements
Participants are expected to have a working knowledge of essential Excel features such as formulas, sorting and filtering, charts, and pivot tables. For Access, you should be familiar with managing tables, queries, forms, and reports.
Testimonials (4)
Well structured. Good teaching techniques. Course well documented!
Sorin
Course - VBA For Access & Excel
Tamil was exceptionally patient and very helpful in figuring out solutions to real needs. He was also very honest about if he didn't know something from the top of his head, which enabled us to quickly jump on in the training and we didn't lose time.
Christine Weiler
Course - VBA For Access & Excel
The explanation way and including tips on the best practices in VBA/Access, encouraging via exercise to think more by ourselves on how to solve the problem rather than giving ready solutions.
Daria Rudin
Course - VBA For Access & Excel
I liked the examples and the way he explained.
