Skip to site navigation

Advanced queries in Access 2013

Description:

This course is aimed at Access users who need to extend their knowledge of designing queries in Access.

Note that this course can be attended by people using Access 2010.  There are some differences between the two versions but most features are the same.

Pre-requisites:
You should have attended, or be familiar with the concepts covered in, the Creating Queries in Access course and the Designing and Developing Databases in Access course.

Outline:

  • creating crosstab queries
  • inner and outer joins in multiple table queries
  • using action queries to create new tables and add new records
  • using action queries to update and delete records
  • grouping and aggregate functions
  • calculated fields
  • using query wizards to find duplicate and unmatched records

Delivery:  Trainer Led

This is a trainer-led 3 hour session.

To see when the next session of this course is running, please check our training calendars:


Resources:

All ISD IT Training course materials are now available to download from the Moodle course: ISD IT Training

You will need to login to Moodle using your UCL user ID and password.

Materials are organised by application name e.g. SPSS or Excel 2013 then by course.

Whenever possible please ensure that you have downloaded the course materials prior to attending a booked course.