Microsoft Access 2016
Level 3
INFOCUS COURSEWARE
Product Code: INF1632 ISBN: 978-1-925526-00-4
General The skills and knowledge acquired in Microsoft Access 2016 - Level 3 are sufficient to design
Description and create a multi-table database and automate operations using macros and have a general
understanding of the programming environment in Microsoft Access 2016.
Learning At the completion of this course you should be able to:
Outcomes
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
Prerequisites Microsoft Access 2016 - Level 3 assumes a significant knowledge of the software, and it
would be beneficial to have a general understanding of personal computers and the
Windows operating system environment.
Topic Sheets 103 topics
Methodology The InFocus series of publications have been written with one topic per page. Topic sheets
either contain relevant reference information, or detailed step-by-step instructions designed
on a real-world case study scenario. Publications can be used for instructor-led training, self-
paced learning, or a combination of the two.
Formats A4 Black and White, A5 Black and White (quantity order only), A5 Full Colour (quantity order
Available only), Electronic Licence
Companion There are a number of complementary titles in the same series as this publication.
Products Information about other relevant publications can be found on our website at
www.watsoniapublishing.com.
This information sheet was produced on Wednesday, October 26, 2016 and was accurate at the time of printing. Watsonia Publishing reserves its right to
alter the content of the above courseware without notice.
Product Information
47 Greenaway Street Phone: (+61) 3 9851 4000
Bulleen VIC 3105 Fax: (+61) 3 9851 4001
Australia info@watsoniapublishing.com
ABN 64 060 335 748 www.watsoniapublishing.com
Microsoft Access 2016
Level 3
INFOCUS COURSEWARE
Product Code: INF1632 ISBN: 978-1-925526-00-4
Contents
Relational Database Design Creating a Right Outer Join Checking Object Dependencies
Designing a Relational Database Analysing Database Performance
Aggregation Queries Documenting a Database
Scoping the System Creating an Aggregation Query
Determining the Inputs Working With Aggregation Queries An Introduction to VBA
Normalising a Database Multiple Aggregations Understanding VBA
First Normal Form (1NF) Modifying Aggregation Headings Coding VBA for an Event
Second Normal Form (2NF) Aggregating Calculated Fields Running VBA Event Code
Second Normal Form Case Study Applying Criteria to Aggregates Understanding MsgBox and InputBox
Third Normal Form (3NF) Understanding Nested Queries Modifying an Existing Procedure
Database Indexing Creating an Assembly Query Understanding the Modified Code
Creating a Relational Database Creating the Nesting Query Creating a Standard Module
Creating a New Database File Loan Simulator Code
Action Queries Running the Code
Creating Lookup Tables Creating a Make Table Query
Defining a Primary Key Understanding the Loan Simulator
Using a Make Table Query Code
Saving and Closing a Table Understanding Expressions and
Creating the Expense Type Table Creating a Button for the Simulator
Update Queries Attaching the Simulator Code
Creating the Transactions Table Preparing an Update Query
Creating the Details Table Running an Update Query
Setting Table Relationships Updating Using Expressions
Understanding Table Relationships Running an Expression-Based Update
Understanding Lookup Relationships Creating a Delete Query
Looking Up the Employees Table Running a Delete Query
Looking Up the Expense Types Table Creating an Append Query
Viewing Table Relationships Running an Append Query
Understanding Table Joins Turning Action Messages Off
Editing the Employee Table Join Database Security
Editing the Expense Type Table Join Understanding Database Trust
Creating a New Join Enabling Blocked Content
Creating a Relationship Report Understanding the Trust Centre
Importing and Exporting Records Creating a Trusted Location
Exporting Records to Microsoft Excel Opening a Database From a Trusted
Exporting Records to a Text File Location
Importing From Microsoft Excel Encrypting a Database
Importing From a Text File Decrypting and Opening a Database
Linking to an External Source Removing a Database Password
Understanding Package and Sign
Multi Table Queries Creating a Self Signed Certificate
Understanding Relational Queries Creating a Signed Package
Creating a Relational Query Design Extracting and Using a Signed
Filtering a Relational Query Package
Filtering Related Fields
Adding More Tables and Fields Database Wellness
Utilising Hidden Fields Compacting and Repairing a
Understanding Query Joins Database
Creating an Inner Join Understanding Database Splitting
Creating a Left Outer Join Using the Database Splitter
Managing Linked Tables
Product Information
47 Greenaway Street Phone: (+61) 3 9851 4000
Bulleen VIC 3105 Fax: (+61) 3 9851 4001
Australia info@watsoniapublishing.com
ABN 64 060 335 748 www.watsoniapublishing.com
