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
- Data types
- Variable usage
- Variable terminology, attributes, scope, and visibility
- Control structures including if, select case, do, for
- Looping mechanisms
- Intrinsic functions
- Identifying and resolving errors
- Code documentation via comments
Object
- Object definitions
- Properties
- Methods
- Object collections
- Viewing objects
- Tables, queries, and indexes
- Object-oriented data access
- Custom Classes
- Object-level error handling
Databases
- Building queries using VBA
- Applying SQL syntax
- Transaction management
- DAO and ADO interfaces
- Record handling
- Data importation from external systems
Applications
- Planning
- User interface design
- Menu structures
- Reporting
- Programmatic control access
- Form development
- Integration and support for other applications
- Library functions
Best Practices
- Pro tips and techniques
Requirements
- Familiarity with any procedural programming language (such as Basic, Pascal, or C) is necessary.
- For those looking to acquire the foundational skills, we suggest starting with the course: Visual Basic for Applications (VBA) in Excel - introduction to programming.
- A strong command of Microsoft Access is expected. We advise completing the course: Access for advanced.
21 Hours
Testimonials (1)
Training Room and quite location and all the stuff.
