Call for Queries?
View on Map
Participants on this Microsoft Access Advanced 2 day course will build on their existing knowledge and skills using Access. You will review database design principles and Relationships, before moving on to advanced tools such as Parameter Queries and Custom Forms and Reports.
The course assumes you have a solid working knowledge of Access, those needing to extend their database skills will benefit from this course.
Participants should have a solid understanding of the fundamentals of Microsoft Access. Ideally you will have completed our Microsoft Access Introduction training course, or have some prior experience using Access Databases.
Once you’ve completed this Access Advanced course, you may like to compliment it with our Microsoft Power BI course.
$1,200.00
We currently do not have this course on our public schedule, but don’t let that deter you!
Exciting news! We are currently offering special prices for one-on-one training for this program.
Call us on (03) 9999 7780 or email us to discuss you options.
Psst… We can also organise group training sessions.
*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.
Our training approach is professional yet friendly, motivating participants to learn quickly and easily.
When you complete our training course, you will be ready to apply your new skills right away.
Monday – Friday 8:30am – 5:00pm
Self Paced Assisted Learning combines the best of independent learning with the best of trainer assisted learning.
This unique approach to learning works as follows:
Each participant is provided with a training manual for a given application and level, and they work through a series of exercises.
If they get stuck or don’t understand a concept, the trainer is immediately available to help them understand the issue at hand and to give examples of how to implement the feature or application.
It is not uncommon to see one person working on an Excel Advanced manual while the person beside them is doing a Word Introduction, and another is working on something else.
The role of the trainer in the Self Paced environment is quite different to their role in a typical classroom. Even when each participant is working well unassisted, the trainer will be actively monitoring their progress, providing feedback and encouragement as well as fine-tuning the learning process. There is usually little time to “take it easy” as the trainer works to increase the efficiency and effectiveness of learning.
Self Paced Assisted Learning is very personalised, with the interactions generally being around individuals and small groups.
These sessions can be broken into 1.5-hour blocks of time, allowing up to 4 sessions in a day, thus allowing a larger number of people to attend for shorter time periods.
We pack more useful information into our Webinar Training Sessions than a squirrel stuffs acorns for winter.
Ditch the sink-or-swim approach to new technology. Our Webinar Sessions are your team’s virtual lifeline to tech proficiency.
These interactive online gatherings transform intimidating rollouts into engaging adventures. Our expert trainers don’t just introduce change – they help make your team embrace it. We explain the ‘why’ behind new systems, turning sceptics into champions with concise, high-impact briefings.
Forget dull lectures. Our sessions spark lively discussions and showcase features with contagious enthusiasm. Whether your team is office-based or remote, we bring the learning to them.
Investing in training isn’t just smart; it’s crucial. Our Webinar Sessions are your compass in the sea of technological change.
Upgrading systems? Migrating platforms? Introducing new tech? We’ve got you covered.
Let’s face it, expecting your staff to “figure it out” on their own is a recipe for chaos, confusion, and probably a few broken keyboards. Relying on this approach is like using “password123” for your bank account, technically possible, but you’re just asking for trouble.
Enter Seminar Training, the GPS for your technologically challenged employees!
Perfect for large groups needing to get up to speed, our seminars address organisational changes, explaining the rationale and benefits. We encourage audience interaction, generating discussions that’ll make your team feel engaged.
These sessions provide concise overviews of new systems and features, delivering targeted briefings with minimal disruption. It’s like speed dating, but instead of potential partners, your employees meet productivity boosters!
Our expert trainers don’t just demonstrate key functionalities, they perform them with the flair of a Vegas magician. To maximize the learning impact, many clients complement our seminars with our Roving Training program.
Whether you call them seminars or awareness sessions, when you’re upgrading, migrating, or introducing new technology, we’re here to save the day and your team will be begging for the next software update.
Got a questions about Seminar Training? Contact us for answers!
Roving Training brings expert facilitators directly to your workspace, either in-person or virtually, to address specific training needs.
Looking for training that’s as unique as your team? You might stumble upon a few buzzwords like “Roving Training”, “On-Demand Training”, “Floor Walking”, “Corporate Trubleshooting”, “Floater”, or “Roaming Training Services”.
Basically, they’re all just fancy ways of saying, “On-the-spot instruction tailored to specific needs”.
Roving Training is a 1 on 1 or very small group training session which is generally scheduled for short timeframe on a specific subject.
Typically, these training sessions are structured by allocating time slots/appointments with individuals. The topics covered throughout the session do not have to be at the same level or software package.
Roving Training offers the benefit of immediate, hands-on support right where and when it’s needed, ensuring that learning is directly applicable and highly relevant to real-time challenges.
In this example, Sarah, the office superhero has scheduled blocks of time for her colleagues. For instance, James is scheduled at 9:30am for half an hour to work on Pivot Tables. After James gets his Excel fix, the trainer visits Ellen at 10:00am for an hour to help solve a problem she is having with Photoshop. The trainer then continues visiting each person in the schedule, addressing their individual requirements.
Sarah also handles training during software upgrades and rollouts with one of our nifty tactics called floor walking. This involves the trainer roaming around the office to provide instant, on-the-spot support for any tech hiccups.
It’s like having a tech wizard who appears out of nowhere when you need them the most, no magic wand required, just a trainer with lots of expertise and a friendly smile!
Upgrade your colleagues from “Control+Alt+Defeat” to “Tech+Savvy+Elite”!
Attention all tech-challenged teams and software-phobic departments! Is your office filled with cold sweats at the mere mention of pivot tables? Does the phrase “software update” send shivers down your spine like a horror movie jump scare? Fear not, our Group Training Courses are here to transform your tech terrors into laugh-out-loud learning adventures!
Our Full-Day Courses are the brain boot camp you never knew you needed. No drill sergeants or questionable cafeteria food here, just a day packed with digital discoveries.
For those who prefer their learning strong like their coffee, our Half-Day Courses deliver an espresso shot of education in just 3 hours.
And for the ultimate in tailored training, our Customised Courses are the Tinder of tech education. Swipe right on the modules you love, left on those you don’t. It’s all about finding your perfect match in the digital dating pool.
So, let’s turn those frustrating error messages into exhilarating “Eureka!” moments.
Full-Day Group Training Sessions provide a deep dive into your chosen subject, offering a comprehensive experience that’s perfect for teams eager to explore topics in detail.
Think of it as an intellectual day spa, with plenty of time to soak in each concept, from the fundamentals to the fine points. Your brain cells will thank you for the pampering!
With a full day dedicated to learning, participants can engage in extensive hands-on activities, workshops, and real-world applications.
You’ll have ample opportunity to tackle complex problems, ask questions, and even share a laugh or two as you work through exercises.
A standard training course takes around 6 hours, plus scheduled breaks to ensure everyone stays refreshed and ready to absorb more. We promise not to make you do jumping jacks during these breaks… unless you really want to.
The start time of the training is completely negotiable, but typically, the training time slot will be 9:00am – 4:00pm.
This turns the training day into an enjoyable and productive fun run rather than a sprint. Don’t worry, the only medals awarded will be for “Most Enthusiastic Learner”
Half-Day Group Training Sessions offer a focused exploration of your chosen subject, providing a compact yet impactful experience that’s ideal for teams looking to dive into topics efficiently.
Think of it as an intellectual boost, with a concentrated dose of knowledge that’ll leave your brain feeling refreshed and invigorated. It’s like a shot of espresso for your mind, minus the jitters!
In this condensed learning sprint, participants engage in targeted hands-on activities, workshops, and real-world applications. It’s a mental obstacle course designed to challenge and stimulate without being overwhelming.
You’ll have the chance to tackle key problems, ask burning questions, and maybe even crack a few witty one-liners as you zip through exercises. After all, who said learning can’t be snappy and snazzy?
A standard training course takes around 3 hours to complete, which includes a short break at the halfway point. Don’t worry, we won’t make you solve riddles to earn your break—unless that’s part of the training, of course!
The start time of the training is completely negotiable but typically, the training time slot will either be 9:00 am – 12:00 pm or 1:00 pm – 4:00 pm. Whether you’re an early bird or a post-lunch learner, we’ve got you covered.
Off-the-Shelf Training is like walking into a bookstore and picking out the perfect novel, it’s ready to go and has been vetted for quality.
These pre-designed courses are packed with tried-and-tested content, so you can dive right into learning without any fuss.
Whether you’re tackling Microsoft Office, Adobe Creative Cloud, or any other major software, these courses are designed to cover the essentials with a dash of flair.
Just as how you wouldn’t need to re-write a bestselling novel, you don’t need to re-invent the wheel with these training options.
They’re perfect for when you want solid, no-nonsense learning that’s ready when you are.
Customised Training is the tailor-made suit of the training world.
Think of it as the Gucci suit of the learning world — bespoke, fitted, and perfectly aligned with what you need.
It’s all about designing a training experience that’s as unique as your organisation.
Just like a custom suit is made to fit every curve and seam, customised training is crafted to address specific challenges, industry nuances, and skill gaps within your team.
Our training is modular, so you can mix and match like a fashionista, choosing from a selection of existing topics, or we can work with you to develop something specific to your organisation. Either way, we are on hand for advice on the best way to structure your customised training course.
Do you need a custom training solution? Get in touch with us!
Designed for participants who already have a basic understanding of an application but need to fill specific knowledge gaps.
The 1 on 1 training option provides a completely personalised training experience.
These sessions are entirely focused on the needs of the individual participant, whether that need is to become an expert in Microsoft Office, Adobe Creative Cloud, or simply to become more proficient with other commonly used software applications.
1 on 1 training sessions are delivered in 3-hour blocks, while additional 1-hour blocks can be added if required. The choice is yours.
Raise Your Skills with Expert-Led
Public Training Courses!
Are you tired of fumbling through Excel like it’s a complex puzzle? Ever wished you could wave a magic wand to fix your an image?
Well, Keystroke Learning’s Public Scheduled Training Courses are designed to meet specific training needs.
People from different companies all attend the same course at the same time, turning our Melbourne CBD training room into a bustling hive of learning and collaboration. Everyone brings something different to the table!
Can’t make it to Melbourne? No worries! We offer our courses online and in hybrid mode too, so you can join from anywhere.
Check out our Public Course Timetable and take your skills to the next stage!