The skills and knowledge acquired in this course are sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports, and generate queries on the data.
You may also be interested in our Level 2 and Level 3 courses which cover more advanced topics such as data validation, complex queries, macros, multi-table databases, and automating processes.
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:
Understand how Access is used and how to navigate around it
Design a database with lookup tables
Create a database structure using Access
Modify the structure of an existing table
Add records to a new table
Add transactional records to a lookup database
Work with the records in a database table
Sort and filter records in a table
Create simple and effective queries
Create meaningful reports from tables
Create and use forms
Microsoft Office Applications at DDLS
DDLS 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 First and largest Microsoft Gold Learning Solutions Partner. All DDLS Microsoft courses follow Microsoft Official Curriculum (MOC) and are led by Microsoft Certified Trainers. Join more than 5,000 students who attend our quality Microsoft courses every year.
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
30 years driving innovative, award-winning learning solutions
More Courses, More Often
When you train with DDLS 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
30 years driving innovative, award-winning learning solutions
More Courses, More Often
When you train with DDLS 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
30 years driving innovative, award-winning learning solutions
More Courses, More Often
When you train with DDLS you get more courses, more often, in more locations and from more vendors.
Who is the course for?
This course is designed for users who need to know how to create databases and to manipulate data to provide viable information.
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
Getting to Know Access 2016
Understanding Microsoft Access 2016
Starting Access From the Desktop
Understanding the Start Screen
Creating a New Blank Database
Understanding the Backstage View
Opening an Existing Database File
Understanding the Access 2016 Screen
Using the Ribbon
Working With the Navigation Pane
Adding Commands to the QAT
Working With Touch Mode
Working With a Table
Working With Other Database Objects
Closing a Database File
Exiting From Access 2016
Designing a Lookup Database
Understanding How Access Stores Data
Understanding Access 2016 Data Types
Scoping Your New Database
Identifying Table Problems
Refining Table Structures
Finalising the Design
Creating a Lookup Database
Creating a New Database File
Creating the Lookup Table
Defining the Primary Key
Saving and Closing a Table
Creating the Transaction Table
Understanding Lookup Table Relationships
Connecting to a Lookup Table
Viewing Table Relationships
Modifying Table Structures
Opening an Existing Table
Adding Fields to an Existing Table
Understanding Field Properties
Changing Field Size
Changing Field Names
Changing Decimal Places
Changing Date Formats
Indexing Fields
Deleting Fields From a Table
Copying a Table Within a Database
Deleting a Table From a Database File
Adding Records to a Table
Typing Records in a Table
Adding Records Using a Form
Saving a Form Layout for Reuse
Adding Records Using an Existing Form
Adding Additional Records
Importing From Microsoft Excel
Adding Transactional Records
Typing Transactional Records
Adding Transactional Records Using a Form
Adding Additional Transactional Records
Adding Records Using a Subdatasheet
Removing a Subdatasheet
Inserting a Subdatasheet
Working with Records
Table Navigation
Navigating to a Specific Record
Editing a Record
Deleting Record Data
Undoing a Change
Deleting a Record
Deleting Several Records
Searching in a Table
Searching in a Field
Finding and Replacing
Printing Records From a Table
Compacting a Database
Sorting and Filtering
Simple Sorting
Sorting on Several Fields
Simple Filtering
Working With Filters
Filtering Between Dates
Creating Queries
Understanding Queries
Creating a Query Design
Working With a Query
Changing a Query Design
Applying Record Criteria
Clearing Selection Criteria
Saving a Query
Running Queries From the Navigation Pane
Deleting a Query
Creating Additional Queries
Creating and Using Reports
Understanding Reporting in Access
Creating a Basic Report
Working With Existing Reports
Previewing and Printing a Report
Changing the Report Layout
Using the Report Wizard
Creating a Grouped Report
Creating a Statistical Report
Working With Grouped Reports
Creating and Using Forms
Understanding Forms
Creating a Basic Form
Creating a Split Form
Binding a Form to a Query
Using the Form Wizard
Working With Existing Forms
Editing Records in a Form
Deleting Records Through a Form
Deleting an Unwanted Form
Prerequisites
This course assumes little or no knowledge of Microsoft Access 2016. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.
Terms & Conditions
The supply of this course by DDLS 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.
