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

09:15 - 12:30


1/2 Day


Vicky Beesley Ext. 83424

Related Information

Books and Videos
Online IT Courses