End User Applications Category Banner Image

Microsoft Access - Creating Relational Databases (ACSL2)

Length 1 day

Course overview

View dates &
book now

Course locations >>

Why study this course

Expand your knowledge of Microsoft Access and learn about relational database design, write advanced queries, structure existing data, validate data entered into a database, and customise reports.

Request Course Information

What you’ll learn

After completing this course, students will be able to:

Design a relational database in Microsoft Access
Join tables to retrieve data from unrelated tables
Validate data entered into a database
Use advanced queries to manipulate your data
Organise a database for efficiency and performance, and to maintain data integrity
Customise reports to organise the displayed information and produce specific print layouts

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.

View all Microsoft Apps courses

Who is the course for?

This course is suitable for users wishing to build on their basic Microsoft Access knowledge and work with more complex databases, queries, and reports.

Course subjects

Designing a Relational Database

Relational Database Design
Create a Table
Create Table Relationships

Joining Tables

Create Query Joins
Relate Data Within a Table
Work with Subdatasheets

Using Data Validation

Use Field Validation
Use Form and Record Validation

Creating Advanced Queries

Create Parameter Queries
Summarise Data
Create Subqueries
Create Action Queries
Create Unmatched and Duplicate Queries

Prerequisites

To maximise your success in this course, you should have already completed Microsoft Access - The Essentials or possess equivalent knowledge and skills.

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.