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 2013 - Level 3 (with Challenge Exercises)

Self-taught course


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

Target audience

Anyone who wants to further their skills with Microsoft Access 2013.


Microsoft Access 2013 - Level 3 (with Challenge Exercises) assumes some knowledge of the software to create basic databases and generate reports. It would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

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
  • Practice Exercise
  • Practice Exercise Sample

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
  • Practice Exercise
  • Practice Exercise Data

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
  • Practice Exercise
  • Practice Exercise Sample

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
  • Practice Exercise
  • Practice Exercise Sample

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
  • Practice Exercise
  • Practice Exercise Sample

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
  • Practice Exercise
  • Practice Exercise Sample

Macro Techniques

  • Creating A Print Macro
  • Using Conditions To Enhance A Macro
  • Creating A Sequence Of Conditions
  • Understanding The Versatility Of MsgBox
  • Using The MsgBox Function
  • Reconfiguring A Message Box
  • Using The InputBox Function
  • Practice Exercise
  • Practice Exercise Sample

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
  • Practice Exercise
  • Practice Exercise Workspace

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
  • create queries based on one or more tables
  • create and work with aggregation queries
  • create and use a series of action queries
  • work with a number of macro techniques
  • create some simple programming code using VBA

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

System requirements

Windows with Microsoft Access 2013


Approximately 10 hours

Related courses

Booking / availability