Microsoft Access 2000 Intermediate

Now offering London's widest choice in
dates, venues, and prices.

Training formats available

On a public schedule at one of our
London training venues.
On-site at your company office UK wide
Near-site, at a location close to you
Bespoke one-to-one basis
Tailored training courses to your requirements
See all formats...

Promotions

Access training London

Training is available in one of our 6 London centres, on-site or tailored training courses

How to Book :: Training Schedule :: Contact Us

Other Microsoft Access training courses

Microsoft Access 2000 Intermediate

Duration: 1 Day
Level: Intermediate
Prerequisites: A working knowledge of Access or our Access Introduction course
Platform: PC
Leads to: Access 2000 Advanced course

Syllabus includes:

Creating relational databases
Database normalising
Introducing relating tables
Adding referential integrity

Working with related tables
The lookup wizard
Changing lookup fields
Inputting data to related tables

Defining data entry rules
Using input masks
Setting a property
Setting a validation rule

Using advanced query features
How to join a table in queries

Creating a calculated field
Using an action query Creating advanced queries
Summarise and group values
Create a crosstab query
Using a parameter query
Using an index

Creating advanced form design
Working with graphics
Working with calculations
Working with combo boxes
Working with unbound controls

Using advanced report features
Create customized headers and footers
Add a calculated value
Work with sub-reports

Some feedback from recent courses...

"Found the course excellent and top value! "
- Ronnie M, easyJet
[Access Introduction]

"Trainer made course very relevant to our current situations / jobs."
- Mark L, British Transport Police
[Access Intermediate]

"Met all my expectations + was able to ask alternative more personally specific questions where necessary."
- Gavin R, RAC Insurance Services
[Access Intermediate]

"Very helpful and approachable"
- Rhonda G, HM Land Registry
[Access Intermediate]

"Very good."
- Rob W, E*TRADE SECURITIES LIMITED
[Access Intermediate]

Click here for our client list