Download our guide to end user applications

Microsoft Access - Advanced

Length 2 days
Price NZD 855.65 exc GST

Course overview

View dates &
book now

Why study this course

Enhance your database skills with advanced Microsoft Access techniques in this 2-day, hands-on training course.

Microsoft Access is a versatile database management system, designed for both individual and small business use. It allows users to store, manage, and retrieve data efficiently, making it ideal for creating custom databases tailored to specific needs. With the ability to design queries, forms, and reports, Access provides a user-friendly environment for data management without requiring extensive programming knowledge.

In this course, you'll build on your existing knowledge and master advanced database management techniques using Access. You'll learn to create complex queries, customise reports, automate workflows with macros, and optimise database performance for efficient and secure data management. Perfect for professionals managing large or complex datasets, this advanced Access course equips you with the tools to streamline processes and improve productivity.

Note: Access 2016, Access 2019, Access 2021, and Access 365 are all desktop application versions of Microsoft Access. Access 2016, Access 2019, and Access 2021 are the perpetual, bought-outright, stand-alone versions of the software; Access 365 is the subscription-based version. Anyone working with any of these versions will be able to successfully complete this course. Throughout this course you will be using the desktop app; the course does not cover use of the web/online app.

Nexacu Public Schedule

Nexacu is part of the Lumify Group, offering you the largest public schedule of end user applications and professional development training in Australia, New Zealand, and the Philippines. You can now access the schedule of courses and book, by clicking on the button below.

Book now!

Request Course Information

What you’ll learn

After completing this training course, you should be able to:

Apply advanced table, query, form, and report design techniques
Customise user access and permissions for database objects
Design user interfaces for automated workflows
Perform database maintenance and optimise performance

Microsoft Apps at Lumify Work

As part of Lumify Group, Lumify Work has skilled more people in Microsoft technologies than any other organisation in Australia and New Zealand. We have a campus in the Philippines, too. We offer the broadest range of instructor-led training courses, from end user to architect level. We are proud to be the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers in ANZ.

View all Microsoft Apps at Lumify Work courses

Who is the course for?

This course is designed for users who are keen to build on their existing knowledge and master advanced techniques in Microsoft Access, particularly those managing large or complex datasets.

Course subjects

Customising Tables and Relationships

Advanced field properties and data types
Managing complex relationships between tables
Setting up referential integrity and cascade options

Creating Applied Queries

Performing calculations within queries
Designing multi-table queries for advanced data extraction
Using the Find Unmatched Query Wizard

Advanced Query Techniques

Creating Top Value Queries for ranked data
Implementing Complex Calculations within queries
Using Directional Join Queries for data analysis
Running Parameter Queries through forms
Understanding and creating SQL-specific queries

Using Action Queries

Introduction to Action Query types
Creating Update, Append, and Delete Queries
Automating data management with Action Queries

Advanced Report Design

Adding Custom Expressions to reports
Integrating Mail Merge with Microsoft Word
Designing reports for complex data presentation

Working with Macros

Recording, running, and assigning Macros
Using Conditional Macros and IF statements
Implementing SubMacros for complex automation
Setting Database Start-up options with Macros

Macros Workshop

Updating Combo Box contents dynamically
Controlling Form behaviour (Disable/Enable, Show/Hide controls)
Importing data from Excel and updating tables through Macros

Database Tools and Optimisation

Compacting, repairing, and backing up databases
Using the Database Documenter for in-depth analysis
Analysing database performance and optimisation strategies
Importing and Exporting data across applications

Switchboards and Start-Up Forms

Using the Switchboard Manager to create navigation menus
Designing and customising Switchboard Forms
Setting up Start-up Forms for streamlined user experience

Prerequisites

A basic understanding of Microsoft Access is required. We recommend completing the Access Essentials course or having equivalent experience before attending.

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

Looking for more course options?

View all Microsoft Apps courses View all End User Applications courses View all Business Applications courses

Offers

Accelerate Copilot adoption with up to 50% off training

The promise of AI and Microsoft 365 Copilot in particular is clear. Microsoft research demonstrates that Copilot adoption results in: Significant time savings across departments Improved efficiency in document creation and communication Enhanced employee satisfaction and reduced repetitive tasks Copilot boosts creativity and makes data-driven insights more accessible than ever before. But how can businesses realise these benefits at scale? As the 2024 Work Trend Annual Report noted: “We’ve come to the hard part of any tech disruption: moving past experimentation to business transformation. Just as we saw with the advent of the internet or the PC, business transformation comes with broad adoption.”

Find out more