Course Outline
Foundations of VBA
- Overview of the VBA environment
- Introduction to the VB Editor
- Navigating the Project Explorer
- Utilizing the Toolbox
- Managing Modules
- Defining Procedures and Functions
- Adding Comments
Programming Core Concepts
- Handling Data Types, Variables, and Constants
- Controlling Program Flow
- Implementing If…Then… Else logic
- Using Do…Loop, While, and Until constructs
- Applying For…Next loops
- Managing Input/Output, Message Boxes, and Input Boxes
- Writing Code behind Forms and Manipulating Controls
- Passing Arguments and Returning Values
Debugging Techniques
- Understanding Run Time, Design Time, and Break Modes
- Setting Breakpoints and Using Watches
- Utilizing the Local Window
- Working with the Immediate Window
Access: Object-Oriented Programming
- Exploring the Access Object Model
- Working with Objects and Collections
- Handling Events
- Applying Methods and Properties
- Using the Data Access Object Library
Designing Access User Interfaces
- Coding Event Procedures
- Creating Dynamic Combo Boxes
- Managing User Input
- Considering Interface Design Best Practices
- Building Menus
Access SQL & Database Design
- Applying Filtering with Various Where Clause Options
- Deriving Data via Calculated Fields
- Performing Inner Table Joins
- Performing Outer Table Joins
- Writing Sub-queries for Filtering, Virtual Tables, and Columns
- Creating and Adding Rows Directly or via Queries
- Updating and Deleting Data Directly or via Sub-queries
- Creating and Dropping Tables
- Establishing Relationships
- Implementing Primary and Foreign Keys
Excel: Object-Oriented Programming
- Exploring the Excel Object Model
- Working with Objects and Collections
- Handling Events
- Applying Methods and Properties
Excel – Developing Analysis Routines
- Sorting, Filtering, and Distributing Data Across Worksheets and Workbooks
- Controlling Charts with VBA
- Controlling Pivot Tables with VBA
- Managing What If Scenarios with VBA
- Importing Data from External Files, the Internet, etc.
Error Handling
- Stepping Through Code
- Identifying Syntax Errors
- Using Debug.Print
- Constructing Error-Handling Routines
Requirements
Participants are expected to be proficient with standard Excel features, including formulas, sorting, filtering, charts, and pivot tables. In Access, they should demonstrate the ability to manage tables, run queries, and maintain 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.
