Download our guide to end user applications

Microsoft Access - The Essentials (ACSL1)

  • Length 1 day
  • Price  NZD 495 exc GST
Course overview
View dates &
book now
Register interest

Why study this course

In this course you'll be introduced to Microsoft's database management application, Access. It uses relational databases and provides a graphical user interface.

You'll learn how to use Access to create a simple database, organise and manage data. and use queries, forms, and reports.

Request Course Information


What you’ll learn

After completing this course, students will be able to:

  • Navigate within the Microsoft Access application environment and customise configuration options

  • Create a simple database

  • Organise and manage data stored within Access tables

  • Use queries to join, sort, and filter data from different tables

  • Use forms to make it easier to view, access, and input data

  • Create and format custom reports


Microsoft Solutions Partner - Cloud - Training Services Logo

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. 


Who is the course for?

This course is suitable for users who need an introduction to the basics of Microsoft Access.


Course subjects

Getting Started with Microsoft Access

  • Orientation to Microsoft Access

  • Create a Simple Access Database

  • Get Help and Configure Options in Microsoft Access

Working with Table Data

  • Modify Table Data

  • Sort and Filter Records

Querying a Database

  • Create Basic Queries

  • Sort and Filter Data in a Query

Using Forms

  • Create Basic Access Forms

  • Work with Data on Access Forms

Generating Reports

  • Create a Report

  • Add Controls to a Report

  • Enhance the Appearance of a Report

  • Prepare a Report for Print

  • Organise Report Information

  • Format Reports


Prerequisites

None


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

Awaiting course schedule

If you would like to receive a notification when this course becomes available, enter your details below.

Personalise your schedule with Lumify USchedule

Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.