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

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


Syllabus includes:

PivotTables and PivotCharts
Create a PivotTable
Modify a PivotTable
Working with a PivotChart

Creating Advanced Forms
Designing a form based on joined tables
Automating data entry
Grouped control
How to improve the user interface
Designing subforms

Macros
Create and run macros
Attach macros to events of database objects

Creating Advanced Macros
Create macros to provide user interaction
Create macros requiring user decision
Use AutoKeys and AutoExec macros

Exploring Access SQL
How to identify different clauses in an SQL statement
Writing SQL statements
Attach an SQL statement to database objects

Integrating the Internet
Work with hyperlink fields
Work with data access pages

Managing Databases
Work with database utilities to optimise resources
Secure data by database replication

Security Fundamentals
Protect databases

Other relevant courses:

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:
3.5/5 (6 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