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

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

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 in much detail is Visual Basic (which we cover in a separate two-day course).

Access 2007 Introduction for Developers training - Course Contents

The contents of our Access 2007 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 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
Different field types
  • Creating attachments
  • Rich text format fields
  • Date fields (using calendars)
Importing data
  • Importing from Excel
  • Making tables from Excel
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
Crosstab queries (*)
  • Columns, rows and values
  • Overriding column headings
Action queries
  • Making tables
  • Updating records
  • Appending records
  • Deleting records
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
Creating subforms
  • Multiple item forms
  • Creating subforms
  • Tidying up subforms
Basic VBA coding
  • Creating modules
  • Using Project Explorer
  • Writing comments
  • Indenting code
Uses of VBA
  • Form validation
  • Criteria forms
  • A simple menu system

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.

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