Course Outline
VBA Fundamentals
- Overview of the VBA workspace
- The VB Editor interface
- Navigating the Project Explorer
- Accessing the Toolbox
- Working with Modules
- Understanding Procedures and Functions
- Adding Comments to code
Programming Core Concepts
- Data types, variables, and constants
- Controlling program flow
- Implementing If…Then… Else logic
- Using Do…Loop, While, and Until structures
- Employing For…Next loops
- Handling Input / Output, message boxes, and input boxes
- Writing code behind forms and manipulating form controls
- Passing arguments and managing return values
Debugging Techniques
- Differentiating between Run Time, Design Time, and Break Mode
- Setting Breakpoints and Watches
- Utilizing the Local Window
- Interacting with the Immediate Window
Access: Object-Oriented Development
- Understanding the Access object model
- Managing Objects and Collections
- Responding to Events
- Utilizing Methods and Properties
- Working with the Data Access Object Library
Access Interface Development
- Programming event-driven procedures
- Configuring dynamic combo boxes
- Processing user inputs
- Design considerations for user interfaces
- Customizing Menus
Access SQL and Database Architecture
- Filtering data using various Where clause options
- Generating derived data through calculated fields
- Performing Inner table joins
- Executing Outer table joins
- Employing Sub-queries for filtering, virtual tables, and columns
- Creating records by adding rows directly or through queries
- Updating and deleting records directly or via sub-queries
- Establishing and removing tables
- Defining table relationships
- Applying primary and foreign keys
Excel: Object-Oriented Development
- Exploring the Excel object model
- Managing Objects and Collections
- Handling Events
- Applying Methods and Properties
Excel: Developing Analysis Routines
- Sorting, filtering, and transferring data across worksheets and workbooks
- Controlling charts with VBA
- Managing pivot tables using VBA
- Utilizing VBA for What If scenarios
- Importing data from external files, the internet, and other sources
Error Management
- Executing code step-by-step
- Identifying syntax issues
- Utilizing Debug.Print for testing
- Constructing robust error-trapping routines
Requirements
Participants should possess a solid grasp of Excel features such as formulas, sorting, filtering, charts, and pivot tables. Additionally, they should be proficient in maintaining tables, executing queries, and managing forms and reports within Access.
Testimonials (4)
Well structured. Good teaching techniques. Course well documented!
Sorin
Course - VBA For Access & Excel
Tamil was exceptionally patient and very helpful in figuring out solutions to real needs. He was also very honest about if he didn't know something from the top of his head, which enabled us to quickly jump on in the training and we didn't lose time.
Christine Weiler
Course - VBA For Access & Excel
The explanation way and including tips on the best practices in VBA/Access, encouraging via exercise to think more by ourselves on how to solve the problem rather than giving ready solutions.
Daria Rudin
Course - VBA For Access & Excel
I liked the examples and the way he explained.
