Level 1
Access Essentials
Tables, relationships and simple queries — why a database is not a spreadsheet.
$946ex GSTLearn more
Level 2
Microsoft
2 days
Microsoft Access Advanced Course
Microsoft Access Advanced at a glance.
- Duration
- 2 days, 9:00am – 4:00pm
- Price
- $946 per person, ex GST — purchase orders welcome
- Delivery
- In person, or live online with a facilitator
- Where
- Adelaide, Brisbane, Canberra, Melbourne, Perth and Sydney — or online
- Prerequisite
- Access Essentials
- Class size
- Small — everyone practises out loud more than once
- You take away
- A printed workbook, exercise files, and your own notes
- In-house
- Available for teams of four or more, at your office or ours
What you'll learn.
- Action queries — append, update and delete
- Macros and simple automation
- Splitting the front end from the back end
- Multi-user access and safe deployment
Course overview.
Action queries, macros, split front end and back end, and sharing a database safely.
The 2 days works through 9 modules and 31 individual topics, from Tables and relationships to Switchboard and start-up forms. Each module is taught then practised — you do the thing rather than watch it done — on our exercise files, and on your own where you are able to bring them.
Groups are kept small enough that everyone gets hands on the keyboard, and the facilitator is in the room the whole time rather than dropping in. You leave with the workbook, the exercise files and notes in your own words.
Full course outline.
Every module we cover, and the topics inside each one. This is the same outline as the downloadable PDF — expand a module to see what sits under it.
-
1Tables and relationships3 topics
- Field properties and data types in depth
- Handling complex relationships between tables
- Applying referential integrity and cascade options
-
2Applied queries3 topics
- Calculating inside a query
- Pulling data from several tables in one query
- Running the Find Unmatched Query Wizard
-
3Query techniques in depth5 topics
- Ranking results with Top Value queries
- Writing more complex calculations in queries
- Analysing data with directional join queries
- Driving parameter queries from a form
- Reading and writing SQL-specific queries
-
4Action queries3 topics
- The types of action query
- Building Update, Append and Delete queries
- Automating data housekeeping with action queries
-
5Report design in depth3 topics
- Putting custom expressions into a report
- Feeding a Mail Merge in Microsoft Word
- Laying out reports for complex data
-
6Macros4 topics
- Recording a macro, running it and assigning it
- Adding conditions with IF statements
- Using SubMacros for larger automations
- Controlling database start-up options with a macro
-
7Macros in practice3 topics
- Refreshing combo box contents on the fly
- Enabling, disabling, showing and hiding form controls
- Importing from Excel and updating tables by macro
-
8Database tools and tuning4 topics
- Compacting, repairing and backing up a database
- Examining a database with the Database Documenter
- Checking performance and where to tune it
- Moving data in and out of other applications
-
9Switchboard and start-up forms3 topics
- Building navigation menus in the Switchboard Manager
- Designing and adjusting Switchboard Forms
- Setting a start-up form so users land in the right place
Who it is for.
Confident users who now maintain something other people depend on — and want to stop it breaking.
How it runs.
Two consecutive days, each roughly 9am to 4pm, with a facilitator in the room the whole time. You get a workstation each with the software installed, in a CBD training room in any of the six capitals, or live online on your own computer.
Dates
Upcoming Dates
The next scheduled Microsoft Access Advanced dates, soonest first. If none of these work, tell us the city and we will let you know when the next block is released.
| Level | Date | Location | Delivery | Price | |
|---|---|---|---|---|---|
| No public dates are on the schedule right now. Ask us what is coming up and we will let you know as soon as the next block opens. | |||||
By city
Microsoft Access Advanced in your city
Venue, transport and the dates running there.
The rest of the category
All Microsoft Access levels Other Microsoft Access Levels
Reviews
What people said about Microsoft Access Advanced
Wizard courses run on the shared Nexacu schedule, so these are reviews of this course from people who sat it. Collected by Nexacu after the course and published as written.
Thanks Algis. This was a very relevant and practical two days. I really appreciated you showing us through VBA and explaining your thoughts about what it can do compared to macros. Pace of topics and their delivery was very good too.
Max
4 December 2025
Trainer was great.
Mark
5 December 2025
Source: nexacu.com.au, read 27 August 2026. How feedback is collected.
Questions
Questions People Ask About This Course
Anything not answered here, call 1300 886 190 and ask a person.
How long is the Microsoft Access Advanced course?
It runs for 2 days, 9:00am – 4:00pm, with a facilitator in the room the whole time. Nothing is pre-recorded and there is no platform to log into afterwards.
How much does Microsoft Access Advanced cost?
$946 per person, excluding GST. That covers the course, the workbook and exercise files and the room. If four or more people from one organisation need it, an in-house day usually works out cheaper — tell us the numbers and we will price both.
Do I need any experience before this course?
Yes — this level assumes Access Essentials, or equivalent experience picked up on the job. If you are not sure, tell us what you already do and we will place you honestly, including telling you to book the level below.
Can I do Microsoft Access Advanced online instead of in a classroom?
Yes. Every date marked “Live online” runs over video with the same facilitator and the same practice, in breakout groups rather than a room. You use the software on your own machine, so you leave with it set up the way you actually work.
Which cities do you run Microsoft Access Advanced in?
Adelaide, Brisbane, Canberra, Melbourne, Perth and Sydney, plus live online. Every venue is a CBD training room with a workstation for each person. If your city and date are not paired on the schedule above, ask — dates are released in blocks.
Which Access level should I book?
Work from what people already do rather than how long they have used it. The full course outline above shows exactly what this course covers, and the Microsoft Access page lists every level in order. Still unsure? Call 1300 886 190 and describe a normal Tuesday.
Whole team on the same level? Run it in-house.
Your files, your templates, your workflow — the same course, taught against your own material.