Menu

    Call us on:
    07477 578417

Advanced Microsoft Access 2016 trainingAdvanced Microsoft Access 2016 Training Courses

Where training face-to-face may still not be viable, we are also offering online training by videoconferencing means, usually via Microsoft Teams or Zoom. Do get in contact if we can help you in this way. Click for further details of upcoming sessions. These will be updated on a regular basis. We are also happy to do customised online training to meet your requirements. Contact us for further details.

We have now resumed face-to-face training.

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

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

On this course you will learn how to create more complex Microsoft Access queries such as parameter queries and action queries including append queries, delete queries, update queries and make-table queries. You will create queries to find duplicates in data and also to find unmatched data. You will create professional-looking forms for data input. You will gain skills in sophisticated Microsoft Access report design to produce professional looking results. You will also learn how to create simple Access macros to automate processes.

The JMD Training difference is clear:

  • We come to you – your Advanced Microsoft Access 2016 training will be given on your site
  • You get to keep the manuals – Advanced Access 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

Request Course Now »

Course Type Cost per day
1 to 1 training £315
2 to 4 delegates £495
5 to 8 delegates £645

Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £645. All prices exclude VAT.

Our Microsoft Access training courses include:

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

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 £100 for every time someone says “If only I’d known that.” …. There are many useful hints and tips about using Microsoft Access on the blog; why not visit it to find out how many you knew!

Organisations which have benefitted from our Advanced Access 2016 training include:

Our Microsoft Access training courses London, are available not only in London, but Surrey, Middlesex, Richmond, Twickenham, Hounslow, Brentford, Banstead, Ascot, Putney, Wimbledon, Staines, Egham, Feltham, Woking, Reading, Croydon, Leatherhead, Farnham, High Wycombe, Crawley, Sutton, St Albans, Fulham, Watford – in fact anywhere within the Home Counties and M25 corridor. We have Microsoft Access trainers in Twickenham, Richmond, Ashstead, Central London, New Barnet, Ilford, Bushey, Crowthorne, and Basingstoke.

Aims of the Advanced Access 2016 course

This course aims to give delegates an insight into some of the more advanced features in MS Access 2016.

Course Objectives

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

  • Use advanced forms features
  • Use Access in conjunction with the Internet
  • Create advanced queries
  • Produce reports
  • Record and assign macros

The Microsoft Advanced Access 2016 training 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 reasonable knowledge of Access 2016. Prior attendance of the Intermediate Access 2016 course would be an advantage.

Query Types

  • Creating and using a query to update data in a table
  • Creating and using a query to delete records in a table
  • Creating and using a query to save the selected information as a table
  • Appending records to a table using a query

Refining Queries

  • Showing duplicates
  • Showing unmatched values
  • Showing the highest or lowest range of values in a query
  • Parameter queries - allowing query input from a data prompt
  • Refining queries using Null and NOT values

Advanced Forms

  • Creating arithmetic and logical expression controls on a form
  • Setting sequential order of controls on a form
  • Creating a subform and linking it to parent
  • Modifying the subform to change records displayed
  • Split forms

Calculations in Reports

  • Creating arithmetic and logical expression controls in a report
  • Calculating percentages in a report
  • Using formulas and expressions in a report such as sum, count, average, max, min, concatenate
  • Creating running summaries in a report

Macros

  • Recording a simple macro
  • Running a macro
  • Assigning or attaching a macro to a form, report, control

Request Course Now »

We provide Microsoft Access training courses, Microsoft Office training courses, other IT training courses and Personal Development training courses in London, Richmond, Twickenham, Kingston, Hounslow, Brentford, Putney, Kingston, Wimbledon, Walton-on-Thames, Chiswick, Teddington, Hampton, Feltham, Acton, Ealing, Heathrow, Egham, Staines, Hanwell, Sunbury, Hammersmith, Fulham, Greenford, Clapham, Chertsey, Woking, Weybridge, Wandsworth, Middlesex, Surrey, the M25 corridor, High Wycombe and beyond. We will travel further if expenses are covered.

For Advanced Microsoft Access 2016 training courses Sydney, Australia, please visit our sister site at http://www.jmdtraining.com.au/microsoft-office-training/microsoft-access-training/advanced-access-2016-training