Microsoft Access Training Courses

With our MS Access training courses, you will gain the required knowledge to create, maintain and process large amounts of data easily. We have expert MS Access trainers to show how to make use of all the powerful tools.

MS Access courses can be run at our Access training centre in London, or onsite at your office, anywhere in the UK. Depending on your current Access knowledge, you might want to attend a standard course, e.g. Access Introduction or Access Advanced. Alternatively, we also run bespoke MS Access training courses, e.g. Queries Only, or Form Development. This is what makes us different. We can tailor any part of the courses to suit your needs.

If you have just upgraded to MS Access 2007, we also run Access 2007 upgrade training courses, to get you up to speed with the new and enhanced functionality.

If you would like to discuss your MS Access training course needs further with no obligation, then please contact us. We are a training company run by trainers, not sales staff. Therefore we can help you build your perfect MS Access training course.

Microsoft Access 2007 Training Courses

WIth the latest version of MS Access, learn how to create, maintain or edit a new or existing database by attending a Access 2007 training courses. Remember that we can tailored the courses to suit your needs.

Microsoft Access 2003 Training Courses

Learn how to use MS Access 2003 with a training course listed below:

Standard Access Training Levels / Training Details / Locations / Schedule

Select a MS Access training course level below to view all the information you need about the course, including the cost of the course, the available training formats and much more.

Introduction
Intermediate
Advanced
Visual Basic
Course Builder
TNA

Access Introduction Training Course

This course is designed for new Access users, or self taught users. The course will cover all aspects of database design and objects.

Course Duration

This is a 2 day Access training course. The course starts at 09:30 and runs until 16:30

Course Locations / Schedule

This Access introduction course can be run Onsite, at our Access training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.

Access Introduction / Beginners Training Course Contents

Database Overview / Terms / Planning

An overview of databases, database objects and terminology
Tables, Queries, Forms, Reports, Macros, Pages and Modules
Planning a database structure and tables
Creating a new database

Working with Tables

Designing a Table, Rules for entering Field Names
Enter data types, field descriptions
Setting a Primary Key and Setting Multiple Primary Keys
Removing a Primary Key
Defining Field Properties(Default values, Input masks, Validation rules and text,
Insert, Delete, Move and Rename Fields
Table Wizards

Entering and Editing Data

Switching Views in Access
Entering and Editing Data
Working in Data Entry Mode
Sorting Data, Finding & Replacing Data
Hiding and Un hiding Fields

Importing & Linking Data

Importing from Access and Excel
Linking to an external Access Database Table
Linking to an Excel Workbook using the Wizard
Renaming and Copying Tables

Queries and Filters

Create a filter by selection
Create a filter by form
Save a filter by form as a select query
Running a Select Query
The Query Design Window
Creating a query from the query window
Adding fields to a query, Display/Suppress the display of a field
Removing fields from a query
Specifying Text, numeric, date, and logic criteria
Specifying sub string searches using wild Card Characters
Working with Conditions - BETWEEN, AND, OR, NOT, NULL
Calculated fields

Relationships

Why create relationships between tables?
Different types of relationships
Conditions for setting up a relationship
Referential Integrity
Cascade Update
Cascade Delete
Relationships Report
Inserting Sub Datasheets
Removing Sub Datasheets
Expanding and Contracting Sub Datasheets

Multi Table Queries

Multiple Table Queries
Joining Tables for a query
Join Properties - Inner and Outer Joins
Find Unmatched Query Wizard
Find Duplicates Query Wizard

Creating Forms

Creating Forms using the Auto Form Tabular/Datasheet/Pivot Form wizard
Creating Forms Using the Form Wizard
Data Entry in Forms
Resizing and Moving Controls
Changing Text Attributes
Resizing Forms
The Field List Box
Selecting Controls
Formatting Controls
Format Painter and AutoFormat
Resizing and Moving Controls
Properties of an item

Reports

Standard Reports using Wizard
Inserting, Moving, Sizing, deleting controls
Customising Reports
Grouping Data
Using Expressions
Mailing Labels
Page setup

Access Intermediate Training Course

This course is designed for existing Access users. The course will focus more on Queries, Forms and reports. We also cover more advanced relationships.

Course Duration

This is a 1 day Access training course. The course starts at 09:30 and runs until 16:30

Course Locations / Schedule

This Access Intermediate course can be run Onsite, at our Access training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.

Access Intermediate Training Course Contents

Relationships

Why create relationships between tables?
Different types of relationships
Conditions for setting up a relationship
Referential Integrity
Cascade Update
Cascade Delete

Advanced Queries

Calculated fields
Parameter Queries
Summary Queries
Crosstab Query Wizard
Editing a Crosstab Query manually
Top Values Query
Make Table Query
Append Query
Delete Query
Update Query

Advanced Forms

Composite Forms including Main Form and sub forms
Displaying Yes/No values
Option groups
Command buttons
Setting form properties
Calculations within Forms
Combining Text Values
Changing the data source
Keyboard Short Cuts for Fields
Tab Order
Adding and Removing Filters(Selection and Forms)
Defining Validation Rules
Template Forms

Advanced Reports

Using Expressions
Adding Sub Reports
Parameter reports
Report Templates
The Keep Together property
Group on and group interval properties
Advanced Grouping techniques
Page setup

Charts and Pivots

Formatting a chart
Changing the type of chart
Parameter chart Charting based on individual record
Creating Pivots

Access Advanced Training Course

This course is designed for existing Access users whom need to start automating database tasks or simply complex database sequences

Course Duration

This is a 1 day Access Advanced course. The course starts at 09:30 and runs until 16:30

Course Locations / Schedule

This Access Advanced course can be run Onsite, at our Access training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.

Access Advanced Training Course Contents

Macros

An Overview
Creating Macros and Running Macros
Various Macro Actions

Names Macros

Using ^ + letter
Using ^ + Number
Function keys

Conditional Macros

Msgbox
Set value
Using functions

Event Procedures

On open/close
On got/lost focus

Creating a Switchboard (User Interface)

Designing a switchboard
Using Macros associated with Command Buttons
Using Macros associated with Code
Formatting switchboard forms
Creating a Splash Screen
Using autoexec
Custom toolbar
Custom menu
Start-up Menu

VBA

Sample subroutine
Sample function

Access VBA Training Course

This course is designed for advanced Access users whom need to start automating database tasks or simply complex database sequences

Course Duration

This is a 2 day Access VBA course. The course starts at 09:30 and runs until 16:30

Course Locations / Schedule

This Access VBA course can be run Onsite, at our Access training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.

Access VBA Training Course Contents

Macros

Creating Macros
Assigning Macros to Controls
Group Macros
Conditional Macros
The AutoExec Macro
The AutoKeys Macro

VBA

An overview
The Environment
Working with Modules
Converting Macros -DOCMD
Events

Coding Structures

Control Structures
Looping Structures

Functions

Purpose
Creating and using Functions

Variables

Option Explicit
Variable Type
Scoping a Variable
Testing Variable Contents

User Interaction

MsgBox
InputBox

Debugging and Error Handling

Breakpoints
Stepping Code
The Immediate Window
Creating Error Traps

Data Access Objects (DAO)

The Workspace Session
Manipulating Recordsets
Creating Queries
Creating Tables

Active X Controls

VBA Menus and Toolbars

Microsoft Access Tailored Courses

We have developed our own Custom Course Builder, where you can choose the topics you want to include in your MS Access training course. Each topic has an estimated teach time, so you can see how long it would take to learn what you want!

GO TO ACCESS COURSE BUILDER

MS Access Training Needs Analysis

We provide a free Access Training Needs Analysis (TNA) for all our clients to ensure the course is exactly what you need. Simply download our Access TNA. After completion, send this back to us. We can then build an Access Training Course that will ensure you only get shown relevant topics, unlike scheduled Access training courses.

Previous MS Access Training Course Versions and Levels

Below are all our different versions of MS Access Training Courses

Microsoft Access 2002 Training Courses

Microsoft Access 2000 Training Courses

Microsoft Access 97 Training Courses

Access Resources

Access Training Los Angeles - provided by Training Connection

Access Training Toronto - provided by Servitor Training Services

Access Training Vancouver - provided by Alandale Computer Training

Access Training Sydney - provided by Raising the Bar