Microsoft Courses

Short Courses

Microsoft Access 2013 Foundation Short Course

This Microsoft Access 2013 course covers the skills that students will need to make the most of Microsoft Access 2013. The course begins with the basics and progresses through several modules which cover databases, tables and records, forms, reports, queries, and much more. 

What does the Microsoft Access 2013 Fundamentals 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.
 

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:
  • Understand how Access is used and how to navigate around it
  • Design a database with lookup tables
  • Create a database structure using Access 2013
  • Modify the structure of an existing table
  • Add records to a new table
  • Add transactional records to a lookup database
  • Work with the records in a database table
  • Sort and filter records in a table
  • Create simple and effective queries
  • Create meaningful reports from tables
  • Create and use forms 
This Microsoft Access 2013 course assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Course Information

  • Learning Outcomes

    The Basics - The course begins with a look at how to get started with Access, create and save a database, and open an existing database. Then, participants will learn how to sign into Office with a Microsoft account. The module also includes information on database terminology.

    Your First Database - This module discusses how to search for objects along with how to open various database objects. Students will also learn how to change object views and how to manage objects. Also included is information on security warnings and data relationships.
     
    Working with Tables and Records - The third module takes a look at tables and records. Here, students will learn to create a table, add and edit database records, search and browse records, and delete and print records. How to make the most of different table views is covered here as well.
     
    Formatting Tables - Delving deeper into tables is the focus of this module. In it, students will learn to select data, change the size of rows and columns, apply text formatting and fill colour, apply gridlines, and perform a spell check.
     
    Creating Forms - Forms are the topic discussed here. This module begins with the steps to create forms from an object. It then proceeds to looking at creating forms using the wizard. Students will also learn to create forms from scratch and how to use form views.
     
    Formatting Forms - The look at forms continues in this module. Students will start the module by learning how to change the theme of a form. Also covered is how to use the Format Painter, add fields to a form, and add controls and images to a form.
     
    Creating Reports - Reports are the focus of this particular module. First, students are shown how to create a report from an object and by using the wizard. Students will also learn how to create a report from scratch, use report views, and print reports.
     
    
Formatting Reports - Information on reports is continued here with a look at how to change the theme of reports, use the Format Painter, and group and sort data in reports. The module also covers adding controls, images, logos, page numbers, headers, and footers to reports.
     
    Creating Basic Queries - This module allows students to develop skills on queries. They will learn how to create a query with the wizard, run a query, sort and filter a query, and use and apply query views. Students will also learn about the types of queries that are available.
     
    Creating Advanced Queries - Getting a more in-depth look at queries is the goal of this module. Students will learn how to use parameter queries, multiple table queries, crosstab queries, make-table queries, append queries, delete queries, and update queries.
     
    Managing Your Database - In this module, students will learn to compact and repair a database and encrypt a database using a password. Students are also shown how to back up a database, export a database and database objects, and print database objects.
     
    Customising the Interface - This final module looks at the interface and tips for customising it. Students are shown how to collapse and pin the ribbon, customise the Quick Access toolbar, hide and show ribbon tabs, create custom tabs, and reset changes made to the interface.
  • Pricing

    Microsoft Online Short Courses 

    Course Price -  $195 Microsoft Access 2013 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 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 little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

    • 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: The Basics
    Getting Started
    Signing In
    Creating a Database
    Database Terminology
    Saving a Database
    Opening a Database
     
    Module 2: Your First Database
    About Security Warnings
    About Relationships
    Searching for Objects
    Opening Database Objects
    Changing the Object View
    Understanding the Types of Views Available
    Managing Objects
     
    Module 3: Working with Tables and Records
    Creating a Table
    Understanding Table Views
    Adding and Editing Records
    Searching and Browsing Records
    Deleting Records
    Printing Records
     
    Module 4: Formatting Tables
    Selecting Data43
    Changing Column and Row Width and Height
    Applying Text Formatting
    Applying Gridlines
    Changing Fill Colours
    Checking Your Spelling
     
    Module 5: Creating Forms
    Creating a Form from an Object
    Creating a Form with the Wizard
    Creating a Form from Scratch
    Understanding Form Views
    Using a Form
     
    Module 6: Formatting Forms
    Understanding Bound and Unbound Controls
    Changing the Theme
    Using the Format Painter
    Adding Fields
    Adding Controls
    Adding Images and Logos
     
    Module 7: Creating Reports
    Creating a Report from an Object
    Creating a Report with the Wizard
    Creating a Report from Scratch
    Understanding Report Views
    Printing Reports
     
    Module 8: Formatting Reports
    Changing the Theme
    Using the Format Painter
    Grouping and Sorting Data
    Adding Controls
    Adding Images and Logos
    Adding Page Numbers, Headers, and Footers
     
    Module 9: Creating Basic Queries
    Types of Queries
    Creating a Query with the Wizard
    Running a Query
    Understanding Query Views
    Sorting and Filtering a Query
     
    Module 10: Creating Advanced Queries
    Creating and Using Parameter Queries
    Creating and Using Cross tab Queries
    Creating and Using Make-Table Queries
    Creating and Using Multiple Table Queries
    Creating and Using Append Queries
    Creating and Using Delete Queries
    Creating and Using Update Queries
     
    Module 11: Managing Your Database
    Compacting and Repairing a Database
    Encrypting a Database with a Password
    Backing Up Your Database
    Exporting a Database and Database Objects
    Printing Database Objects
     
    Module 12: Customising the Interface
    Collapsing and Pinning the Ribbon
    Customising the Quick Access Toolbar
    Hiding and Showing Ribbon Tabs
    Creating Custom Ribbon Tabs
    Resetting Interface Changes
     
  • 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.