Instructor-led training - London Training Microsoft Access Advanced
Microsoft Office Training verified by visa - mastercard securecode about microsoft training company london ukadd this page to your favourites/bookmarksAdd to favourites
view a printable version of this pagePrintable version
email this page to somebodyEmail this page 		Customer: Sign in
Delegate: Sign in
Trainer: Log in
Home Course details Training formats Pricing FAQ Clients Book online Online schedule (live) Forum Contact us
 
spacer Customer account
At a glance
 
spacer New booking
Choose courses
 
spacer Enquiries
Contact usTraining vacancies
 
spacer Information
Pricing and availabilityAccess 2002 AdvancedForumHints and tipsLocation/map/parking
 
spacer Training
Public schedule On-site training Closed company E-Learning
 
spacer Pricing
Public schedule On-site training Closed company E-Learning

Advanced Microsoft Access Training London & UK wide

Pricing and Availability

· Live online schedule with current pricing

Access Training Courses

· Access 2007 Introduction
· Access 2007 Intermediate
· Access 2007 Advanced
· Access 2007 VBA

· Access 2003 Introduction
· Access 2003 Intermediate
· Access 2003 Advanced
· Access 2003 VBA

· Access 2002 XP Introduction
· Access 2002 XP Intermediate
· Access 2002 XP Advanced
· Access 2002 XP VBA

· Access 2000 Introduction
· Access 2000 Intermediate
· Access 2000 Advanced
· Access 2000 VBA

· Access 97 Introduction
· Access 97 Intermediate
· Access 97 Advanced

· Access Training On-site UK
· Access Consulting Services
· Microsoft Access Training

Testimonials

Some feedback from recent courses:

"Very helpful and approachable."
Rhonda G, HM Land Registry
[Access Advanced]

"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]

Related Links

· Client list
· Onsite Training
· "easyJet" style pricing
· Order form / How to book
· Training formats
· Training vouchers
· Microsoft Certification

Microsoft Access 2002 XP Advanced

Microsoft Access 1 day instructor-led, courses never cancelled, from £75 (list price £245)

Training formats available

Who is this training course suitable for?

Those with a sound working knowledge of Access, who wish to progress to the most complicated functions and features, will find our Microsoft Access 2003 Advanced course suitable.

Prerequisites

Sound experience of Excel in a work environment or our Access Intermediate course.

Benefits

On completion of this course the delegate will be proficient in the more advanced functions of Access. After exploring PivotTables and PivotCharts, they will learn to automate functions, creating simple macros and then progressing to very advanced macros. Delegates will use their newly aquired querying skills in SQL statements by running queries. They will practice integrating Access with the internet and learn the fundamentals of database management. Importantly, they will be taught how to protect their valuable data sources.

Successful completion of this course will then qualify the delegate to progress to the VBA course for Access.

Course Syllabus

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

Public Schedule - Pricing and Availability

Access Advanced 1 day course List price £245
Version Date Location Places
available		 Book Next place rate:
Card Invoice
2003/XP 2008 May 28 Wed Bloomsbury 3 book now £224 £235
2003/XP 2008 Jun 4 Wed Southwark 5 book now £219 £235
2003/XP 2008 Jun 20 Fri Bloomsbury 0 FULL    
2007 2008 Jun 25 Wed Bloomsbury 6 book now £229 £240
2003/XP 2008 Jul 9 Wed Southwark 7 book now £203 £230
2003/XP 2008 Jul 16 Wed Bayswater 7 book now £110 £205
2003/XP 2008 Jul 18 Fri Tooting 0 FULL    
2007 2008 Jul 25 Fri Bloomsbury 6 book now £218 £240
2003/XP 2008 Jul 30 Wed Bloomsbury 0 FULL    
2003/XP 2008 Aug 6 Wed Southwark 7 book now £110 £224
2003/XP 2008 Aug 18 Mon Bayswater 6 book now £110 £205
2003/XP 2008 Aug 22 Fri Bloomsbury 0 FULL    
2003/XP 2008 Aug 29 Fri Bayswater 0 FULL    
2003/XP 2008 Sep 3 Wed Southwark 6 book now £110 £224
2003/XP 2008 Sep 12 Fri Tooting 0 FULL    
2003/XP 2008 Sep 19 Fri Bloomsbury 0 FULL    
2007 2008 Sep 24 Wed Bloomsbury 0 FULL    
2003/XP 2008 Oct 8 Wed Southwark 8 book now £75 £224
2003/XP 2008 Oct 17 Fri Tooting 0 FULL    
2003/XP 2008 Oct 24 Fri Bloomsbury 8 book now £75 £224
2003/XP 2008 Oct 29 Wed Bloomsbury 8 book now £75 £224
2003/XP 2008 Nov 5 Wed Southwark 8 book now £75 £224
2003/XP 2008 Nov 14 Fri Tooting 0 FULL    
2003/XP 2008 Nov 21 Fri Bloomsbury 8 book now £75 £224
2003/XP 2008 Nov 26 Wed Bloomsbury 8 book now £75 £224
2003/XP 2008 Dec 3 Wed Southwark 8 book now £75 £224
2003/XP 2008 Dec 12 Fri Tooting 0 FULL    
2003/XP 2008 Dec 19 Fri Bloomsbury 8 book now £75 £224
2003/XP 2008 Dec 24 Wed Bloomsbury 8 book now £75 £224
2003/XP 2009 Jan 7 Wed Southwark 8 book now £75 £224
2003/XP 2009 Jan 14 Wed Bloomsbury 8 book now £75 £224
2003/XP 2009 Jan 23 Fri Bloomsbury 8 book now £75 £224
2003/XP 2009 Jan 28 Wed Bayswater 8 book now £75 £205
2003/XP 2009 Feb 4 Wed Southwark 8 book now £75 £224
2003/XP 2009 Feb 11 Wed Bloomsbury 8 book now £75 £224
2003/XP 2009 Feb 20 Fri Bloomsbury 8 book now £75 £224
2003/XP 2009 Mar 4 Wed Southwark 8 book now £75 £224
2003/XP 2009 Mar 13 Fri Bayswater 8 book now £75 £205
2003/XP 2009 Mar 20 Fri Bloomsbury 8 book now £75 £224
2003/XP 2009 Apr 17 Fri Bayswater 8 book now £75 £205
2003/XP 2009 Apr 24 Fri Bloomsbury 8 book now £75 £224
2003/XP 2009 May 6 Wed Southwark 8 book now £75 £224
2003/XP 2009 May 15 Fri Bayswater 8 book now £75 £205
2003/XP 2009 May 22 Fri Bloomsbury 8 book now £75 £224
2007 2009 May 27 Wed Bloomsbury 8 book now £75 £240
2003/XP 2009 Jun 3 Wed Southwark 8 book now £75 £224
2003/XP 2009 Jun 12 Fri Bayswater 8 book now £75 £205
2003/XP 2009 Jun 19 Fri Bloomsbury 8 book now £75 £224
2007 2009 Jun 24 Wed Bloomsbury 8 book now £75 £240
2003/XP 2009 Jul 8 Wed Southwark 8 book now £75 £224
2003/XP 2009 Jul 17 Fri Bayswater 8 book now £75 £205
2003/XP 2009 Jul 24 Fri Bloomsbury 8 book now £75 £224
2007 2009 Jul 29 Wed Bloomsbury 8 book now £75 £240
2003/XP 2009 Aug 5 Wed Southwark 8 book now £75 £224
2003/XP 2009 Aug 14 Fri Bayswater 8 book now £75 £205
2003/XP 2009 Aug 21 Fri Bloomsbury 8 book now £75 £224
2007 2009 Aug 26 Wed Bloomsbury 8 book now £75 £240
2003/XP 2009 Sep 9 Wed Southwark 8 book now £75 £224
2003/XP 2009 Sep 18 Fri Bayswater 8 book now £75 £205
2003/XP 2009 Sep 25 Fri Bloomsbury 8 book now £75 £224
2007 2009 Sep 30 Wed Bloomsbury 8 book now £75 £240
2003/XP 2009 Oct 7 Wed Southwark 8 book now £75 £224
2003/XP 2009 Oct 16 Fri Bayswater 8 book now £75 £205
2003/XP 2009 Oct 23 Fri Bloomsbury 8 book now £75 £224
2007 2009 Oct 28 Wed Bloomsbury 8 book now £75 £240
2003/XP 2009 Nov 4 Wed Southwark 8 book now £75 £224
2003/XP 2009 Nov 13 Fri Bayswater 8 book now £75 £205
2003/XP 2009 Nov 20 Fri Bloomsbury 8 book now £75 £224
2007 2009 Nov 25 Wed Bloomsbury 8 book now £75 £240

"What do I get on the day?"

  • Microsoft certified trainers with industry relevant experience
  • Modern air conditioned training suite, flat screen PC's, 1 per delegate
  • Lunch provided in a comfortable and relaxed setting
  • Comprehensive course material and files to take away
  • What do I get on the day? - More information

What is Microsoft Access?

Microsoft Access is a desktop database application, packaged with Microsoft Office Professional. Unlike Excel, Access is able to work with millions of records, allowing large databases to be created, updated, searched and reported on by multiple users. From simple data capture to complex automation and user interfaces, Access brings all the powerful functionality of a complete database, without the need for expensive servers and administration.

Institute of IT Training - Accredited Training Provider Institute of IT Training - Accredited Training Provider Prodigy Platinum Learning Partner Microsoft Office Specialist Authorised Testing Centre

Microsoft Registered Partner
microsoft office
ms office project server

 Association of Computer Trainers Valid HTML 4.01 Transitional
Valid CSS Markup

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application Main information pages See also

Access courses
DreamWeaver courses
Excel courses
MS Project courses
Outlook courses
PowerPoint courses
VBA courses
Word courses
(more...)

Public scheduled courses
On-site training
Closed company courses

Microsoft Office training
Pricing and availability
Training schedule
Training venues

Access training
Dreamweaver training
Excel training
MS Project training
PowerPoint training

London Computer Training
Computer Training London

Microsoft Access training
Microsoft Excel training
Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training

Time Management Course London

Interested in Access training? Please see the following pages:
microsoft access courses · microsoft training access course
 microsoft+access+training · access courses in london

 Training Information

© 2008 Best Training. All Rights Reserved. A Microsoft software training company. info (at) microsofttraining (dot) net
All prices offered for business users and exclude VAT. E&OE