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 information
- Data types
- Variables
- Terminology, characteristics, scope, and visibility of variables
- Control structures if, select case, do, for
- Loops
- Built-in functions
- Types, identifying and resolving errors
- Comments
Object
- Definition
- Properties
- Methods
- Object collections
- Viewing
- Tables, queries, and indexes
- Object-oriented data access
- Custom Classes
- Object error handling
Databases
- Constructing queries using VBA
- Applying SQL syntax
- Transactions
- DAO and ADO
- Records
- Importing data from external systems
Applications
- Planning
- Interface design
- Menus
- Reports
- Controls accessible via code
- Forms
- Integration and support for other applications
- Library functions
Best Practices
- Tips and tricks
Requirements
- Familiarity with any procedural programming language is required (e.g., Basic, Pascal, C).
- For those seeking to acquire the necessary foundational skills, we suggest taking the course: Visual Basic for Applications (VBA) in Excel - Introduction to Programming.
- A strong command of Microsoft Access is essential. We recommend completing the course: Advanced Access first.
Testimonials (1)
Training Room and quite location and all the stuff.
