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
VBA Fundamentals
- Information storage
- Data types
- Variables
- Variable definitions, attributes, scope, and visibility
- Control structures using if, select case, do, for
- Loops
- Native functions
- Identifying and resolving errors
- Code comments
Objects
- Concept definitions
- Properties
- Methods
- Object collections
- Inspection techniques
- Tables, queries, and indexes
- Object-oriented data retrieval
- Custom Classes
- Handling object errors
Databases
- Building queries via VBA
- Applying SQL syntax
- Managing transactions
- Using DAO and ADO
- Record management
- Data importation from external systems
Applications
- Planning
- User interfaces
- Menus
- Reports
- Programming controls
- Forms
- Integration with and support for other apps
- Library functions
Best Practices
- Practical tips and techniques
Requirements
- Familiarity with any procedural programming language (such as Basic, Pascal, or C) is essential.
- For those wishing to acquire these foundational skills, we suggest taking the course: Visual Basic for Applications (VBA) in Excel – An Introduction to Programming.
- A solid understanding of Microsoft Access is required; completing the course: Access for Advanced is strongly advised.
21 Hours
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 3900 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (1)
Training Room and quite location and all the stuff.
