The skills and knowledge acquired in this Microsoft Access course are sufficient to design and create a multi-table database, automate operations using macros, and have a general understanding of the programming environment in Microsoft Access.
Note: Access 2016, Access 2019, Access 2021, and Access 365 are all desktop application versions of Microsoft Access. Access 2016, Access 2019, and Access 2021 are the perpetual, bought-outright, stand-alone versions of the software; Access 365 is the subscription-based version. Anyone working with any of these versions will be able to successfully complete this course. Throughout this course you will be using the desktop app; the course does not cover use of the web/online app.
Request Course Information
By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.
What you’ll learn
At the completion of this course you should be able to:
Design a relational database project
Create a relational database file with multiple tables
Set table relationships and join tables together
Export records to and import records from a wide variety of sources and applications
Create queries based on one or more tables
Create and work with aggregation queries
Create and use a series of action queries
Make your Microsoft Access data and computer more secure
Understand and use a variety of tools that ensure the wellness of your database files
Create some simple programming code using VBA
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.
Stay ahead of the technology curve
Don’t let your tech outpace the skills of your people
Train Anywhere
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
We have a 30-year history of driving innovative, award-winning learning solutions.
More Courses, More Often
When you train with Lumify Work you get more courses, more often, in more locations, and from more vendors.
Quality Instructors and Content
Expert instructors with real world experience and the latest vendor-approved in-depth course content.
Partner-Preferred Supplier
Chosen and awarded by the world's leading vendors as preferred training partner.
Ahead of the Technology Curve
No matter your chosen technologies or platforms, we can help you stay one step ahead.
Train Anywhere
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
We have a 30-year history of driving innovative, award-winning learning solutions.
More Courses, More Often
When you train with Lumify Work you get more courses, more often, in more locations, and from more vendors.
Quality Instructors and Content
Expert instructors with real world experience and the latest vendor-approved in-depth course content.
Partner-Preferred Supplier
Chosen and awarded by the world's leading vendors as preferred training partner.
Ahead of the Technology Curve
No matter your chosen technologies or platforms, we can help you stay one step ahead.
Train Anywhere
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
We have a 30-year history of driving innovative, award-winning learning solutions.
More Courses, More Often
When you train with Lumify Work you get more courses, more often, in more locations, and from more vendors.
Who is the course for?
This course is primarily designed for people who need to know how to develop relational databases and automate operations in Microsoft Access.
We can also deliver and customise this training course for larger groups – saving your organisation time, money and resources. For more information, please contact us on 1800 U LEARN (1800 853 276)
Course subjects
Relational Database Design
Designing a Relational Database
Scoping the System
Determining the Inputs
Normalising a Database
First Normal Form (1NF)
Second Normal Form (2NF)
Second Normal Form Case Study
Third Normal Form (3NF)
Database Indexing
Creating a Relational Database
Creating a New Database File
Creating Lookup Tables
Defining a Primary Key
Saving and Closing a Table
Creating the Expense Type Table
Creating the Transactions Table
Creating the Details Table
Setting Table Relationships
Understanding Table Relationships
Understanding Lookup Relationships
Looking Up the Employees Table
Looking Up the Expense Types Table
Viewing Table Relationships
Understanding Table Joins
Editing the Employee Table Join
Editing the Expense Type Table Join
Creating a New Join
Creating a Relationship Report
Importing and Exporting Records
Exporting Records to Microsoft Excel
Exporting Records to a Text File
Importing From Microsoft Excel
Importing From a Text File
Linking to an External Source
Multi Table Queries
Understanding Relational Queries
Creating a Relational Query Design
Filtering a Relational Query
Filtering Related Fields
Adding More Tables and Fields
Utilising Hidden Fields
Understanding Query Joins
Creating an Inner Join
Creating a Left Outer Join
Creating a Right Outer Join
Aggregation Queries
Creating an Aggregation Query
Working With Aggregation Queries
Multiple Aggregations
Modifying Aggregation Headings
Aggregating Calculated Fields
Applying Criteria to Aggregates
Understanding Nested Queries
Creating an Assembly Query
Creating the Nesting Query
Action Queries
Creating a Make Table Query
Using a Make Table Query
Understanding Expressions and Update Queries
Preparing an Update Query
Running an Update Query
Updating Using Expressions
Running an Expression-Based Update
Creating a Delete Query
Running a Delete Query
Creating an Append Query
Running an Append Query
Turning Action Messages Off
Database Security
Understanding Database Trust
Enabling Blocked Content
Understanding the Trust Centre
Creating a Trusted Location
Opening a Database From a Trusted Location
Encrypting a Database
Decrypting and Opening a Database
Removing a Database Password
Understanding Package and Sign
Creating a Self Signed Certificate
Creating a Signed Package
Extracting and Using a Signed Package
Database Wellness
Compacting and Repairing a Database
Understanding Database Splitting
Using the Database Splitter
Managing Linked Tables
Checking Object Dependencies
Analysing Database Performance
Documenting a Database
An Introduction to VBA
Understanding VBA
Coding VBA for an Event
Running VBA Event Code
Understanding MsgBox and InputBox
Modifying an Existing Procedure
Understanding the Modified Code
Creating a Standard Module
Loan Simulator Code
Running the Code
Understanding the Loan Simulator Code
Creating a Button for the Simulator
Attaching the Simulator Code
Prerequisites
This course assumes a significant knowledge of Microsoft Access. You should be familiar with the topics covered in Microsoft Access - Level 1 and Level 2.
End User Seminars
Seminar-style training is conducted in short sessions of 1-3 hours and is ideal for groups of up to 30 students.
M365 Adoption and Training Plans
Our aim is to help educate and enable your organisation to get the best return on your Microsoft 365 investment.
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
By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.
