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

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

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 2007 training - Course Contents

The contents of our Basic Querying in Access 2007 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 2007 training course as much as you do!

Designing a database
  • Identifying the tables
  • What are relationships?
  • Setting a primary key
  • Using multivalue fields
Creating tables
  • Defining fields
  • The types of field
  • Entering data
Drawing relationships (*)
  • Creating relationships
  • Referential integrity
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
  • Layout and design view
  • Using the form wizard
  • Split forms
  • Creating controls
Creating reports
  • Using the report wizard
  • The group, sort and total pane
  • Report design

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

Basic Querying in Access 2007 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 2007 training - Schedule and Prices

Prices for this Microsoft Access 2007 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 2007 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 2007 training

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

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