Download our guide to end user applications

Microsoft Access - The Essentials (ACSL1)

  • Length 1 day
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

Lumify Work has been delivering effective training across all Microsoft products for over 30 years. We are proud to be both Australia's and New Zealand’s first Microsoft Gold Learning Solutions Partner and the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers (MCTs) in ANZ. Join more than 5,000 students who attend our quality Microsoft courses every year.


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.