Menu

    Call us on:
    0421 780 028

Intermediate Microsoft Access 2013 training Intermediate Microsoft Access 2013 Training Courses

If you’re looking for really great Intermediate Microsoft Access 2013 training you’re in the right place.

Companies large and small choose us – why? Your own tailored, Intermediate Microsoft Access 2013 training course, at your own premises at the same price as a standard course from elsewhere.

During your Intermediate Microsoft Access 2013 training, you will increase your skills in the design of Access tables, forms, queries and reports. You will also discover how to create Access table relationships for ease of data input and output.

The JMD Training difference is clear:

  • We come to you - your Intermediate Microsoft Access 2013 training will be given on your site
  • You get to keep the manuals - Intermediate Microsoft Access 2013 training manuals are provided as PDFs
  • We can train using your own Microsoft Access databases
  • There will only be people from your company on your course
  • We offer a money-back guarantee if any delegates are not completely satisfied
  • The training date is around you, not us!
  • Our prices are astounding
  • We can assess all learners in advance for free
  • Our courses are never cancelled

Visit our blog If Only I’d Known That,; we have called it that because we hear it so many times in training sessions. In fact, if only we had an extra $150 for every time someone says “If only I’d known that.” ….

Request Course Now »

Course TypeCost per day
1 to 1 training$495 + GST
2 to 3 delegates$795 + GST
4 to 5 delegates$995 + GST
6 to 8 delegates$1295 + GST

Prices are PER DAY, and NOT per-person! E.g. if there’s 6 people on the course, you pay $1295 + GST.

Other Microsoft Access training courses

If you are new to Microsoft Office 2013, you may also be interested in our Office 2013 upgrade training, workshops and floorwalking.

Clients who have benefitted from our Intermediate Access 2013 training include:

  • Lonergan Research

Aims of the Intermediate Access 2013 course

This course aims to give delegates a greater understanding of MS Access 2013.

Course Objectives

On completion of the course delegates will have improved their skills in using Microsoft Access 2013. They will be able to:

  • Use field properties for protection
  • Understand table relationships and referential integrity
  • Create multi-table queries
  • Use calculations in a query
  • Design custom entry forms
  • Design custom reports

The course is of one day's duration.

How the course is run

This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.

Pre-requisites

Familiarity with the Windows environment, and a basic knowledge of MS Access.

Displaying the Access 2013 database

  • The Navigation pane, customising the Navigation pane
  • Database display

Table design - fields

  • Applying and modifying data types such as text, memo, hyperlink, currency, date and time in a field
  • Understanding the consequences of modifying data types such as text, memo, hyperlink, currency, date and time in a field
  • Creating and editing a lookup in a field
  • Creating and editing a validation rule in a field
  • Creating and editing an input mask in a field
  • Applying and modifying default values in a field
  • Setting a mandatory field
  • Fields with multiple values

Table Relationships

  • Understanding the basis for creating a valid relationship
  • Creating a one-to-one or a one-to-may relationship between tables
  • Understanding and modifying a many-to-many relationship between tables
  • Applying inner, outer and self joins
  • Applying and using referential integrity
  • Applying automatic deletion of related records
  • Relating or joining data when designing records
  • Adding fields to tables
  • Field templates

Microsoft Access Query design

  • Grouping information in a query
  • Using a crosstab query
  • Using wildcards in a query
  • Using arithmetic and logical expressions in a query

Form design

  • Using bound and unbound controls
  • Creating and editing a combo box, list box, check box and option groups
  • Inserting a data field to appear within form header or footer on the first page or all pages
  • Stacked and tabular layout controls

Report design

  • Inserting a data field to appear within report header or on footers on the first page or all pages
  • Forcing page breaks for groups on reports

Importing, exporting and linking data

  • Importing text, Excel, csv, etc, documents into an Access 2013 database
  • Exporting data in Excel, txt, etc. formats
  • Linking external data to an Access 2013 database

Request Course Now »

We provide Microsoft Office training courses, other IT training courses and Personal Development training courses in Sydney, CBD, North Sydney, Chatswood, St Leonard’s, Parramatta, Ryde, Macquarie Business Park, Alexandria, Mascot, Hornsby, Arndell Park, Wetherill Park, St Marys, Penrith as well as the Hills District, the Sutherland Shire and the Central Coast. We will travel further if expenses are covered.

For computer training courses London, UK, please visit our sister site, http://www.jmdtraining.co.uk