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 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 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.


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.



Loading