skip to navigation skip to content
Self-taught course

Provided by: University Information Services - Digital Literacy Skills


This course is self taught (Materials may be loaned out).

Bookings cannot be made on this course (Course is not taking bookings).

More information about UIS self-taught courses.

Booking / availability

Microsoft Access 2016 - Level 3 (with Challenge Exercises)

Self-taught course


The skills and knowledge acquired in Microsoft Access 2016 - Level 3 (with Challenge Exercises) are sufficient to design and create a multitable database and automate operations using macros and have a general understanding of the programming environment in Microsoft Access 2016.

Target audience

Anyone who wants to gain a deeper understanding of Microsoft Access 2016 or build upon the completion of Microsoft Access 2016 - Level 1 (with Challenge Exercises) and Microsoft Access 2016 - Level 2 (with Challenge Exercises)

Topics covered

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

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

Watsonia workbook with 93 topics. Files for the exercises are provided on a CD or can be downloaded here


Approximately 15 hours

Booking / availability