• View Cart
  • Trainer Login
  • Customer Login
  • 1300 667 660
Corporate Training Options
Menu
  • Home
  • Courses
    • Corporate Training
    • Computer Training
    • Online Training
  • Live Events
  • News
  • Success Stories
    • Testimonials
    • Business Case Studies
  • About
    • Meet the Team
    • FAQ’s
    • Careers
Home > Courses > Modern Workplace Technology > Microsoft 365 Training > Microsoft Access > Microsoft Access – Intermediate

Microsoft Access – Intermediate

  • Overview
  • Course details
  • Level
  • Outcomes
  • Success Program
  •  

Overview:

The skills and knowledge covered in this course include ensuring that data is entered correctly, how to create more sophisticated and complex queries, and is introduced to some basic automation techniques involving macros. The course covers the following:

  • Data validation
  • Formatting tables
  • Querying techniques
  • Parameter queries
  • Calculations in queries
  • Modifying forms
  • Using a navigation form
  • DIY forms
  • Creating and using macros
  • Macro techniques
  • Macros on forms
  • Navigation pane protection

Course Details:

Target Audience:

This course is primarily designed for people who have an understanding of how tables are created, records are entered, modified and deleted, and how simple queries, reports and forms are created.

Duration: 1 Day

  Microsoft Access 2016 - Intermediate - Download the course outline in PDF Format   Microsoft Access 2013 - Intermediate - Download the course outline in PDF Format   Microsoft Access 2010 - Intermediate - Download the course outline in PDF Format

Level:

This course covers Microsoft Access at the Intermediate level.

 

Related Course:

  • Microsoft Access - Advanced
  • Microsoft Access - Introduction

Learning Outcomes:

At the completion of this course participants will be able to:

  • Use various data validation features in Access to protect data
  • Format the data in a table
  • Perform more advanced queries using a variety of querying techniques
  • Create and use parameter queries
  • Create calculated queries
  • Modify and adapt an existing form according to specific needs
  • Create a navigation form for a database in Access
  • Create forms using a combination of wizards and manual techniques
  • Create and use macros in Access
  • Work with a number of macro techniques
  • Create and work with macros in forms
  • Create and manage custom categories and groups in the Navigation Pane

Introduction to Microsoft Access – Intermediate –  Online Training 

Online Training  –  Online Private Workshops

You can book private, customised, online training for your team.  To do this, please click on the Book Online Training  button on this page.

The Introduction to Microsoft Access – Intermediate Online Workshops are presented by a CTO Facilitator, in a live virtual classroom.

 

Prices:

Trainees Price
1-3 trainees $1,650 per day
4-8 trainees $1,980 per day
Each additional trainee $154 per day

Click here to Request a Quote

  Get A Quote   Book Onsite Training   Book Online Training

REQUEST A QUOTE BOOK NOW

Internal Links

  • Home
  • About CTO
  • Services
  • Courses
  • Become a Trainer
  • News
  • Contact Us

Secure Payment

Locations

  • Canberra
  • Sydney
  • Melbourne
  • Brisbane
  • Gold Coast
  • Perth
  • Adelaide
  • Hobart
  • Darwin
  • New Zealand
  • United Kingdom
  • USA
  • Canada

Sign Up to our Newsletter

  • This field is for validation purposes and should be left unchanged.

Connect with us

Privacy Policy | Terms & Conditions | Refund Policy | Disclaimer

Sitemap | Copyright © 2017 | All rights reserved. | SEO and Gold Coast Web Design by: Visual Marketing