Full star Half star Star PDF

Microsoft Access Training Courses

Instructor-led Microsoft Access training from Beginner to Expert, delivered by certified Microsoft Access trainers. Learn to build database applications to track, report and share information, from tables, queries, forms and reports to SQL commands and VBA coding. Online Live Australia wide, with in-house classroom training available for teams.
4.74 / 5 from 593 student reviews Microsoft Partner - Dynamic Web Training Training Australia since 2000
Access Courses & Class Dates

Pick your course, location and date

Choose your location, then a course level, to see upcoming classroom and Online Live dates. Every class includes unlimited free course repeats for 8 months and 12 months of email support. Not sure where to start? Ask us and we will place you at the right level.

Beginner · 2 Days

Access Essentials

4.82 400 Reviews

Learn to use the powerful features of Microsoft Access and gain the skills and knowledge to create database systems, including creating tables, queries, forms and reports and much more.

View Full Course Details
$990 incl GST per person
  • Duration2 Days
  • CPD Hours12 hours
  • Max class size10 students
  • Avg class size5 students
  • Course times 9.00am to 5.00pm approx. Classroom (local time) or Online Live (AEST/AEDT)

Book now, pay later: no payment is required when you book.

Upcoming dates

$990
January 2027
27-28
Jan
Wed-Thu · Access Essentials
Online Live · Instructor-led
March 2027
01-02
Mar
Mon-Tue · Access Essentials
Online Live · Instructor-led
April 2027
12-13
Apr
Mon-Tue · Access Essentials
Online Live · Instructor-led
May 2027
27-28
May
Thu-Fri · Access Essentials
Online Live · Instructor-led
July 2027
05-06
Jul
Mon-Tue · Access Essentials
Online Live · Instructor-led
August 2027
19-20
Aug
Thu-Fri · Access Essentials
Online Live · Instructor-led
No dates match your selected filter

Looking for Access Essentials dates?

There are currently no scheduled dates matching your selected filter, but we'd love to assist. Get in touch with our team to discuss your individual training needs or corporate group requirements, and we'll explore available options with you.

Advanced · 2 Days

Access Advanced

4.80 145 Reviews

Learn advanced Microsoft Access skills to design a secured multi-user database; including advanced SQL queries, creating relational databases, creating and using advanced macro techniques and much more.

View Full Course Details
$990 incl GST per person
  • Duration2 Days
  • CPD Hours12 hours
  • Max class size10 students
  • Avg class size5 students
  • Course times 9.00am to 5.00pm approx. Classroom (local time) or Online Live (AEST/AEDT)

Book now, pay later: no payment is required when you book.

Upcoming dates

$990
February 2027
01-02
Feb
Mon-Tue · Access Advanced
Online Live · Instructor-led
March 2027
15-16
Mar
Mon-Tue · Access Advanced
Online Live · Instructor-led
April 2027
27-28
Apr
Tue-Wed · Access Advanced
Online Live · Instructor-led
June 2027
10-11
Jun
Thu-Fri · Access Advanced
Online Live · Instructor-led
July 2027
19-20
Jul
Mon-Tue · Access Advanced
Online Live · Instructor-led
September 2027
02-03
Sep
Thu-Fri · Access Advanced
Online Live · Instructor-led
No dates match your selected filter

Looking for Access Advanced dates?

There are currently no scheduled dates matching your selected filter, but we'd love to assist. Get in touch with our team to discuss your individual training needs or corporate group requirements, and we'll explore available options with you.

Expert · 3 Days

Access - Visual Basic for Applications

4.82 48 Reviews

This course is designed for participants with sound knowledge of Microsoft Access and want to learn to develop programs in VisualBasic for Microsoft Access, Re-use code blocks, create efficient coding structures and learn standard and consistent VBA coding syntax.

View Full Course Details
$1485 incl GST per person
  • Duration3 Days
  • CPD Hours18 hours
  • Max class size10 students
  • Avg class size5 students
  • Course times 9.00am to 5.00pm approx. Classroom (local time) or Online Live (AEST/AEDT)
Scheduled On Demand

Interested in Access - Visual Basic for Applications?

No dates are currently published for this level, but we'd love to assist. Get in touch with our team to discuss your individual training needs or corporate group requirements, and we'll explore available options with you.

The best Microsoft Access training

Learn how to build sophisticated database applications to track, report and share information, and sort, filter and group data in a way that makes sense for your organisation. Advanced features range from data validation, system security and performance optimisation to SQL commands and Visual Basic coding to produce highly customised solutions.

Our Access courses are offered at Sydney, Melbourne, Brisbane, Adelaide, Perth, Canberra and In-house across Australia.

What Can Access Be Used For?

You can use Microsoft Access for virtually anything; to create a system for managing your music or stamp collection, the membership at your local soccer or polo club, the petty cash, inventory and stock control, or sales at work and much more. Any situation where you need to store data, manipulate it, and then present it as useful information is a perfect contender for Access.

With Microsoft Access; unless you use one of the pre-created system templates, you need to plan and design the system and the database objects (the tables, forms, reports, and queries) used in that system. And this is what takes time and learning to do.

Included with every class

Course inclusions

8 months

Unlimited free course repeats

Repeat your course free, as often as you like, for up to 8 months; a great way to build your Access skills over time.

12 months

Free email support

Email support for up to 12 months after the course to maximise your learning potential.

10 max

Small class sizes

A personalised learning experience for every student.

Instructor led

Hands-on Online Live or in-house classroom training by certified Microsoft Access trainers.

Course manual

Step-by-step course manual; an excellent reference guide well after class ends.

Computer provided

Classes run in fully set-up computer labs. No need to bring your own laptop.

Course certificate

Certificate of course completion to recognise your Microsoft Access skills and CPD hours.

Why learn Access?

You can use Microsoft Access for virtually anything: inventory and stock control, memberships, petty cash or sales. Any situation where you need to store data, manipulate it, and then present it as useful information is a perfect contender for Access.

Start Learning
Student Testimonials

What our Access students say

(5.0)
28 July, 2026
Access Essentials Online Live

Sean was great at explaining everything, it was very detailed and I felt like I learnt what I needed from this course.

Mark A
(4.6)
08 December, 2025
Access Advanced Online Live

Shaun was a very engaging instructor; he provided me with quite a few new tricks for managing databases and some references that I need to look up.

Jacob W
(5.0)
08 December, 2025
Access Advanced Online Live

Sean, provided great training, it was pitched for me at the right level to confirm & consolidate my Access understanding in particular Forms & Reports which I was struggling with

Maruzza, D
(5.0)
08 December, 2025
Access Advanced Online Live

I enjoyed the course, reinforced what I thought I already knew and explained topics that I was unsure about.

Alan F
(5.0)
10 November, 2025
Access Essentials Online Live

It’s a great course for beginners. Sean has been an excellent tutor — patient, professional, and very clear in his explanations.

Angie S
(5.0)
10 November, 2025
Access Essentials Online Live

The Access Essential course provide a well balance between concept and able to apply knowledge learnt. It provided opportunities of possibilities to contribute to our work.

Poppy B
(4.8)
10 July, 2025
Access Essentials Online Live

This course was great. I liked the approach of covering everything on the first day and then adding complexity on the 2nd day. The repetition of the 1st day content on day 2 is a good approach to help memory retention.

Simon W
(5.0)
10 July, 2025
Access Essentials Online Live

Alex is an excellent instructor. He answered all questions in detail and went through each topic in an easy-to-understand manner. Highly recommend.

Irena Z
(4.5)
10 July, 2025
Access Essentials Online Live

I attended the Access Essentials course and found it valuable. I learned something truly useful that I can apply in my work, and I'm really happy about the experience

Md A
(5.0)
10 July, 2025
Access Essentials Online Live

This is a resit for me, minimal information was repeated. I learnt new tasks in this course around action queries. This will help me work through my own databases, dates and calculations

Sherry
(5.0)
10 July, 2025
Access Essentials Online Live

Hi Alex, thank you for the past 2 days of Microsoft Access training. Excellent presentation and I thoroughly enjoyed it! I learned so much. Hope to see you again in the future! Cheers, Jaya.

Jaya G
(5.0)
16 April, 2025
Access Essentials Online Live

Your interactive approach and proactive attitude made the learning experience not only effective but also genuinely engaging. Thank you for your dedication and for going the extra mile to ensure everyone stays on track and motivated

Maria G
(5.0)
28 October, 2024
Access Essentials Online Live

Answered all my questions, even when they were outside the scoop of the course material. The language used was understood. Lot of tips and tricks given.

Sherry G
(5.0)
28 October, 2024
Access Essentials Online Live

Course was very engaging with alot of practical work. Covered pretty much what I wanted out of a beginner Access course.

Linh
(5.0)
08 August, 2023
Access Essentials Online Live

Course was extremely worthwhile, and I would highly recommend. A lot of very good information taught and will greatly assist in my day-to-day work.

Dan S
(5.0)
25 May, 2023
Access Essentials Online Live

Sean was very helpful & informative, they took the time explaining the ins and outs and assisted with all queries arising during the course.

Julia
(5.0)
25 May, 2023
Access Essentials Online Live

Sean kept the two days interesting and engaging and was always open to questions and issues. Thank you so much, it was exactly what I needed.

Juliea
(5.0)
25 May, 2023
Access Essentials Online Live

Really great starter course. Sean was a terrific teacher - very thorough and never rushed - allowed the pace to flow, but would slow up when requested - answered questions well and explained in detail - I enjoyed the star wars references and Dad jokes as well!

Cass H
(4.7)
30 January, 2023
Access Essentials Online Live

This was a really useful course to improve and solidify my Access knowledge. I already had basic Access experience through picking up management of a database developed by someone else, but I only knew what to do based on the previous person's instructions. The knowledge wasn't all new to me, but it helped me understand the what and why behind what I had been doing. I also learnt a lot of new tools, which helps me to understand my current database more and gave me ideas on how to improve it. Alex is great and very knowledgeable!

Caitlin
(4.9)
30 January, 2023
Access Essentials Online Live

Course was great, Alex did a fantastic job. My only minor comment would be include a couple quick of pauses here and there to check we are all keeping up.

Tom S
Read all course reviews
Common Questions

Frequently asked questions

Are your Access courses suitable for beginners?

Yes. Access Essentials assumes no prior knowledge of Microsoft Access; a general understanding of personal computers and the Windows operating system is all that is required. It builds a strong foundation before you move to Access Advanced and Access VBA.

Which Access course should I start with?

Most people start with Access Essentials, then progress to Access Advanced and finally Access - Visual Basic for Applications, in that order. If you already create databases, tables, queries, forms and reports confidently, you can join Access Advanced directly.

How much does Access training cost in Australia?

Access Essentials and Access Advanced are $990 each incl GST (2 days each). Access - Visual Basic for Applications is $1,485 incl GST (3 days). Every course includes unlimited free course repeats for 8 months, 12 months of email support, a course manual and a certificate of completion.

What are the prerequisites for Microsoft Access courses?

Access Essentials assumes no prior knowledge of Microsoft Access, however a general understanding of personal computers and the Windows operating system is required. For Access Advanced, participants should have completed the Access Essentials course or have equivalent practical knowledge, including creating databases, tables, queries, forms and reports. Access VBA is designed for participants with little or no knowledge of programming, however a sound working knowledge of Microsoft Access is essential.

How long do the Access courses last?

Access Essentials and Access Advanced each run for 2 days, and Access - Visual Basic for Applications runs for 3 days. All classes run 9.00am to 5.00pm approximately, delivered Online Live (AEST or AEDT).

What will I learn in Access Essentials?

You will learn to design and create a basic database, apply validation, logic and relationships, work with transactional records, write queries and generate reports and forms. A hands-on approach is taken throughout the course, with emphasis on good design practices and database design theory.

Do I get a certificate after completing an Access course?

Yes, you will receive a certificate of course completion after completing each Access course, recognising your Microsoft Access skills.

Do the Access courses count towards CPD?

Yes. Access Essentials and Access Advanced each carry 12 CPD hours, and Access - Visual Basic for Applications carries 18 CPD hours.

Can I attend the Access Online Live course from anywhere in Australia?

Yes. Online Live classes are delivered live by our trainers via videoconference, Australia wide, running 9.00am to 5.00pm AEST or AEDT. You can participate in class discussions, ask questions, and share your screen with the trainer when one-on-one help is required.

What setup do I need for live Access online training?

You will need a Windows PC or laptop with a second screen or monitor, a broadband internet connection, the Microsoft Teams app installed, and a headphone or earbuds with a microphone. Microsoft Access must be installed prior to training; set-up instructions are sent one week before your course commencement date, and the course invite email with joining links and training files is sent two business days before the course.

How can I book my free repeat Access class?

Dynamic Web Training offers free and unlimited repeat classes for up to 8 months from your original course dates. To book a repeat Access class, call us at 1300 888 724 two business days before your preferred course date. Bookings are subject to course confirmation and seat availability; please quote your invoice number when booking.

When does the Access VBA course run?

Access - Visual Basic for Applications classes are scheduled on demand. Enquire to join the waitlist and we will notify you when a new class is scheduled, or contact us to discuss your training needs, including in-house workplace training for teams.

Contact Us

Enquire now

Fill in your details to have a training consultant contact you to discuss your training needs. We offer public, on-site and workplace IT and software training services across Australia. Complete the form or call us during business hours (8.30am to 5pm AEST/AEDT) and our friendly customer service team will respond within 1 business day.

Contact us

Level 11, 32 Walker Street, North Sydney NSW 2060
8.30am to 5pm AEST/AEDT, Monday to Friday

1300 888 724 info@dynamicwebtraining.com.au ·Enquire online

Fields marked with * are required. We respond within 1 business day.

Our Training Locations

Train in-class or Online Live, Australia wide

Classroom + Online Live

Sydney

Level 11, 32 Walker Street, North Sydney NSW 2060

Classroom + Online Live

Melbourne

Level 12, 379 Collins Street, Melbourne VIC 3000

Online Live

Brisbane

All courses facilitated in Online Live format or In-house workplace training, QLD

Online Live

Canberra

All courses facilitated in Online Live format or In-house workplace training, ACT

Online Live

Adelaide

All courses facilitated in Online Live format or In-house workplace training, SA

Online Live

Perth

All courses facilitated in Online Live format or In-house workplace training, WA