End User Applications Category Banner Image

Microsoft Access - Creating Relational Databases (ACSL2)

  • Length 1 day
Course overview
View dates &
book now

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 Partner Cloud Logo

Microsoft Apps at Lumify Work

Lumify Work is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia's and New Zealand’s first and largest Microsoft Gold Learning Solutions Partner. 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

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.