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 techniques
- Understanding data types
- Working with variables
- Variable terminology, attributes, scope, and visibility
- Control flow structures: if, select case, do, for
- Implementing loops
- Utilizing built-in functions
- Identifying and resolving errors and their types
- Writing effective comments
Object
- Object definitions
- Exploring properties
- Applying methods
- Managing object collections
- Viewing object structures
- Handling tables, queries, and indexes
- Object-oriented data access patterns
- Creating custom classes
- Managing object-related errors
Databases
- Building queries using VBA
- Applying SQL syntax
- Managing transactions
- Working with DAO and ADO
- Record management
- Importing data from external systems
Applications
- Application planning
- Interface design
- Creating menus
- Generating reports
- Manipulating controls via code
- Developing forms
- Integrating with and supporting external applications
- Using library functions
Best Practices
- Professional tips and techniques
Requirements
- Familiarity with at least one procedural programming language (such as Basic, Pascal, or C) is essential.
- For those seeking to build foundational skills, we suggest starting with the course: Visual Basic for Applications (VBA) in Excel - Introduction to Programming.
- Strong command of Microsoft Access is required. Completion of the course: Access for Advanced Users is highly recommended.
21 Hours
Testimonials (1)
Training Room and quite location and all the stuff.
