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
- Data storage mechanisms
- Data types
- Variables
- Variable terminology, characteristics, scope, and visibility
- Control structures (if, select case, do, for)
- Loops
- Built-in functions
- Identifying and resolving errors
- Comments
Objects
- Definition of objects
- Properties
- Methods
- Object collections
- Visualization techniques
- Tables, queries, and indexes
- Object-oriented data access
- Custom Classes
- Error handling for objects
Databases
- Creating queries with VBA
- Utilizing SQL syntax
- Transactions
- DAO and ADO
- Records
- Data import from external systems
Applications
- Planning
- User interface design
- Menus
- Reports
- Controls accessible via code
- Forms
- Integration and support for other applications
- Library functions
Best Practices
- Tips and tricks
Requirements
- Foundational knowledge of a procedural programming language is required (e.g., Basic, Pascal, C).
- For individuals seeking to acquire the necessary skills, we recommend the course: Visual Basic for Applications (VBA) in Excel - introduction to programming.
- A strong command of Microsoft Access is essential. We advise completing the 'Access for advanced' course beforehand.
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 4800 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (1)
Training Room and quite location and all the stuff.
