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
- Understanding data types
- Variable usage
- Variable terminology, attributes, scope, and visibility
- Control structures if, select case, do, for
- Looping constructs
- Utilising built-in functions
- Error identification, types, and resolution
- Writing and interpreting comments
Object
- Conceptual definition
- Exploring properties
- Invoking methods
- Working with object collections
- Inspection and viewing techniques
- Managing tables, queries, and indexes
- Object-oriented data access patterns
- Developing custom classes
- Implementing object error handling
Databases
- Building queries via VBA
- Applying SQL syntax
- Managing transactions
- Working with DAO and ADO
- Handling record sets
- Importing data from external systems
Applications
- Strategic planning
- Designing the user interface
- Creating menus
- Generating reports
- Manipulating controls via code
- Developing forms
- Integrating with and supporting other applications
- Utilising library functions
Best Practices
- Expert tips and techniques
Requirements
- Familiarity with any procedural programming language is a prerequisite (such as Basic, Pascal, or C).
- For those seeking to acquire foundational skills, the following course is advised: Visual Basic for Applications (VBA) in Excel - introduction to programming.
- A high level of proficiency in Microsoft Access is essential. It is suggested to complete the course: Advanced Access.
21 Hours
Testimonials (1)
Training Room and quite location and all the stuff.
