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
- Variable terminology, attributes, scope, and visibility
- Control structures: if, select case, do, for
- Loops
- Built-in functions
- Error types, detection, and resolution
- Comments
Object
- Object definition
- Properties
- Methods
- Object collections
- Object viewing
- Tables, queries, and indexes
- Object-oriented data access
- Custom Classes
- Object Error Handling
Databases
- Building queries using VBA
- Applying SQL syntax
- Transactions
- DAO and ADO
- Record management
- Data importation from external systems
Applications
- Planning
- Interface design
- Menus
- Reports
- Code-level control access
- Forms
- Integration and support for third-party applications
- Library functions
Best Practices
- Practical tips and techniques
Requirements
- Proficiency in at least one procedural programming language (e.g., Basic, Pascal, or C) is mandatory.
- For those seeking to build foundational programming skills, we suggest enrolling in the introductory course: Visual Basic for Applications (VBA) in Excel.
- A strong command of Microsoft Access is expected; completing the Advanced Access course is highly recommended.
21 Hours
Testimonials (1)
Training Room and quite location and all the stuff.
