Level 2
Access Advanced
Action queries, macros, split front end and back end, and sharing a database safely.
$946ex GSTLearn more
Level 1
Microsoft
2 days
Microsoft Access Essentials Course
Microsoft Access Essentials 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
- None
- 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.
- Tables, fields and data types
- Primary keys and relationships
- Select queries and criteria
- Why a database is not a spreadsheet
Course overview.
Tables, relationships and simple queries — why a database is not a spreadsheet.
The 2 days works through 11 modules and 31 individual topics, from Getting started with Microsoft Access to Report design and printing. 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.
-
1Getting started with Microsoft Access3 topics
- Finding your way around the Microsoft Access interface
- Opening and closing Microsoft Access
- Database fundamentals in brief
-
2Table design and data entry3 topics
- Designing tables with the right fields and properties
- How field properties and data types work
- Adding and changing data in a table
-
3Lookup lists2 topics
- Building tables to hold lookup lists
- Setting up and maintaining lookup lists
-
4Sorting, finding and filtering data3 topics
- Sorting the data in a table
- Locating and filtering records
- Tidying data with the Replace function
-
5Simple queries3 topics
- A first look at query design
- Building basic queries to pull out specific data
- Adding criteria to narrow the results
-
6Normalisation techniques3 topics
- How 1st, 2nd and 3rd Normal Forms work
- Normalising data for an efficient database
- Structuring tables to remove redundancy
-
7Table relationships3 topics
- Setting relationships between tables
- The role of primary and foreign keys
- Building relationship types (One-to-Many, Many-to-Many)
-
8Importing and linking data3 topics
- Bringing in data from other applications
- Linking Access tables held in other Access files
- Splitting a database with the Database Splitter
-
9Applied queries and calculations3 topics
- Building multi-table queries
- Handling parameter queries
- Calculating inside a query
-
10Forms2 topics
- A first look at form design
- Tailoring forms for data entry and navigation
-
11Report design and printing3 topics
- Designing reports that present data clearly
- Setting the default report margins
- Producing and printing reports from your database
Who it is for.
Anybody who uses Access and has never been shown it properly. No prerequisite and no assumed background beyond ordinary computer confidence.
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 Essentials 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 Essentials 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 Essentials
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.
Trainer / sessions presented well and provided additional skills and provided clearer understanding of MS Access.
Andrew
6 November 2025
Very good session. I feel like Gordana did a great job of breaking down database topics and queries way better than I have been able to so far. I feel like the team is much more comfortable with Access and I have learned a lot myself.
Max
6 November 2025
Gordana mainly focused on the hands-on experience which is really helpful for us to understand how to use the Table, Queries and Forms etc.
Max
6 November 2025
Gordana was great. Fiendly, knowledgable and patient. I really enjoyed the course.
Mark
6 November 2025
I really like that he was patient when I feel lost. Especially when its moments where the access version I had didnt match the lecturers
Ronnie
19 November 2025
Great! Small class made it easier to interact.
Tristan
19 November 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 Essentials 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 Essentials 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?
No prerequisite. The day assumes ordinary computer confidence and nothing more.
Can I do Microsoft Access Essentials 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 Essentials 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.