Microsoft Office training - Access Developers

Access Training

Microsoft Access Developers Training Course

£795 + VAT for most venues (£895 + VAT for London)

3 days

The first (and most important) part of any Access database is getting the design right, which is where this 3-day course begins. You'll learn about primary keys and relationships, and find out how to create an Access database consisting of multiple linked tables.

The course then goes on to show how to create queries (to display data from one or more tables) and a front-end to your system, using forms, reports and the VBA coding language.

If you've been given the job of creating an Access database - and you're not sure where to start - this is the course for you!

We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking (or consider an onsite Access training course).

Course Contents - PDF

Course Contents

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)
Calculated fields

Importing data

Importing from Excel
Making tables from Excel

Covered if time allows If time

Table rules

Record-level validation
Basic triggers

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

Covered if time allows If time

Crosstab queries

Columns, rows and values
Overriding column headings

Covered if time allows If time

Action queries

Making tables
Updating records
Appending records
Deleting records

Creating forms

Layout and design view
Using the form wizard
Split forms
Creating controls

Covered if time allows If time

Advanced controls

Multitabs
Webbrowser controls
Navigation bars

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

Why Choose Us?

No more than 6 people per class
Proper restaurant lunch included
572 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

Sample customer feedback

"Honestly, I can't think of anything that could have been done to make ths course better. Much cheaper than others but delivers just as good content."

Jamie Everitt (Anglian Community Enterprise (NHS PCSE))

There are lots more where these came from (or just refresh this page to change the quotes shown).

You do not need to have used Access before to attend this course, although you should be a confident computer user.

Related Courses

Access Querying

Basic

1 day course

Access VBA macros RECOMMENDED

Advanced

2 day course

Advanced VBA

Guru level

2 day course

Other Microsoft Access training resources

Access exercises

To give you a chance to see whether this 3-day Access course is for you, we've published all of our Microsoft Access exercises online.

View Access VBA or Access 2010 exercises

Access skills assessment

You may find it useful to do one of our Access skills assessment tests, to help you know what you don't know (to misquote Donald Rumsfeld …).

View Access skills assessment skills assessment tests

Access blogs

In addtion to other Access training resources, you may find some of our Access blogs useful.

View Access or VBA macros blogs

This page has 0 threads Add post