Find your new direction

  • 1300 76 2221
  • Australian owned and operated since 2008

Microsoft Office – Access 2016


Course Outline and Topics

Course Overview

Microsoft Office – Access 2016 is an online professional development course that will introduce you to database design and development concepts (including queries, forms and reports) using existing data.

In this online Microsoft Access course, you will learn the fundamentals of creating core objects of a database, data manipulation and extraction at an introductory level.

Throughout the course, you will learn how to design databases to meet organisational and task requirements. You will also learn how to test and finalise databases and analyse the effectiveness of data relationships.

This course is ideal for those employed in a range of work environments who create databases to store and retrieve data using Microsoft Access 2016.

Course Structure

Unit 1 - Design databases Using Access 2016

  • Design database
  • Task requirements
  • Relational databases
  • Normalisaton of data
  • Forms
  • Logical data model
  • Data types
  • Functionality of databases
  • Using Microsoft Access
  • Basic operations
  • Set field attributes
  • Linking databases
  • Creating a database
  • Creating tables
  • Database tools
  • Naming conventions
  • Primary key
  • Foreign keys
  • Software functions
  • Formulae
  • Develop queries
  • SQL statements
  • Input screens
  • Custom buttons
  • Macros
  • Reports
  • Sample data set for testing
  • Data effectiveness

Unit 2 - Operate database applications Using Access 2016

  • Create database
  • Basic design principles
  • Saving databases
  • Database types
  • Access data types
  • Modify tables
  • Fields
  • Creating primary keys
  • Establish index
  • Table relationships
  • Customise basic settings
  • Adjusting page layouts
  • Toolbars
  • Format painter
  • Text formatting
  • Create tab
  • External Data tab
  • Database Tools tab
  • Create reports
  • Report Wizards
  • Create forms
  • Form Wizard
  • Rearrange objects
  • Retrieve information
  • Filter records


Written assignments and exercises, including short-answer questions, reports/essays and projects. There are no examinations or due dates for assessment.

Payment Information

Certificate Course



  • Recognised by employers as professional development;
  • Improve your employment opportunities;
  • Study online, anywhere via our elearning system;
  • Access to high-quality courses written by industry experts;
  • All course materials provided online – no textbooks to buy;
  • Unlimited tutor support;
  • Easy to understand course content;
  • Unlimited enrolment with no expiry;
  • Certificate of Attainment issued for your CV (hard copy provided); and
  • Course may be tax deductible; see your tax advisor.
  • Includes unlimited access
  • Full up-front payment only