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
- Information storage
- Data types
- Variables
- Variable terminology, attributes, scope, and visibility
- Control structures if, select case, do, for
- Loops
- Standard functions
- Error categories, identification, and resolution
- Code comments
Object
- Definition
- Properties
- Methods
- Object collections
- Browsing objects
- Tables, queries, and indexes
- Object-oriented data access
- Custom Classes
- Object error handling
Databases
- Building queries using VBA
- Applying SQL syntax
- Database transactions
- DAO and ADO
- Record management
- Data import from external systems
Applications
- Planning
- User interface design
- Menus
- Reporting
- Controls accessible via code
- Forms
- Integration and support for external applications
- Library functions
Best Practices
- Professional tips and techniques
Requirements
- Proficiency in at least one procedural programming language (such as Basic, Pascal, or C) is essential.
- For those aiming to acquire foundational skills, we suggest taking the course: Introduction to Programming with Visual Basic for Applications (VBA) in Excel.
- A high level of proficiency in Microsoft Access is required. It is advisable to have completed the course: Advanced Access.
Testimonials (1)
Training Room and quite location and all the stuff.
