Course Outline
Introduction to VBA
- Exploring the VBA workspace
- The VB Editor
- Navigating the Project Explorer
- Utilizing the Toolbox
- Working with Modules
- Defining Procedures and Functions
- Adding Code Comments
Core programming principles and concepts
- Data types, variables, and constants
- Controlling program flow
- If…Then… Else logic
- Do…Loop, While, and Until loops
- For…Next iteration statements
- Input/Output operations, Message boxes, and Input boxes
- Handling form logic and manipulating form controls
- Passing arguments and returning results
Debugging techniques
- Run Time, Design Time, and Break Modes
- Setting Breaks and Watches
- The Local Window
- The Immediate Window
Access - Object-Oriented Programming
- The Access object model
- Objects and Collections
- Event handling
- Methods and properties
- The Data Access Object Library
Access User Interface Design
- Writing event-driven procedures
- Implementing dynamic combo boxes
- Managing user inputs
- UI design best practices
- Custom Menus
Access SQL & Database Design
- Filtering data – various Where clause options
- Derived data - calculated fields
- Inner table joins
- Outer table joins
- Sub-queries – filtering, virtual tables and columns,
- Creating records – adding rows directly or via queries
- Updating and Deleting records - directly and via sub-queries
- Creating and Dropping tables
- Establishing relationships
- Using 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 between worksheets and workbooks
- Controlling charts with VBA
- Controlling pivot tables with VBA
- Controlling What If scenarios with VBA
- Importing from external files, the internet, and more
Error Handling
- Stepping through code
- Identifying syntax errors
- Using Debug.Print
- Creating error-trapping routines
Requirements
Participants should have a solid grasp of Excel features such as formulas, sorting and filtering, charts, and pivot tables. Additionally, when working with Access, they should be able to manage tables, queries, forms, and reports independently.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 4800 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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.
