Microsoft Courses

Short Courses

Microsoft Access 2013 Intermediate Short Course

This course builds upon basic Microsoft Access skills to help students become power users. In this course, students will delve deeper into the program by studying a dozen different topics. 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.

What does the Microsoft Access 2013 Intermediate 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.
 
At the completion of this course you should be able to:
  • Understand how Access is used and how to Managing Data 
  • Use Advanced Table Tasks 
  • Managing Data Entry in Tables
  • Creating Subforms 
  • Creating Navigation Forms 
  • Advanced Query Tasks 
  • Creating Modal Dialog Boxes 
  • Splitting the Database 
  • Creating Basic Macros 
  • Advanced Macro Tasks
  • Using Visual Basic for Applications 
This Microsoft Access 2013 course assumes confident knowledge of the software or at least have complete the Foundation Level of this course previously.

Course Information

  • Learning Outcomes

    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. 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.

    Managing Data - This opening module will show students how to view relationships, view object dependencies, enforce referential integrity, and enforce cascade update and delete. Students also will learn about types of relationships and referential integrity.
     
    Advanced Table Tasks - In this module, students are shown how to insert application parts, use the Table Analyser Wizard, create validation rules, and configure validation messages.
     
    Managing Data Entry in Tables - In this module, topics include how to mark fields as required, mark a field for indexing, create lookup fields, create value lists, and create input masks.
     
    Creating Subforms - This module covers how to create and use subforms, link subforms with parent forms, and format a subform within a main form.
     
    Creating Navigation Forms - Next, students are shown how to create a navigation form and add tabs to it, create a tab hierarchy in a navigation form, and automatically display a navigation form when the database opens.
     
    Advanced Query Tasks - This module will give students the answers about queries. Topics covered include how to create SQL queries, use the Expression Builder, create SQL statements, and use SQL keywords.
     
    Creating Modal Dialog Boxes - Modal dialog boxes get a thorough look in this module. Topics include how to create, format, and modify a modal dialog box.
     
    Splitting the Database - When dealing with databases, it’s a good idea to have tools to manipulate them effectively. This module takes a look at how to back up a database, split a database, configure Access 2013 for a multi-user database, and set record locking options.
     
    Using Access with SharePoint Server - SharePoint Server meshes well with Access 2013 and this module takes advantage of that relationship. Students will learn how to link tables to lists, move a database to SharePoint, save a database to SharePoint, and use Access web apps.
     
    Creating Basic Macros - This module shows students how to create a standalone macro, use the Action Catalog, add comments to macros, use If-Then actions, and handle macro errors.
     
    Advanced Macro Tasks - Next, students will learn how to create event procedures, data macros, and submacros.
     
    Using Visual Basic for Applications - The final module in this course explores how to use Visual Basic for Applications. Students will learn how to convert a macro to Visual Basic, use Visual Basic for Applications, use modules, and build Visual Basic procedures.
  • Pricing

    Microsoft Online Short Courses 

    Course Price -  $195 Microsoft Access 2013 Intermediate

    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 confident knowledge of the software or at least have complete the Foundation level of this course previously.

    • 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: Managing Data
    Types of Relationships
    Viewing Relationships
    Viewing Object Dependencies
    What is Referential Integrity?
    Enforcing Referential Integrity
    Using Cascade Delete and Cascade Update
    Review Questions
     
    Module 2: Advanced Table Tasks
    Inserting Application Parts
    Using the Table Analyser Wizard
    Creating Validation Rules
    Configuring Validation Messages
    Review Questions
     
    Module 3: Managing Data Entry in Tables
    Marking Fields as Required
    Marking a Field for Indexing
    Creating Lookup Fields
    Creating Value Lists
    Creating Input Masks
    Review Questions
     
    Module 4: Creating Subforms
    Creating Subforms
    Using Subforms
    Linking Subforms with Parent Forms
    Formatting a Subform within a Main Form
    Review Questions
     
    Module 5: Creating Navigation Forms
    Creating a Navigation Form
    Adding Tabs to a Navigation Form
    Creating a Tab Hierarchy
    Displaying the Navigation Form when the Database Opens
    Review Questions
     
    Module 6: Advanced Query Tasks
    Understanding SQL Statements
    Basic SQL Keywords
    Creating SQL Queries
    Using the Expression Builder
    Review Questions
     
    Module 7: Creating Modal Dialog Boxes
    Creating a Modal Dialog Box
    Adding Controls
    Setting Properties
    Formatting a Modal Dialog Box
    Review Questions
     
    Module 8: Splitting the Database
    Backing Up the Database
    Splitting the Database
    Configuring Access 2013 for a Multi-User Database
    Setting Record Locking Options
    Review Questions
     
    Module 9: Using Access with SharePoint Server
    Linking Tables and Lists
    Moving a Database to SharePoint
    Saving a Database to SharePoint
    About Access Web Apps
    Review Questions
     
    Module 10: Creating Basic Macros
    Creating a Standalone Macro
    Using the Action Catalog
    Adding Comments to Macros
    Using If-Then Actions
    Handling Macro Errors
    Review Questions
     
    Module 11: Advanced Macro Tasks
    Creating Event Procedures
    Creating Data Macros
    Creating Submacros
    Grouping Submacros
    Review Questions
     
    Module 12: Using Visual Basic for Applications
    Converting a Macro to Visual Basic
    Using Visual Basic for Applications
    Understanding Modules
    Building Visual Basic Procedures
    Review Questions
  • 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.