Course Outline
Getting Started with VBA
- Overview of the VBA environment
- The VB Editor interface
- Navigating the Project Explorer
- Utilizing the Toolbox
- Understanding Modules
- Defining Procedures and Functions
- Incorporating Comments
Core Programming Principles and Concepts
- Data types, variables, and constants
- Managing program flow
- If…Then… Else structures
- Do…Loop, While, and Until constructs
- For…Next loops
- Input/Output, message boxes, and input boxes
- Form code manipulation and controlling form elements
- Handling arguments and return values
Debugging Essentials
- Understanding Run Time, Design Time, and Break Modes
- Setting Breaks and using Watches
- The Local Window
- 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 procedures
- Implementing dynamic combo boxes
- Managing user inputs
- Best practices in interface design
- Creating Menus
Access SQL & Database Design
- Data filtering using various Where clause options
- Generating data through calculated fields
- Performing Inner table joins
- Executing Outer table joins
- Sub-queries for filtering, virtual tables, and columns
- Inserting data by adding rows directly or via queries
- Modifying and removing data directly or through sub-queries
- Creating and removing tables
- Establishing relationships
- Applying primary and foreign keys
Excel: Object-Oriented Programming
- The Excel object model
- Objects and Collections
- Event handling
- Methods and properties
Excel: Programming Analysis Routines
- Sorting, filtering, and moving data across worksheets and workbooks
- Controlling charts with VBA
- Manipulating pivot tables using VBA
- Managing What If scenarios via VBA
- Importing data from external files and the internet
Error Management
- Stepping through code execution
- Identifying syntax issues
- Utilizing Debug.Print
- Developing robust error-trapping routines
Requirements
Participants should have a solid grasp of Excel fundamentals, including formulas, sorting and filtering, charts, and pivot tables. Additionally, familiarity with maintaining Access tables, queries, forms, and reports is expected.
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.
