HomeCoursesDesktop ApplicationsBrowse by Product > Microsoft Access

What's included in your Training

 
  • 6 months free course repeats
  • 6 months online access to eLearning course content
  • 60 day post course help-desk support
 

Why choose New Horizons

 
  • New Horizons is a Registered Training Organisation (RTO)
  • New Horizons employs vendor certified and industry experienced trainers which ensures clients receive training from qualified instructors
  • Centrally located facilities in the heart of the CBD

    Click here for more reasons to choose New Horizons.
 

Stress free upgrades

  New Horizons has extensive experience in helping organisations ensure a smooth Office upgrade by providing employees with the skills they require to maintain workplace productivity.

Call 1300 794 006 to find out more. 
 
> Download our Microsoft Office Upgrade and Rollouts Guide
 

Flexible Delivery Options

  New Horizons offers the following training delivery options for Microsoft Access courses: 
 
 

Access Training Courses

Access 2013 - Level 1

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
  • Use the Access options dialog box

Access 2013 - Level 2

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

Access 2010 - Level 1

SKILLS COVERED:

  • Explore the Access interface
  • Create a new database
  • Add and manage tables
  • Sort and filter records
  • Work with subdatasheets
  • Create a query and add criteria to a query
  • Create and format a form
  • Generate a report
  • Add controls and format a report
  • Constrain data entry and establish data entry formats
  • Create query joins and action queries
  • Add a command button to a form
  • Create a subform
  • Organise and format reports
  • Create a mailing label report and mail merge
  • Import data into Access
  • Export data to Excel and text files

Access 2010 - Level 2

SKILLS COVERED:

  • Restructure data in a table
  • Improve table structure
  • Create subqueries, unmatched and duplicate queries
  • Create a PivotTable and a PivotChart
  • Create and attach a macro
  • Validate and automate data using a macro
  • Include a chart in a report
  • Link tables to external data sources
  • Manage and document a database

Access 2010 - Level 3

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
  • Package a database with a digital signature
  • Share databases using a SharePoint site

Access 2010: Transition from Access 2003

SKILLS COVERED:

  • Explore the interface elements
  • Use contextual tabs and commands on the ribbon tabs
  • Create a table
  • Work with macros
  • Query a database
  • Generate and format a report
  • Import data
  • Export data to other applications
  • Create tables, forms, queries and reports in a web database

Access 2007 - Level 1

SKILLS COVERED:

  • Explore the Access interface and ribbon
  • Customise the Access environment
  • Define database purpose
  • Create a new database and table
  • Manage tables and modify table data
  • Sort and filter records
  • Work with subdatasheets
  • Create a query and add criteria to a query
  • Create and format a form
  • Generate a report
  • Add controls and format a report
  • Restrict data entry and establish a pattern for entering field values
  • Create query joins, parameter and action queries
  • Add a command button to a form
  • Create a subform
  • Organise and format reports
  • Create a mailing label report
  • Import data into Access
  • Export data to Excel and text files

Access 2007 - Level 2

SKILLS COVERED:

  • Analyse tables and improve table structure
  • Create subqueries, unmatched and duplicate queries
  • Create a PivotTable and a PivotChart
  • Create and attach a macro
  • 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

Access 2007 - Level 3

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
  • Package a database with a digital signature
  • Share databases using a SharePoint site

Access 2007 New Features

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

VBA Access 2007

SKILLS COVERED:

  • Explore the Access development environment
  • Work with macros and VBA
  • Understand the VBA essentials
  • Work with variable, interactive and decisive VBA
  • Loop VBA
  • Understand the DoCmd object
  • Work with ActiveX data objects
  • Navigate, find and add records in a form
  • Debug VBA
  • Handle errors in VBA

Access 2003 - Level 1

SKILLS COVERED:

  • Explore the Access and database environment
  • Add, delete, sort and update records
  • Establish table relationships
  • Create a query and add criteria to a query
  • Create AutoForms and format a form
  • Generate an AutoReport and by using the wizard
  • Design a relational database
  • Create a new database
  • Restrict data entry with field properties
  • Create query joins, parameter and action queries
  • Add a command button to a form
  • Create a subform
  • Organise reports and set control properties
  • Create a mailing label
  • Export data to a text file
  • Merge Access data with a Word document

Access 2003 - Level 2

SKILLS COVERED:

  • Analyse tables and improve table structure
  • Create sunmatched and duplicate queries
  • Create a PivotTable and a PivotChart
  • Create and attach a macro
  • Display a calendar in a form
  • Include a chart in a report
  • Link tables to external data sources
  • Document a database

Access 2003 - Level 3

SKILLS COVERED:

  • Make data available on the web
  • Create Data Access page in design view
  • Develop a PivotTable and a PivotChart
  • Import XML data into an Access database
  • Export Access data to XML format
  • Call and run a procedure from a form
  • Create and modify a database switchboard
  • Implement security and set passwords
  • Encode and decode a database

What our customers have to say


"Nicky Bull was an outstanding instructor. She is very professional, thorough and has a great attitude towards teaching students."
Tania Elmasri
 
"The instructor explained the material very clearly and answered all questions to satisfactory levels."
Yogeeta Naidoo
 
"I particularly like the way the instructor answered student queries. This is unlike other training that I have been to.
Frank Porbo
   
  

Home | Search | Site Map | Legal | Privacy Policy | Terms of Use | Contact | Career Opportunities

Copyright © 2013 New Horizons Learning Centres Holdings Pty Ltd. All rights reserved. ABN: 86 168 459 086