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 2002 Advanced

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 2002 Advanced

Duration: 1 Day
Level: Advanced
Prerequisites: Access 2002 Intermediate, or equivalent knowledge
Platform: PC


Syllabus Includes:

PivotTables and PivotCharts

Creating PivotTables
Modifying PivotTables
Working with PivotCharts

Creating Advanced Forms


Building a form based on joined tables
Automating data entry
Using grouped control
Improving the user interface
Creating subforms

Macros

Creating and running macros
Attaching macros to events of database objects

Creating Advanced Macros

Creating macros to provide user interaction
Creating macros that require user decision
Using AutoKeys and AutoExec macros
Exploring Access SQL

Identifying different clauses in an SQL statement
Writing SQL statements
Attaching an SQL statement to database objects

Internet Integration

Working with hyperlink fields
Working with data access pages

Managing databases

Working with database utilities to optimise resources
Securing data by database replication
Encrypting and decrypting databases

Security Fundamentals

Protecting databases
User-level security

Some feedback from recent courses...

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

"Useful course. Have picked up lots of useful ideas which I can use in my work."
- Harjinder B, Westminster City Council
[Access Advanced]

"the trainer was really good"
- Julia B, Murphy Group
[Access Advanced]

"Very imformative and well presented. Trainer was very knowledgable and easy to understand."
- Nerine W, Siemens Shared Services
[Access Advanced]

Click here for our client list


Rate this page:
4.5/5 (2 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