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
- Information storage
- Data types
- Variables
- Terminology, characteristics, scope, and visibility of variables
- Control structures if, select case, do, for
- Loops
- Built-in functions
- Type checking, error detection, and removal
- Comments
Objects
- Definition
- Properties
- Methods
- Object collections
- Viewing
- Tables, queries, and indexes
- Object-oriented data access
- Custom Classes
- Error handling for objects
Databases
- Building queries with VBA
- Using SQL syntax
- Transactions
- DAO and ADO
- Records
- Importing data from external systems
Applications
- Planning
- User interface design
- Menus
- Reports
- Code-accessible controls
- Forms
- Integration and support for other applications
- Library functions
Best Practices
- Tips and tricks
Requirements
- Prior knowledge of a procedural programming language is required (e.g., Basic, Pascal, C).
- For those seeking to build the necessary foundational skills, we recommend the course: Visual Basic for Applications (VBA) in Excel - Introduction to Programming.
- Advanced proficiency in Microsoft Access is essential. Completion of the course: Access for advanced is recommended.
21 Hours
Testimonials (1)
Training Room and quite location and all the stuff.
