Microsoft Courses

Short Courses

Microsoft Access 2016 Foundation Short Course

Microsoft Access 2016 is Microsoft’s flagship database application that allows you to create and manage databases for all sorts of different purposes.
This new version of Access incorporates a few new features and connectivity options in order to make databases more accessible to the everyday user.

This course is intended to help all novice computer users get up to speed quickly. This manual will also help more experienced users who have little to
no experience with Microsoft Access and databases in general. By the end of this course, users should be comfortable with navigating the Access 2016
interface, creating a new database from scratch, querying a database, generating reports, sharing data, and much more.

What does the Microsoft Access 2013 Fundamentals Course include?

A comprehensive training manual

Exercise files

Case studies

Skill sharpener exercises

Assessments

The course is delivered via self paced flexible distance learning which means we provide you with everything you need to study the course via our online
training system and there is no classroom attendance required. Students are able to work through the short course at their own pace.

This course is organised into sections. Each section focuses on several key topics, each of which are broken down into easy-to-follow concepts.
At the end of each topic, you will be given an activity to complete. At the end of each lesson, we will summarise what has been covered and
provide a few review questions for you to answer.

At the completion of this course you should be able to:

Getting Started with Access

Working with Table Data

Querying a Database

Creating Advanced Queries

Generating Reports

Customising the Access Environment

Designing a Relational Database

Joining Tables

Organising a Database for Efficiency

Sharing Data Across Applications

Advanced Reporting

Additional Reporting Options

This course assumes little or no knowledge of Microsoft Word 2013. However, it would be beneficial to have a general understanding of personal computers
and the operating system environment, especially in regard to working with files and folders.

Course Information

Access is Microsoft’s flagship database application that allows you to create and manage databases for all sorts of different purposes. This new version
of Access incorporates a few new features and connectivity options in order to make databases more accessible to the everyday user. This course is
intended to help all novice computer users get up to speed quickly. It will also help more experienced users who have little to no experience with
Microsoft Access and databases in general.

Getting Started with Access

In the first lesson, students will learn how to orient themselves with Microsoft Access 2016, create a simple Access database, and get help in Microsoft
Access.

Working with Table Data

Next, students will learn how to modify table data, work with, sort and filter records, and how to create lookups.

Querying a Database

This lesson covers how to join data from different tables in a query, sort and filter data in a query, and perform calculations in a query.

Creating Advanced Queries

In this lesson, students will learn how to create parameter queries, action queries, unmatched queries, and duplicate queries. They will also learn how
to summarise data with queries.

Generating Reports

Creating reports, adding controls to a report, enhancing the appearance of a report, and preparing a report for print are all covered in this lesson.

You work through the Training Manual at your own pace and complete the quizzes when you are ready. This allows you to progress through the course at a
pace that suits your needs. You have 12 months in which to submit your assessments for marking.

Students engage in and complete their short course training via our TBST Learning Management System - LMS

Our online Learning Management System - LMS - provides students with a more streamlined method of working through their courses by allowing students
to login and access all current course files in the one universal location. The LMS has been designed so that students can work through course
units in chronological order. Students will always have access to the most up-to-date course content and all updates to course content will be
distributed to all students immediately via the LMS.

This manual assumes that the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and
Start menu. Students should also be comfortable navigating their computer in order to create and manage files and folders. Understanding and experience
with printing and using a web browser is an asset, but not required. No previous experience with other versions of Microsoft Access is necessary.

Basic Microsoft Office skills

Access to the Microsoft Office 2013 suite of programs (either PC or Macintosh).

Course enrolments can commence at any time after the enrolment process is completed.

This course is a self paced distance learning training course. Students have 12 months to complete the training. Students work through the workbook, practice
the material learnt and then complete the assessments.

Due to the flexibility there is a lower drop out rate thus saving students time and money invested in their desired outcomes. In addition, flexible adult
learning encourages students to continue the course at their own pace without restrictions as to when and how they complete the course.

Therefore, students are able to continue their life roles and incorporate their study into time slots that suit their lifestyles. This also allows those
that are working either as an employee, subcontractor or owner/operator to continue to earn money or charge for billable hours, which further serve
to reduce the ʻrealʼ course costs. Students have 12 months in which to complete all of their assessments.

Microsoft Short Course Enrolment Form

Whether your creating professional-looking presentations, working on spreadsheets, or word processing, Microsoft Office allows you to open,
save, modify, or collaborate on documents in the cloud, so you can maximise efficiencies & do great work anywhere, anytime.