Access Training Courses

Over 2,856 students trained and counting.

(4.24 out of 5)

About Microsoft Access Icon About Microsoft Access:

Microsoft Access is a DBMS (Database Management System) or a collection of information that is very useful and simple to use. Each updated version of Microsoft Access allows you to understand and familiarise with the objects in the application, such as tables, forms, queries and many more. By learning how Access works, you will be able to track customer orders or even maintain your personal collection and track information from a variety of sources which can be very helpful in a business world.

Which Access Version Icon Which Access are you?

Skills Covered:

  • Orientation to Microsoft Access
  • Create a simple database
  • Modify table data
  • Sort and filter records
  • Query a database
  • Create parameter, action, unmatched and duplicate queries
  • Create a report
  • Add controls and enhance the appearance of a report

Skills Covered:

  • Design a relational database
  • Create a table and table relationships
  • Join tables and relate data within a table
  • Improve table structure
  • Import data into Access
  • Export data to access and text formats
  • Create a mail merge
  • Organise and format reports

Skills Covered:

  • Orientation to Microsoft Access
  • Create a simple database
  • Modify table data
  • Sort and filter records
  • Query a database
  • Create parameter, action, unmatched and duplicate queries
  • Create a report
  • Add controls and enhance the appearance of a report

Skills Covered:

  • Design a relational database
  • Create a table and table relationships
  • Join tables and relate data within a table
  • Improve table structure
  • Import data into Access
  • Export data to access and text formats
  • Create a mail merge
  • Organise and format reports

Skills Covered:

  • Create a new database
  • Add and manage tables
  • Sort and filter records
  • Create and add criteria to a query
  • Add controls and format a report
  • Establish data entry formats
  • Create query joins & action queries
  • Create a subform
  • Organise and format reports
  • Importing & Exporting data

Skills Covered:

  • Add controls to forms and create subforms
  • Field and record validation
  • Create a macro and convert a macro to VBA
  • Validate and automate data using a macro
  • Manage and document a database
  • Analyse the performance of a database
  • Implement security and set passwords
  • Create and modify a database switchboard

Skills Covered:

  • Import XML data into an Access database
  • Export data to XML format and Outlook address book
  • Call and run a procedure from a form
  • Create and modify a database switchboard
  • Implement security and set passwords
  • Packaging databases
  • Share databases using SharePoint

Skills Covered:

  • Create a new database and table
  • Manage tables and modify table data
  • Create a query and add criteria to a query
  • Create and format a form
  • Generate a report
  • Add controls and format a report
  • Create query joins, parameter and action queries
  • Organise and format reports
  • Import and export data in Access

Skills Covered:

  • Analyse tables and improve table structure
  • Create subqueries, unmatched and duplicate queries
  • Create a PivotTable & PivotChart
  • Validate and automate data using a macro
  • Display a calendar and a summary of data in a form
  • Include a chart in a report
  • Link tables to external data sources
  • Manage and document a database

Skills Covered:

  • Explore and customise the user interface
  • Work with the ribbon and contextual tabs
  • Create tables and forms
  • Query a database
  • Generate and format reports
  • Import and export data

Access Training Delivery Options Icon Training Delivery Options:

New Horizons offers the following training modalities for Microsoft Access courses:

Accreditations Icon Accreditations:

Registered Training Provider Logo

What is included in your Access Training What’s included in your training:

  • Access to a Learning Solutions Advisor to discuss training requirement
  • Hands-on training delivered by Microsoft Certified Trainers
  • Printed courseware material in line with Microsoft Office specialisation requirements
  • Access to post course online course content
  • Access to a 60-day post course helpdesk support service
  • 6-month free course repeat/refresher option

Top reasons to choose New Horizons Icon Top 5 reasons to choose New Horizons:

    • Over the past 18 years (since June 1998), we have trained more than 2,856 Access professionals Australia wide.
    • We have been training Microsoft Access courses since 1995 globally.
    • Our Access instructors hold the Microsoft Office Specialist (MOS) certification.
    • Over 98% of our students would recommend us for training.
    • We are a Microsoft Gold Certified Partner.
      • We are an Australian Registered Training Organisation (RTO).
      • Every year we look after Access training needs of more than 159 business professionals working in the private and public sectors.
      • Our Access instructors are certified by Microsoft.
      • We offer a variety of training delivery options to help meet your learning and business requirements (See below for details).

Our Access Instructor Icon Meet our Access instructors:

Access upgrade Icon Stress free upgrades/rollouts:

The success of a technology upgrade/rollout goes hand-in-hand with the effectiveness of the skills development plan for the people involved. Over the past 18 years, New Horizons has helped over 1323 organisations make a smooth and successful transition to the latest version of Access through our detailed pre-training skills gap analysis, flexible training delivery options and post course learning support. Call 1300 794 006 to learn more.

top