Microsoft Access training - Access Introduction for Developers (3 days)

This course is for Microsoft Access versions up to 2003 - we also run an equivalent Access 2007 Introduction for Developers training course.

Have you been given the task of designing and developing a database in Microsoft Access? Finding it difficult to know where to start? This three-day course assumes no prior knowledge of Access, and covers all the basics of Access, including how to design your database, creating tables, creating Access queries, and using Access forms, reports and macros. In fact the only thing this course does not cover is Visual Basic (which we cover in a separate two-day course).

Access Introduction for Developers training - Course Contents

The contents of our Access Introduction for Developers 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
Action queries
  • Making tables
  • Updating records
  • Appending records
  • Deleting records
Crosstab queries
  • Columns, rows and values
  • Overriding column headings
SQL Queries (*)
  • Union queries
  • Pass-through queries
Creating forms
  • Using the form wizard
  • Using forms to enter data
  • Form design
  • Creating controls
Creating subforms
  • Creating tabular forms
  • Merging forms and subforms
  • Tidying up subforms
Creating reports
  • Using the report wizard
  • Using print preview
  • Report design
Basic VBA macros
  • Creating macros
  • Using Project Explorer
  • Writing comments
  • Indenting code
Uses of macros
  • Form validation
  • Criteria forms
  • A simple menu system
The VBA code editor
  • Two ways to create modules
  • Using Project Explorer
  • Basic subroutines and comments

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.

Access Introduction for Developers training - Pre-requisites

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

Access Introduction for Developers 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.