Access 2003 Querying training course (1 day)

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.

Access 2003 Querying training - Course Contents

The contents of our Access 2003 Querying course are as follows (any items marked with a * will be covered if time allows):

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

Click on any link above to show free exercises for the topic in question. 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). There will be a maximum of 6 people on each course, and each person will have their own computer.

SITE MAP

All content copyright Wise Owl Business Solutions Ltd 2012.  You can follow us on FaceBook. All rights reserved.