Corporate Microsoft Access Training Onsite

Tailored Microsoft Access Training at your Workplace in Sydney, Melbourne, Perth, Brisbane
Get a Quote

Corporate Microsoft Access Training in the Workplace

We offer professional onsite Microsoft Access training for teams and individuals from beginner to advanced level. We help users to understand how to design databases with a no jargon approach. Our onsite Access training solutions give you the benefit of cost effective training courses with tailored content.

access course sydney

Credible

Our live online reviews are proof that you can trust Trainers Direct to deliver

Flexible

Our tailored training workshops are completely flexible to fit in with your busy schedule

Z

Experienced

Our instructors have a minimum of 15 years industry experience and carry relevant vendor qualifications such as Microsoft or Adobe Certified 

Level 1 - Access Queries and Report Writing for End Users - 1 Day

Access Course for End Users

This course will help users to understand how to effectively write queries and run reports using an existing Access Database.

  • Add and append data to existing tables
  • Modify the design of a table, form or report
  • Add new fields
  • Use Sort, Find and Filter
  • Use Filter by Form
  • Design select queries
  • Learn how to specify criteria in a query
  • Design parameter queries to prompt the user to input data
  • Create calculated fields in queries to perform calculations on data
  • Design reports
Level 2 - An Introduction to Access Database Design - 1 Day

Access Course Covering Database Design Basics

  • Overview, the QAT and Ribbon
  • Database concepts and design
  • Creating tables, data types, field properties and data entry
  • Filtering and sorting data
  • Creating select queries for extracting data
  • Designing forms
  • Printed reports
Level 3 - Intermediate/Advanced Access Database Design - 1 Day

Access Course Covering Intermediate Design Concepts

  • Creating a relational database
  • Understanding and creating table relationships
  • Action queries
  • Crosstab queries
  • Multi table forms
  • Tab forms
  • Form Controls and properties
  • Sub forms and sub reports
  • Simple macros and buttons
  • Mail merge
  • User Interface
  • Macros
  • Lists
  • Object oriented programming and modules control sources
  • Debugging  Functions
Bespoke
Combine topics to create your own tailor made training course or create your own advanced course outline. Ask about our free training needs analysis for a truly relevant and hands on learning experience.

FIND US

 

Level 3, Suite 2, 828 Pacific Hwy, Gordon NSW 2072

02 9454 7702

Privacy