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.
Duration 21 hours
Course Outline
Introduction to VBA
- Storing data
- Data types
- Variables
- Variable terminology, attributes, scope, and visibility
- Control structures if, select case, do, for
- Iteration loops
- Native functions
- Error identification and resolution
- Adding comments
Objects
- Object definitions
- Object properties
- Object methods
- Object collections
- Viewing objects
- Tables, queries, and indexes
- Object-oriented data retrieval
- Custom Classes
- Object error handling
Databases
- Building queries using VBA
- Applying SQL syntax
- Managing transactions
- DAO and ADO interfaces
- Record management
- Data import from external systems
Applications
- Planning strategies
- User interface design
- Menu structures
- Reporting features
- Controlling elements via code
- Form development
- Integration with and support for other applications
- Library functions
Best Practices
- Pro tips and shortcuts
Requirements
- Familiarity with at least one procedural programming language is essential (such as Basic, Pascal, or C).
- For those seeking to build foundational skills, we suggest starting with: Visual Basic for Applications (VBA) in Excel - Introduction to Programming.
- A strong command of Microsoft Access is required. We recommend completing: Advanced Access beforehand.
Testimonials (1)
Training Room and quite location and all the stuff.
