Microsoft Access training - Basic Querying in Access (1 day)

This course is for Microsoft Access versions up to 2003 - we also run an equivalent Basic Querying in Access 2007 training course.

Does your computer system generate large amounts of data, which you find is just too cumbersome to analyse?  This course assumes no knowledge of Access, and shows how to use Access queries to manipulate data (whether this is held in Access, Excel or some other format). Database design, tables, forms and reports are also normally briefly covered.

Basic Querying in Access training - Course Contents

The contents of our Basic Querying in Access course are as follows (any items marked with a * will be covered if time allows). If you aren't sure if this is the right course for you, please call or email us to talk through your options. We want you to be on the right Microsoft Access training course as much as you do!

Designing a database
  • Identifying the tables
  • What are relationships?
  • Setting a primary key
Creating tables
  • Defining fields
  • Types of field
  • Entering data
Drawing relationships
  • Creating relationships
  • Referential integrity
Importing data
  • Importing from Excel
  • Linking to Excel spreadsheets
  • Problems with importing
Creating queries
  • The query design grid
  • Sorting
  • Setting criteria
  • Combining criteria
Advanced queries
  • Grouping and totalling
  • Creating expressions
  • Parameter queries
Joins (*)
  • Creating ad hoc joins
  • Types of join
Creating forms
  • Using the form wizard
  • Using forms to enter data
  • Form design
  • Creating controls
Creating reports
  • Using the report wizard
  • Using print preview
  • Report design

To help see if this is the right course for you, you can see and download examples of our Access database courseware. You can also look at the differences between Microsoft Access database versions and see on which Access database version we currently train.

Basic Querying in Access training - Pre-requisites

In order to attend this Microsoft Access training course you should already be a confident computer user. Most people find Access harder to learn than Excel or Word (for example).

Basic Querying in Access training - Schedule and Prices

Prices for this Microsoft Access training course are as follows:

There will be a maximum of 6 people on each course, and each person will have their own computer. Please take a moment to see why our Microsoft Access training courses are so different, then use our easy-to-use web-based or telephone booking system to book your course place. Alternatively, call (01457) 858877 or email our training co-ordinator.

Onsite Microsoft Access training

In addition to our standard scheduled Microsoft training courses, we also offer onsite Microsoft Access training. This allows you to create a Microsoft Access training course uniquely tailored to the needs of your staff, covering only those aspects of Microsoft Access which they need to learn.

All content � Wise Owl Business Solutions Ltd 2007.  All rights reserved.  Design by Branches.