Course Outline
VBA Fundamentals
- Overview of the VBA development environment
- The VB Editor interface
- Navigating the Project Explorer
- Utilizing the Toolbox
- Working with Modules
- Defining Procedures and Functions
- Adding Comments to code
Core Programming Principles
- Understanding Data types, variables, and constants
- Managing Program flow control
- Implementing If…Then… Else logic
- Using Do…Loop, While, and Until structures
- Applying For…Next loops
- Handling Input / Output, Message boxes, and Input boxes
- Writing code behind forms and manipulating Form controls
- Passing arguments and returning Values
Debugging Techniques
- Distinguishing Run Time, Design Time, and Break Mode
- Setting Breaks and Watches
- Inspecting the Local Window
- Utilizing the Immediate Window
Access: Object-Oriented Programming
- Exploring the Access object model
- Working with Objects and Collections
- Handling Events
- Accessing Methods and properties
- Using the Data Access Object Library
Access User Interface Design
- Writing Programming event procedures
- Implementing Dynamic combo boxes
- Capturing User inputs
- Considerations for Interface design
- Customizing Menus
Access SQL & Database Design
- Filtering data using various Where clause options
- Deriving data through calculated fields
- Performing Inner table joins
- Executing Outer table joins
- Using Sub-queries for filtering, virtual tables, and columns
- Creating records by adding rows directly or via queries
- Updating and Deleting records directly and via sub-queries
- Creating and Dropping tables
- Establishing relationships
- Applying primary and foreign keys
Excel: Object-Oriented Programming
- Understanding the Excel object model
- Managing Objects and Collections
- Triggering Events
- Modifying Methods and properties
Excel: Programming Analysis Routines
- Sorting, filtering, and distributing data across worksheets and workbooks
- Controlling charts with VBA
- Managing pivot tables using VBA
- Implementing What If scenarios with VBA
- Importing data from external files, the internet, and other sources
Error Handling
- Step-by-step code debugging
- Identifying syntax errors
- Leveraging Debug.Print
- Developing robust error-trapping routines
Requirements
Participants should possess a solid understanding of Excel functions, including sorting, filtering, chart creation, and pivot tables. For Access, trainees must be able to manage tables, execute queries, and maintain forms and reports effectively.
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.
