Microsoft Office TrainingThe UK's Number 1 for Microsoft Office Training add this page to your favourites/bookmarksBookmark page

view a printable version of this pagePrintable version
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Microsoft Access 2003 Intermediate

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

Access 2003 Intermediate

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


Syllabus Includes:

Relational Databases

Database normalization
Relating tables
Implementing referential integrity

Working with Related Tables

Using the Lookup Wizard
Modifying Lookup fields
Adding data to related tables

Complex Queries

Joining tables in queries
Creating calculated fields
Summarizing and grouping values

Advanced form design

Adding unbound controls
Adding graphics
Adding calculations
Adding combo boxes

Advanced reports

Creating customized headers and footers
Adding calculated values
Working with subreports

PivotTables and PivotCharts

Creating PivotTables
Modifying PivotTables
Working with PivotCharts

Other relevant courses:

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


Rate this page:
2.5/5 (4 votes cast)
Institute of IT Training - Accredited Training Provider ILM
Microsoft Certified Partner
Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

Institute of IT Training - Accredited Training Provider
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
Association of Computer Trainers verified by visa, mastercard securecard