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

  • Learning Outcomes

    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.
    Customising the Access Environment
    Next, students will learn about the Access Options dialog box.
     
    Designing a Relational Database
    This lesson covers relational database design, creating a table, managing table fields, and creating table relationships.
     
    Joining Tables
    Creating query joins, joining tables that have no common fields, relating data within a table, working with sub-datasheets, and creating subqueries will be covered in this lesson.
     
    Organising a Database for Efficiency
    In this lesson, students will learn about data normalisation and how to create a junction table.
     
    Sharing Data Across Applications
    Next, importing data into Access, exporting Access data to text file formats, exporting Access data to Excel, and creating a mail merge will be covered.
     
    Advanced Reporting
    This lesson covers how to organise report information, format reports, include charts in a report, add a calculated field to a report, and add a sub-report to an existing report.
    Additional Reporting Options
    In the final lesson, how to create a mailing label report and how to publish a report as a PDF will be covered.

     

  • Pricing

    Microsoft Online Short Courses 

    Course Price -  $195 Microsoft Access 2016 Foundation

    Payment Options - Invoice. Direct Deposit, Visa MasterCard and American Express.

    Please note that Visa & MasterCard attract a 1.5% surcharge & American Express attracts a 2.5% surcharge

    Multiple courses can be enrolled into.

  • Assessments

    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.

  • Requirements

    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.

    The LMS includes:
    • TBST Administration Documents
    • A comprehensive training manual
    • Exercise files
    • Case studies
    • Skill sharpener exercises
    • Assessments
    Students are able to work through the short course at their own pace.
  • Prerequisites

    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).
    • A basic calculator and stationery
    • PC or Mac – minimum system requirements & loaded with current versions of: Quicktime, Adobe Reader & access to the internet & email programs.
    • Please read and understand the TBST Student Handbook
    • Please read and understand the Policies and Procedures contained in the TBST Student Handbook
     
  • Recommended follow up / prior courses
    Microsoft Excel 2013 Short Courses
    Microsoft Excel 2016 Short Courses
    Microsoft Word 2013 Short Courses
    Microsoft Word 2016 Short Courses
    Microsoft Access 2016 Short Courses
    Microsoft PowerPoint 2016 Short Courses
     
    MYOB Training Courses
    MYOB Fundamentals
    MYOB Payroll
    MYOB Advanced

  • Units of Study

    See the Unit Description Page for a full course overview.

    Lesson 1: Getting Started with Access
    Topic A: Orientation to Microsoft Access
    Topic B: Create a Simple Access Database
    Topic C: Get Help in Microsoft Access
     
    Lesson 2: Working with Table Data
    Topic A: Modify Table Data
    Topic B: Work with Records
    Topic C: Sort and Filter Records
    Topic D: Create Lookups
     
    Lesson 3: Querying a Database
    Topic A: Join Data from Different Tables in a Query
    Topic B: Sort and Filter Data in a Query
    Topic C: Perform Calculations in a Query
     
    Lesson 4: Creating Advanced Queries
    Topic A: Create Parameter Queries
    Topic B: Create Action Queries
    Topic C: Create Find Duplicate and Find Unmatched Queries
    Topic D: Summarise Data
     
    Lesson 5: Generating Reports
    Topic A: Create a Report
    Topic B: Add Controls to a Report
    Topic C: Enhance the Appearance of a Report
    Topic D: Prepare a Report for Print
     
    Lesson 6: Customising the Access Environment
    Topic A: The Access Options Dialog Box
     
    Lesson 7: Designing a Relational Database
    Topic A: Relational Database Design
    Topic B: Create a Table
    Topic C: Modify a Table and Fields
    Topic D: Create Table Relationships
     
    Lesson 8: Joining Tables
    Topic A: Create Query Joins
    Topic B: Join Tables That Have No Common Fields
    Topic C: Relate Data within a Table
    Topic D: Work with Subdatasheets
    Topic E: Create Subqueries
     
    Lesson 9: Organising a Database for Efficiency
    Topic A: Data Normalisation
    Topic B: Create a Junction Table
     
    Lesson 10: Sharing Data Across Applications
    Topic A: Import Data into Access
    Topic B: Export Data to Text File Formats
    Topic C: Export Access Data to Excel
    Topic D: Create a Mail Merge
     
    Lesson 11: Advanced Reporting
    Topic A: Organise Report Information
    Topic B: Format Reports
    Topic C: Include Charts in a Report
    Topic D: Add a Calculated Field to a Report
    Topic E: Add a Subreport to an Existing Report
     
    Lesson 12: Additional Reporting Options
    Topic A: Create a Mailing Label Report
    Topic B: Publish a Report as PDF

     

  • Course Commencement

    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

TBST offers powerful short course training opportunities in both Microsoft Office 2013 & 2016.

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.

Short course online training is a powerful way to learn.

TBST's Available Courses

Browse our range of government funded, fee paying and MYOB courses.