Download our guide to end user applications

Microsoft Access - Essentials

Length 2 days
Price $1000 inc GST

Course overview

View dates &
book now

Why study this course

Learn the basics of Microsoft Access for effective database management 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 be introduced to core Access features, helping you build, manage, and optimise relational databases with confidence. You'll learn practical skills to create tables, manage data, design queries, and generate professional reports, enabling you to organise and analyse information effectively. Ideal for beginners, this Access course provides a solid foundation for managing databases in any business or organisation.

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:

Create tables with appropriate fields, data types, and properties
Establish relationships between tables for efficient data management
Design user-friendly forms for streamlined data entry
Generate and print professional reports to present key insights

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 Microsoft Access training course is designed for users who are new to Access and its features. You may already be familiar with other Microsoft applications.

Course subjects

Introduction to Microsoft Access

Understanding the Microsoft Access Interface
Starting and Exiting Microsoft Access
Overview of Database Fundamentals

Table Design and Data Entry

Designing Tables with appropriate fields and properties
Understanding field properties and data types
Entering and modifying table data

Working with Lookup Lists

Creating Tables for Lookup Lists
Setting up and managing Lookup Lists

Sorting, Finding, and Filtering Data

Sorting data within tables
Finding and filtering records
Using the Replace function for data management

Creating Simple Queries

Introduction to Query Design
Creating basic queries to extract specific data
Applying criteria to queries for focused results

Normalisation Techniques

Understanding 1st, 2nd, and 3rd Normal Forms
Normalising data to ensure database efficiency
Structuring tables to eliminate redundancy

Managing Table Relationships

Defining relationships between tables
Understanding primary and foreign keys
Implementing relationship types (One-to-Many, Many-to-Many)

Importing and Linking Data

Importing data from other applications
Linking Access Tables from other Access files
Using the Database Splitter for data management

Applied Queries and Calculations

Creating Multi-Table Queries
Working with Parameter Queries
Performing calculations within queries

Creating Forms

Introduction to Form Design
Customising forms for data entry and navigation

Report Design and Printing

Designing reports to present data effectively
Setting default margins for reports
Generating and printing reports from your database

Prerequisites

This course assumes little or no knowledge of Microsoft Access.

It is recommended that you have a basic understanding of Windows and experience with a Microsoft application, such as Word or Excel.

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