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 (3 days)
Course Outline
Introduction to VBA
- Storing information
- Data types
- Variables
- Variable terminology, characteristics, scope, and visibility
- Control structures using if, select case, do, for
- Loops
- Built-in functions
- Identifying and resolving errors
- Adding comments
Objects
- Definition
- Properties
- Methods
- Object collections
- Viewing objects
- Tables, queries, and indexes
- Object-oriented data access
- Custom classes
- Object error handling
Databases
- Constructing queries with VBA
- Using SQL syntax
- Transactions
- DAO and ADO
- Records
- Importing data from external systems
Applications
- Application planning
- User interfaces
- Menus
- Reports
- Controlling elements via code
- Forms
- Integration with and support for other applications
- Library functions
Best Practices
- Useful tips and techniques
Requirements
- Proficiency in a procedural programming language (e.g., Basic, Pascal, C) is required.
- For those looking to acquire foundational skills, we recommend taking the course: Visual Basic for Applications (VBA) in Excel - Introduction to Programming.
- Advanced knowledge of Microsoft Access is essential. We recommend completing the course: Access for Advanced.
Testimonials (1)
Training Room and quite location and all the stuff.
