Building Computer Skills to Enable Success
Building Computer Skills to Enable Success
Microsoft Access Intermediate/Advanced
What Your Team Will Learn
Ready for your team to elevate their database mastery to new heights? Welcome to our “Microsoft Access Intermediate/Advanced” course, where we’ll transform your staff from Access users into database development powerhouses!
Ever had colleagues spending hours manually updating records, knowing there must be a better way? Or wished your team could build custom forms or reports that do exactly what your organisation needs, but weren’t quite sure how to make it happen?
In this intensive two-day deep dive, we’ll take your group from competent Access users to confident database development experts. This course is designed for staff who already know their way around Access but are ready to harness its most powerful features. They’ll learn not just how to use the tools, but how to create entirely new solutions tailored to your workplace.
What You'll Get With This Course
Live Instructor-Led Training
Highly experienced and approachable trainers
Comprehensive Materials
eCertificate of Completion
Proudly recognise your achievement
Lifetime Support
Expert help, always within reach
Duration: 2 Days
Time: 9:00am – 4:00pm
CPD Hours: 12hrs
Microsoft Access Intermediate/Advanced Course Content
Review of Relationships
- Exploring Database Relationships
Parameter Queries
- Setting up Flexible Queries
- Modifying Parameter Queries
Using Query by Form
- Designing a Query by Form
- Setting up the Form Properties
Setting up Action Queries
- Understanding Action Queries
- Designing Action Queries
- Delete Queries
- Update Queries
- Make Table Queries
- Append Queries
Customising Reports
- Creating Custom Fields
- Report Layout Options
Customising Forms
- Building Custom Forms
- Adding Form Fields
- Adding Controls to a Form
Using Expressions in Forms
- Working with Expressions
- Using Calculations
Macros
- Building Macros
- Using the Macro Builder
*Our outlines are a guide to the content covered in a typical class.
We may change the course topics to meet the objectives of a particular class.
Want to run this course for your staff?
Standard course ready to go — customisation available if your team needs it.
Our Clients
FAQ's
We know team training comes with a lot of questions, who, what, how many, when, where, and sometimes even why. To save you a few clicks (and a few minutes), we’ve pulled together the most common ones we get from other HR managers, L&D teams, and people just like you.
Where can this Microsoft Access Intermediate/Advanced training be delivered?
We can deliver Intermediate/Advanced Access training in the way that suits your team best. If you’d like in-person learning, we’ll run the session at your office with direct, hands-on coaching. If your team is spread out, we can deliver it online with interactive demonstrations and activities. Some clients prefer a blended option, so staff can join either in person or virtually. The delivery format is completely flexible to fit your workplace.
How many staff can attend a Microsoft Access Intermediate/Advanced training session?
These sessions work best with small to medium groups, where participants can dive into the details and still get plenty of trainer support. We’ll recommend the ideal group size based on your training goals, but we’re happy to adjust to your needs. What matters is that everyone has the chance to practise intermediate and advanced techniques and have their questions answered along the way.
Can we schedule the Microsoft Access Intermediate/Advanced training at a time that suits us?
Yes. You might want two full days to tackle intermediate and advanced features thoroughly, or perhaps several shorter sessions to spread the learning out. We’ll plan the schedule with you, so the training complements your team’s workload rather than competing with it. Our goal is to maximise learning without disrupting your business.
What will my team be able to do after the Microsoft Access Intermediate/Advanced course?
After this course, participants will be able to design and manage complex databases with confidence. They’ll learn how to create advanced queries, design customised forms and reports, and use macros for automation. They’ll also explore best practices for efficiency and reliability. By the end, they’ll have the skills to handle more sophisticated database requirements in your organisation.
Do participants need any prior knowledge of Microsoft Access?
Yes. Learners should already be comfortable with the basics, including tables, simple queries, and basic forms. This ensures they can keep pace with the more advanced topics without feeling overwhelmed. If your staff are completely new to Access, we’d recommend starting with the Introduction course first.
Can the Microsoft Access Intermediate/Advanced training content be customised to our needs?
Definitely. We can adapt the training so that the examples and exercises reflect the way your organisation uses data. That might mean working with case studies from your industry or incorporating your actual databases into the training. This makes the learning much more relevant and directly applicable to the work your staff are already doing.
Will staff receive a certificate of completion?
Yes, everyone who completes the Intermediate/Advanced Access course will receive a certificate. This acts as proof of the new skills they’ve developed and can be kept on record internally or shared on professional platforms. It’s a great way to recognise their achievement and highlight your organisation’s investment in training.
Do you provide support after the Microsoft Access Intermediate/Advanced training?
Yes, we offer lifetime support for all participants. If someone encounters a tricky database challenge weeks later, they can get in touch, and we’ll help guide them through it. This ongoing support ensures your team doesn’t just learn the skills during the course but continues to apply them successfully long afterwards.
Get your team members to try our short, anonymous Access Intermediate/Advanced skills test.
You’ll discover your true proficiency level in minutes, no registration required
Prior Knowledge
Our Intermediate/Advanced Access course is for regular users of Microsoft Access who want to broaden their knowledge and to learn more advanced features. You should be proficient with intermediate features.
Required Software
You will need Microsoft Access installed on your computer to participate in this course. This can be through a Microsoft 365 subscription or a perpetual license version.
Course Materials
All exercise files needed for the course will be provided. In some cases, you may receive them by email prior to the training so you can download them in advance. Otherwise, everything will be supplied during the session, and no preparation is required.
Note About Different Versions
While this course uses the latest version of Microsoft Access, the skills learned are transferable to recent versions. However, for the best learning experience we recommend using the latest version of Microsoft Access.
Brendon Farrell
Co-Founder / Facilitator
From my early days wrestling with DOS commands to navigating today’s cloud-based world, I’ve dedicated my career to demystifying technology for others.
As a certified Microsoft and eLearning specialist, there’s nothing I enjoy more than seeing that spark of understanding when a student masters a new skill.
Outside of the training room, my passions run deep, whether I’m spending quality time with my wife and son, sharing my four decade love of lacrosse with junior players as their coach, or cycling around Melbourne’s on either my road bike or mountain bike.
Mark Finney
Co-Founder / Facilitator
With a coffee in hand and a passion for problem solving in my heart, I’ve made it my mission to turn tech frustrations into success stories. Through years of hands-on experience, I understand the challenges learners face.
Being both a co-founder and trainer at Keystroke Learning lets me combine my love for teaching with creating innovative learning solutions that actually work in the real world.
When I step away from the keyboard, find me strumming my favorite tunes on guitar, relaxing with my wife watching movies on the couch, or tending to my garden.