Access 2013 Module 2 - Query Techniques to Extract, Maintain and Manipulate Data

Aimed At: Staff who have attended Module 1 and are required to create or amend queries to extract data from an Access database.

Workshop Overview

This module uses the database introduced in Module 1. Some of the work covered assumes previous attendance at Module 1.

Learning Objectives

At the end of the workshop participants will be able to:

  • Create Select type queries
  • Design Parameter queries
  • Create queries to find Unmatched & Duplicate Data
  • Generate Action queries
Outline Programme

The workshop programme is as follows:

  • Generate select queries & applying criteria
  • Create calculated fields in queries
  • Produce multi-table queries
  • Create summary (total) queries
  • Build a parameter query
  • Design and creating crosstab queries
  • Create a query to find unmatched data
  • Create a query to find duplicated data
  • Introduce concepts of when and how action queries are used
  • Create action queries: make tables, update, append and delete queries

To further enhance your understanding of Access, you can access our online Access courses available through SDU's Learning Resource Centre.

Booking Details

Valerie Stuart

13:30 - 16:30

    It is not possible to access the workshop booking form unless connected to the University's campus network, should you wish to book a place on this workshop please contact the Staff Development Unit on 0191 208 6119 direct.


    1/2 Day


    Vicky Beesley Ext. 83424

    Related Information

    Books and Videos
    Online IT Courses