Instructor-led training - London Courses in 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 97 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 courses in London & UK wide

Microsoft Access 97 Advanced

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

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

When you have finished this course you should be able to perform all of Access functions to a professional standard. You will study the full spectrum of queries and their impact within the database. You will be in total control of Objects and their relevance to forms. You will learn to automate functions, creating simple and then progressing to very advanced macros. The final sessions are dedicated to realising how to get the best display for your data and how to link your data with the internet.

After completing this course you will be capable of attending the Access VBA training course.

Course Syllabus

  • Make select queries more versatile by using parameters
  • Use action queries to update data values and add or delete records
  • Refine the information derived from queries by creating outer joins and using crosstab queries
  • Enhance form design by manipulating control object properties
  • Automate simple tasks by creating macros to open forms and control form properties
  • Make forms more functional and automate tasks by creating macros
  • Enhance the design of reports by hiding repetitive data, grouping data on prefix values, and using functions in controls
  • Use Access to create links to internet sites, and to save data as HTML documents

Public Schedule - Pricing and Availability

Access Introduction 1 day course List price £225
Version Date Location Places
available
Book Next place rate:
Card Invoice
2003/XP 2008 May 27 Tue Tooting 0 FULL    
2003/XP 2008 Jun 2 Mon Southwark 5 book now £198 £215
2003/XP 2008 Jun 9 Mon Bloomsbury 7 book now £188 £215
2003/XP 2008 Jun 12 Thu Bayswater 8 book now £195 £205
2003/XP 2008 Jun 18 Wed Bloomsbury 7 book now £188 £215
2007 2008 Jun 23 Mon Bloomsbury 5 book now £212 £224
2003/XP 2008 Jul 7 Mon Southwark 8 book now £182 £207
2003/XP 2008 Jul 14 Mon Bayswater 8 book now £110 £205
2003/XP 2008 Jul 17 Thu Bloomsbury 6 book now £170 £207
2007 2008 Jul 23 Wed Bloomsbury 6 book now £202 £224
2003/XP 2008 Jul 28 Mon Bloomsbury 8 book now £110 £207
2003/XP 2008 Jul 29 Tue Tooting 0 FULL    
2003/XP 2008 Aug 4 Mon Southwark 8 book now £110 £207
2003/XP 2008 Aug 11 Mon Bloomsbury 8 book now £110 £207
2003/XP 2008 Aug 14 Thu Bayswater 8 book now £110 £205
2003/XP 2008 Aug 20 Wed Bloomsbury 8 book now £110 £207
2003/XP 2008 Sep 1 Mon Southwark 8 book now £110 £207
2003/XP 2008 Sep 8 Mon Bloomsbury 8 book now £75 £207
2003/XP 2008 Sep 17 Wed Bloomsbury 0 FULL    
2003/XP 2008 Sep 18 Thu Bayswater 8 book now £75 £205
2007 2008 Sep 22 Mon Bloomsbury 8 book now £75 £224
2003/XP 2008 Sep 23 Tue Tooting 0 FULL    
2003/XP 2008 Oct 6 Mon Southwark 8 book now £75 £207
2003/XP 2008 Oct 9 Thu Bloomsbury 8 book now £75 £207
2003/XP 2008 Oct 22 Wed Bloomsbury 8 book now £75 £207
2003/XP 2008 Oct 27 Mon Bloomsbury 8 book now £75 £207
2003/XP 2008 Oct 28 Tue Tooting 0 FULL    
2003/XP 2008 Nov 3 Mon Southwark 8 book now £75 £207
2003/XP 2008 Nov 6 Thu Bloomsbury 8 book now £75 £207
2003/XP 2008 Nov 19 Wed Bloomsbury 8 book now £75 £207
2003/XP 2008 Nov 24 Mon Bloomsbury 8 book now £75 £207
2003/XP 2008 Nov 25 Tue Tooting 7 book now £75 £193
2003/XP 2008 Dec 1 Mon Southwark 8 book now £75 £207
2003/XP 2008 Dec 4 Thu Bloomsbury 8 book now £75 £207
2003/XP 2008 Dec 17 Wed Bloomsbury 8 book now £75 £207
2003/XP 2008 Dec 22 Mon Bloomsbury 8 book now £75 £207
2003/XP 2008 Dec 23 Tue Tooting 0 FULL    
2003/XP 2009 Jan 5 Mon Southwark 8 book now £75 £207
2003/XP 2009 Jan 15 Thu Bayswater 8 book now £75 £207
2003/XP 2009 Jan 21 Wed Bloomsbury 8 book now £75 £207
2007 2009 Jan 26 Mon Bloomsbury 8 book now £75 £224
2003/XP 2009 Feb 2 Mon Southwark 8 book now £75 £207
2003/XP 2009 Feb 12 Thu Bayswater 8 book now £75 £207
2003/XP 2009 Feb 18 Wed Bloomsbury 8 book now £75 £207
2007 2009 Feb 23 Mon Bloomsbury 8 book now £75 £224
2003/XP 2009 Mar 2 Mon Southwark 8 book now £75 £207
2003/XP 2009 Mar 11 Wed Bayswater 8 book now £75 £207
2003/XP 2009 Mar 18 Wed Bloomsbury 8 book now £75 £207
2007 2009 Mar 23 Mon Bloomsbury 8 book now £75 £224
2003/XP 2009 Apr 6 Mon Southwark 8 book now £75 £207
2003/XP 2009 Apr 15 Wed Bayswater 8 book now £75 £207
2003/XP 2009 Apr 22 Wed Bloomsbury 8 book now £75 £207
2007 2009 Apr 27 Mon Bloomsbury 8 book now £75 £224
2003/XP 2009 May 13 Wed Bayswater 8 book now £75 £207
2003/XP 2009 May 20 Wed Bloomsbury 8 book now £75 £207
2003/XP 2009 Jun 1 Mon Southwark 8 book now £75 £207
2003/XP 2009 Jun 10 Wed Bayswater 8 book now £75 £207
2003/XP 2009 Jun 17 Wed Bloomsbury 8 book now £75 £207
2007 2009 Jun 22 Mon Bloomsbury 8 book now £75 £224
2003/XP 2009 Jul 6 Mon Southwark 8 book now £75 £207
2003/XP 2009 Jul 15 Wed Bayswater 8 book now £75 £207
2003/XP 2009 Jul 22 Wed Bloomsbury 8 book now £75 £207
2007 2009 Jul 27 Mon Bloomsbury 8 book now £75 £224
2003/XP 2009 Aug 3 Mon Southwark 8 book now £75 £207
2003/XP 2009 Aug 12 Wed Bayswater 8 book now £75 £207
2003/XP 2009 Aug 19 Wed Bloomsbury 8 book now £75 £207
2007 2009 Aug 24 Mon Bloomsbury 8 book now £75 £224
2003/XP 2009 Sep 7 Mon Southwark 8 book now £75 £207
2003/XP 2009 Sep 16 Wed Bayswater 8 book now £75 £207
2003/XP 2009 Sep 23 Wed Bloomsbury 8 book now £75 £207
2007 2009 Sep 28 Mon Bloomsbury 8 book now £75 £224
2003/XP 2009 Oct 5 Mon Southwark 8 book now £75 £207
2003/XP 2009 Oct 14 Wed Bayswater 8 book now £75 £207
2003/XP 2009 Oct 21 Wed Bloomsbury 8 book now £75 £207
2007 2009 Oct 26 Mon Bloomsbury 8 book now £75 £224
2003/XP 2009 Nov 2 Mon Southwark 8 book now £75 £207
2003/XP 2009 Nov 11 Wed Bayswater 8 book now £75 £207
2003/XP 2009 Nov 18 Wed Bloomsbury 8 book now £75 £207
2007 2009 Nov 23 Mon Bloomsbury 8 book now £75 £224

"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