Microsoft Courses

Short Courses

Microsoft Access 2013 Advanced Short Course

This course builds upon basic Microsoft Access skills to help students become power users. In this advanced Microsoft Access 2013 course, students will delve deeper into the program by studying a dozen different topics. The aim of this course is to give students a grasp of the tools they need to exploit the high-level user skills of this software. Over the course of a dozen modules learners are introduced to many vital skills they can use to maximise the softwares capabilities

What does the Microsoft Access 2013 Advanced Course include?
  • A comprehensive training manual
  • Exercise files
  • Case studies
  • Skill sharpener exercises
  • Quick reference guide
  • 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.

Modules in this course cover how to manage data and data entry; create forms, macros, and dialog boxes; create and use SQL queries; split databases; and much more.

The skills and knowledge acquired in this course are sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.

At the completion of this course you should be able to:
  • SQL and Microsoft Access
  • Use the SELECT Statement
  • Use SQL Joins
  • Use Subqueries 
  • Work with Advanced Form Tasks 
  • Create Split Forms
  • Use Digital Signatures
  • Use the Trust Centre
  • Managing COM Add-ins
  • Customising Access 
This Microsoft Access 2013 course assumes a strong knowledge of the software. It is important that the student has at least completed a course to the level of the TBST Microsoft Access 2013 Intermediate course.

Course Information

  • Learning Outcomes
    SQL and Microsoft Access - This introductory module teaches students all about SQL and Access. Covered here is SQL, SQL statements and naming conventions, as well as SQL syntax.

    Using the SELECT Statement - The SELECT statement is used to find and display specific values from a set of data. It is very powerful, especially when used correctly. This module gives learners insight into selecting all data, selecting specific data, selecting conditional data, and using the ORDER BY statement.

    Using SQL Joins - Joins are used to combine data from separate tables. This module lets students learn how to create simple joins, use an alias, sort joins, and create outer joins.
     
    Using Subqueries - A subquery is a SELECT statement nested in another statement or subquery. Usually, subqueries are used to return data that will be used in the main query as a condition to help narrow down the data that is being retrieved. This module teaches students what subqueries are, how to create a subquery, how to create subqueries with aggregate functions and nested subqueries, and use the IN keyword with subqueries.
     
    Advanced Form Tasks, Part One, Two & Three - This is the first of three modules that looks at advanced form tasks, including limiting user access to a form, creating checkboxes and command buttons, building command button events, and creating event procedures. Picking up where the previous module left off, this module continues the study of advanced form tasks. It looks at how to use hyperlinks in a form, how to add links to other database objects, how to insert a mailto link into a form, how to add a browser control to a form, and how to perform calculations in a form. The third instalment of this trilogy wraps up the riveting story of advanced form tasks. Here your students will learn how to export a form to XML, how to export a form as a Word document, how to export a form as HTML, how to send a form as an e-mail attachment, and how to export a form to other formats.
     
    Creating Split Forms - A split form is designed to give a user two views of data simultaneously. This module endows learners with the insight, skills, and tools to embrace this aspect of Access 2013. Learners will come away from this module knowing how to: create a split form, split an existing form, use a split form, and fix the form separator in place.
     
    Using Digital Signatures - A digital signature ensures that a digital file is authentic and provides information on who created it and if it has been altered in any way. This module teaches what a digital signature is, how to obtain a digital signature, how to attach a signature to a database, and how to remove a signature from a database.
     
    Using the Trust Centre - The Trust Centre is where you can find all of the security and privacy settings for Microsoft Office programs. This module advises students how to open the Trust Centre, how to trust a database, how to configure macro security, and how to customise the Message Bar.
     
    Managing COM Add-ins - Add-ins are small programs you can install and enable to add custom commands and new features to Access 2013. How to view add-ins; how to open the Add-in Manager; and how to install, disable, and uninstall add-ins.
     
    Customising Access - Students will be introduced to the skills that will allow them to change user information, change the Office background and theme, and change the default database type and location.
  • Pricing

    Microsoft Online Short Courses 

    Course Price -  $195 Microsoft Access 2013 Advanced

    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 submit your assessments as and 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
    • Quick reference guide
    • Assessments
     
    Students are able to work through the short course at their own pace.

     

  • Prerequisites

    This Microsoft Access 2013 course assumes a strong knowledge of the software. It is important that the student has at least completed a course to the level of the TBST Microsoft Access 2013 Intermediate course.

    • 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
    Module 1: SQL and Microsoft Access
    What is SQL?
    What is an SQL Statement?
    What is an SQL Naming Convention?
    What is SQL Syntax?
     
    Module 2: Using the SELECT Statement
    Selecting All Data
    Selecting Specific Data
    Selecting Conditional Data
    Using the ORDER BY Statement
     
    Module 3: Using SQL Joins
    Creating Simple Joins
    Using an Alias
    Sorting Joins
    Creating Outer Joins
     
    Module 4: Using Subqueries
    What is a Subquery?
    Creating a Subquery
    Subqueries with Aggregate Functions and Nested Subqueries
    Using the IN Keyword with Subqueries
     
    Module 5: Advanced Form Tasks, Part One
    Limiting User Access to a Form
    Creating Checkboxes and Command Buttons
    Building Command Button Events
    Creating Event Procedures
     
    Module 6: Advanced Form Tasks, Part Two
    Using Hyperlinks in a Form
    Adding Links to Other Database Objects
    Inserting a Mailto Link in a Form
    Adding a Browser Control to a Form
    Performing Calculations in a Form
     
    Module 7: Advanced Form Tasks, Part Three
    Exporting Your Form to XML
    Exporting a Form as a Word Document
    Exporting a Form as HTML
    Sending a Form as an E-mail Attachment
    Exporting a Form to Other Formats
     
    Module 8: Creating Split Forms
    Creating a Split Form
    Splitting an Existing Form
    Using a Split Form
    Fixing the Form Separator
     
    Module 9: Using Digital Signatures
    What is a Digital Signature?
    Obtaining a Digital Signature
    Attaching Your Signature to a Database
    Extract and Use a Signed Database
     
    Module 10: Using the Trust Centre
    Opening the Trust Centre
    Trusting a Database
    Configuring Macro Security
    Customising the Message Bar
     
    Module 11: Managing COM Add-ins
    Viewing Add-ins
    Opening the Add-in Manager
    Installing Add-ins
    Disabling All Add-ins
    Uninstalling Add-ins
     
    Module 12: Customising Access
    Changing User Information
    Changing the Office Background and Theme
    Setting the Default Database Type and Location
  • 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.