Skip to Content

Bookings and Enquiries: 0800 077 36 46

Microsoft Access Query Writing Training Course

Microsoft Access Query Writing Training Course

1 Day Crawley £210.00+VAT
Available Date(s):
Print

Is this course right for me?

Our Access Query Writing course covers query writing techniques for quick, easy and accurate data extraction.

This course is designed for new or existing users of Microsoft Access who need to write and use queries for extracting information out of databases. You should be competent in using a PC for general business use. Familiarity of Access would be an advantage.

Training course objectives:

  • Create select queries from multiple tables
  • Include calculations and parameters in queries
  • Create unmatched queries
  • Create action queries to manipulate data
  • Create de-duplication queries

Versions Available

2003, 2007, 2010

Related Training Courses in Our Range

The database structure

  • Database objects
  • Table structure
  • Keys and indexes
  • Relational databases

Query writing principles

  • Extracting data using select queries
  • Setting criteria
  • Creating parameter queries
  • Calculations in queries

Multi table queries

  • Linking tables in queries
  • Join types
  • Creating queries to find unmatched data

Query options

  • Top values queries
  • Unique values queries
  • Formatting query output

Summary queries

  • Adding totals to your queries
  • Building crosstab queries

Action queries (Part 1)

  • Using make table queries
  • Using append queries

Action queries (Part 2)

  • Using delete queries
  • Using update queries

De-duplication techniques

  • Using the duplicates query wizard
  • Eliminating duplicates using an append query
  • Finding differences between tables
Contact

Call our expert Learning and Development team today on
0800 077 36 46 for more details about the training options available to
you or to book your course.