Course Outline
Introduction to VBA
- Overview of the VBA environment
- VB Editor
- Utilizing the Project Explorer
- Toolbox
- Modules
- Procedures and Functions
- Code comments
Programming Principles and Concepts
- Data types, variables, and constants
- Controlling program flow
- If…Then… Else logic
- Do…Loop, While, and Until structures
- For…Next loops
- Input/Output, message boxes, and input boxes
- Form-based code and control manipulation
- Argument passing and value return
Debugging
- Run Time, Design Time, and Break modes
- Setting breaks and watches
- Local Window
- Immediate Window
Access - Object-Oriented Programming
- Access object model
- Objects and Collections
- Events
- Methods and properties
- Data Access Object Library
Access User Interface Design
- Writing event procedures
- Implementing dynamic combo boxes
- Capturing user inputs
- Best practices for interface design
- Menu creation
Access SQL & Database Design
- Filtering techniques and various Where clause options
- Derived data via calculated fields
- Inner table joins
- Outer table joins
- Sub-queries for filtering and virtual tables/columns
- Data creation through direct entry or queries
- Updating and deleting records directly or via sub-queries
- Table creation and deletion
- Establishing relationships
- Application of primary and foreign keys
Excel - Object-Oriented Programming
- Excel object model
- Objects and Collections
- Events
- Methods and properties
Excel – Programming Analysis Routines
- Data sorting, filtering, and distribution across worksheets and workbooks
- Chart automation using VBA
- Pivot table control via VBA
- Managing What If scenarios with VBA
- Data import from external sources and the internet
Error Handling
- Stepping through code execution
- Identifying syntax errors
- Leveraging Debug.Print
- Developing error-trapping routines
Requirements
Participants should have a solid grasp of core Excel features, including formulas, sorting, filtering, charts, and pivot tables. Additionally, they should be proficient in managing tables, queries, forms, and reports within 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.
