Find your new direction

  • 1300 76 2221
  • Australian owned and operated since 2008

Microsoft Office – Access 2013


Course Outline and Topics

Course Overview

Microsoft Office – Access 2013 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 2013.

Course Structure

Unit 1 - Design databases Using Access 2013

  • Design database
  • Scope and functionality
  • Normalisation
  • Data types
  • Develop database
  • Relational databases
  • Creating a database
  • Database tables
  • Creating tables
  • Design view
  • Data types
  • Input mask
  • Database tools tab
  • Compact and repair database
  • Primary key
  • Foreign keys
  • Query design
  • Develop forms and reports
  • Auto forms
  • Manually created forms
  • Sub-forms
  • Search forms
  • Macros
  • Design view
  • Test and finalise database

Unit 2 - Operate database applications Using Access 2013

  • 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



  • Professional development that is widely recognised and respected;
  • Improve your employment opportunities;
  • Study online, anywhere via our elearning system;
  • High-quality professional development programs written by industry experts;
  • No entry requirements;
  • All course materials provided online – no textbooks to buy;
  • Unlimited tutor support;
  • Easy to understand course content;
  • 12 months’ access. Free extensions may be available upon application.
  • Certificate of Attainment/Completion issued for your CV (hard copy provided); and
  • Course may be tax deductible; see your tax advisor.
SKU: C500118 Category:
  • Includes 12 months access
  • Full up-front payment only