Course Outline
Introduction to VBA
- Overview of the VBA development environment
- The VB Editor
- Navigating the Project Explorer
- Utilizing the Toolbox
- Working with Modules
- Defining Procedures and Functions
- Adding Comments to Code
Programming Principles and Concepts
- Data types, variables, and constants
- Controlling program flow
- If...Then...Else logic
- Loops: Do...Loop, While, and Until
- For...Next loops
- Input/Output, Message boxes, and Input boxes
- Form coding and manipulating form controls
- Passing arguments and returning values
Debugging Techniques
- Understanding Run Time, Design Time, and Break Mode
- Setting Breaks and Watchpoints
- Using the Local Window
- Utilizing the Immediate Window
Access: Object-Oriented Programming
- The Access object model
- Objects and Collections
- Event handling
- Methods and properties
- Data Access Object (DAO) Library
Access User Interface Design
- Writing event-driven procedures
- Implementing dynamic combo boxes
- Handling user inputs
- Best practices for interface design
- Customizing Menus
Access SQL and Database Design
- Filtering using various Where clause options
- Deriving data through calculated fields
- Inner table joins
- Outer table joins
- Sub-queries: filtering, virtual tables, and columns
- Inserting data: adding rows directly or via queries
- Updating and Deleting records: direct methods and sub-queries
- Creating and Dropping 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 distributing data across worksheets and workbooks
- Controlling charts with VBA
- Managing pivot tables using VBA
- Controlling What If scenarios
- Importing data from external sources and the internet
Error Handling
- Stepping through code execution
- Identifying syntax errors
- Using Debug.Print for diagnostics
- Constructing error-trapping routines
Requirements
Participants are expected to be proficient with core Excel functions, including formulas, sorting, filtering, charts, and pivot tables. Additionally, they should possess the ability to manage tables, queries, forms, and reports within Microsoft Access.
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.
