VBA for Access and Excel Training in Auckland

VBA for Access and Excel Training in Auckland, New Zealand

This course introduces participants to Visual Basic for Applications (VBA) programming in Excel and Access.

Enroll Now

VBA for Access and Excel Training is a professional training program delivered by ProgNXT in Auckland, New Zealand. ProgNXT, a globally recognized corporate training provider in 55+ countries, offers this VBA for Access and Excel Training course with hands-on, instructor-led sessions. This course introduces participants to Visual Basic for Applications (VBA) programming in Excel and Access. It covers automation of repetitive tasks,...

Expert Panel

Designed and delivered by the ProgNXT Database Management Expert Panel — a vetted team of industry professionals with 15+ years of hands-on experience in MySQL, PostgreSQL, Oracle, and database optimization

ProgNXT Database Management Expert Panel

Course Code: GXH86
21 Hrs
Last Updated: April 2026

Course Rating5/5

This course introduces participants to Visual Basic for Applications (VBA) programming in Excel and Access. It covers automation of repetitive tasks, creating custom functions, handling events, working with databases, and building user-friendly solutions. By the end, participants will be able to design macros, interact with data programmatically, and build small-scale business applications.

Welcome to the official VBA for Access and Excel Training certification program in Auckland, New Zealand. This comprehensive training is designed to elevate your professional skills and provide you with practical, industry-relevant knowledge locally. As a globally recognized corporate training provider operating in 55+ countries, ProgNXT ensures that our curriculum meets the highest standards of excellence.

Whether you are looking to upskill your team or advance your personal career, our expert-led sessions will guide you through the core concepts of this domain. Upon successful completion of the 21 Hrs program, participants will receive a globally accepted certification, demonstrating their proficiency and readiness to tackle complex challenges in the field.

Basic knowledge of Excel (formulas, charts, pivot tables)
Basic familiarity with Microsoft Access (tables, queries, forms, reports)
No prior programming experience required, but logical thinking skills are recommended

By the end of the course, participants will be able to:

Automate repetitive tasks in Excel and Access using VBA
Write custom functions and procedures
Interact with worksheets, workbooks, tables, and queries via VBA
Build and manage user forms for data entry and navigation
Implement error handling and debugging techniques
Create integrated Excel–Access solutions for reporting and analysis

VBA programming fundamentals
Automation and macros in Excel and Access
Database interaction through VBA
Userform and GUI development
Data validation and error handling
Creating reusable and scalable VBA modules

Conceptual Knowledge
Practical Application

Participants who attend all sessions and successfully complete the course assessments will receive a ProgNXT Certificate of Completion.

Introduction to VBA

What is VBA? Why use it in Excel & Access?
Recording, editing, and running macros
VBA editor (VBE) overview: windows, toolbars, and settings
Procedures: Sub vs. Function

VBA Programming Basics

Variables, constants, and data types
Operators and expressions
Control structures (If, Select Case, For, Do loops)
Built-in functions and MsgBox/InputBox

Working with Excel Objects

Object hierarchy in Excel (Application, Workbook, Worksheet, Range)
Writing macros to manipulate cells, ranges, and formatting
Automating formulas and charts
Creating custom Excel functions (UDFs)

Working with Access Objects

Access VBA environment overview
Automating Tables, Queries, Forms, and Reports
Writing code for data validation and navigation
Automating queries and reports generation

Event-Driven Programming

Workbook, Worksheet, and Range events in Excel
Form and control events in Access
Automating tasks with event procedures

User Forms and Controls

Designing forms in Excel and Access
Adding and configuring controls (TextBox, ComboBox, ListBox, Buttons)
Capturing and validating user input
Navigating between forms

Working with External Data

Importing and exporting data between Access and Excel
Using ADO/DAO to connect to databases
Automating Access queries and exporting results to Excel
Consolidating data from multiple workbooks/databases

Error Handling and Debugging

Common runtime errors and troubleshooting
Debugging tools in VBE (Immediate Window, Watches, Breakpoints)
Structured error handling using On Error statements
Best practices for writing robust code

Advanced VBA Techniques

Modular programming and reusable code
Creating and distributing Add-ins (Excel)
Automating emails via Outlook from Access/Excel
Securing VBA code (password protection, best practices)

Hands-on Exercises

Summary and Conclusion

Slide deck
Sample Excel & Access databases for exercises
VBA code snippets and templates
Access to sample datasets

Quizzes
Hands-On Exercises
Participation

ProgNXT Certificate of Completion will be awarded to participants who successfully complete the course and assessments.

VBA for Access and Excel Training Events in auckland

Online Events

Global Region	Location	Start Date	End Date	Action
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌

More Upcoming Session Dates

October 2026

🌐 Online Instructor-Led

18th Oct 2026→20th Oct 2026

📍 Auckland, New Zealand

19th Oct 2026→21st Oct 2026

November 2026

📍 Auckland, New Zealand

2nd Nov 2026→4th Nov 2026

🌐 Online Instructor-Led

4th Nov 2026→6th Nov 2026

🌐 Online Instructor-Led

19th Nov 2026→21st Nov 2026

📍 Auckland, New Zealand

20th Nov 2026→22nd Nov 2026

December 2026

🌐 Online Instructor-Led

9th Dec 2026→11th Dec 2026

📍 Auckland, New Zealand

11th Dec 2026→13th Dec 2026

🌐 Online Instructor-Led

20th Dec 2026→22nd Dec 2026

📍 Auckland, New Zealand

25th Dec 2026→27th Dec 2026

Events for other courses in Auckland, New Zealand

Global Region	Course Name	Start Date	End Date	Action
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌

VBA for Access and Excel Training in Auckland