Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to VBA
- Introducing the VBA environment
- VB Editor
- Using Project Explorer
- Toolbox
- Modules
- Procedures and Functions
- Comments
Principles and concepts of programming
- Data types, variables and constants
- Program flow control
- If…Then… Else
- Do…Loop, While and Until
- For…Next statements
- Input / Output, Message boxes, Input boxes
- Code behind forms, Form controls manipulation
- Passing arguments, Returning Values
Debugging
- Run Time, Design Time, and Break Mode
- Breaks and Watches
- Local Window
- Immediate Window
Access - Object-Oriented Programming
- Access object model
- Objects, Collections
- Events
- Methods and properties
- Data Access Object Library
Access User Interface Design
- Programming event procedures
- Dynamic combo boxes
- User inputs
- Interface design considerations
- Menus
Access SQL & Database Design
- Filtering – various Where clause options
- Deriving data - calculated fields
- Inner table joins
- Outer table joins
- Sub-queries – filtering, virtual tables and columns,
- Creating – adding rows directly or via queries
- Updating and Deleting - directly and via sub-queries
- Creating and Dropping tables
- Creating relationships
- Use of primary and foreign keys
Excel - Object-Oriented Programming
- Excel object model
- Objects, Collections
- Events
- Methods and properties
Excel – Programming Analysis Routines
- Sorting, filtering and distributing data between worksheets and workbooks
- Using VBA to control charts
- Using VBA to control pivot tables
- Using VBA to control What If scenarios
- Importing from external files, internet et cetera
Error Handling
- Stepping through code
- Finding syntax errors
- Using Debug.Print
- Building error-trapping routines
Requirements
Delegates should be comfortable using Excel formula, sorting filtering, charts, pivot tables et cetera. With Access, they should be able to maintain tables, queries, forms and reports.
21 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from £5700 online delivery, based on a group of 2 delegates, £1800 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (3)
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.
