Advanced Microsoft Access courses in London & UK wide

98.3 % recommend us More live stats... Access Training Courses · Access 2010 Introduction · Access 2010 Intermediate · Access 2010 Advanced · Access 2010 VBA · Upgrade to Office 2010 · Access 2007 Introduction · Access 2007 Intermediate · Access 2007 Advanced · Access 2007 VBA · Upgrade to Office 2007 · 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 Who did we train last week? Provides solid ground for Access knowledge Marina Georgantopoulou ABN Amro Access Introduction Course focus & content was excellent - I now feel more confident in Access as a beginner! Leah Fletcher STASCO Access Introduction Very helpful trainer excellent good pace Julia O'toole NHS Access Introduction More testimonials Related Links · Client list · Onsite Training · "easyJet" style pricing · Order form / How to book · Training formats · Training vouchers · Microsoft Certification

Microsoft Access 97 Advanced

1 day instructor-led. Courses never cancelled: Guaranteed. From £75 (list price £235)

Training formats available

• on a public schedule at one of our London training venues
• on-site at your company office UK wide (60 second quote)
• closed group at one of our London training venues (60 second quote)
• near-site at a location close to you
• bespoke one-to-one basis
• tailored training courses to your requirements

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 Onsite/Closed Quote
Version	Date	Location	Places available	Book	Next place rate (£)		List price
					Pay by Card	Pay by Invoice
2010	Wed 15 Feb 2012	Southwark	5		£285	£295	£299
2007	Mon 27 Feb 2012	Bloomsbury	0	FULL			£235
2007	Wed 4 Apr 2012	Southwark	9		£190	£200	£235
2010	Thu 12 Apr 2012	Bloomsbury	7		£258	£268	£299
2003	Wed 25 Apr 2012	Southwark	9		£185	£195	£235
2007	Wed 16 May 2012	Bloomsbury	7		£185	£195	£235
2010	Wed 13 Jun 2012	Limehouse	9		£160	£170	£299
2007	Fri 22 Jun 2012	Limehouse	9		£75	£85	£235
2010	Mon 13 Aug 2012	Southwark	10		£150	£160	£299
2007	Tue 21 Aug 2012	Southwark	10		£75	£85	£235
2010	Tue 11 Sep 2012	Bloomsbury	10		£150	£160	£299
2007	Wed 26 Sep 2012	Southwark	9		£75	£85	£235
2003	Thu 4 Oct 2012	Southwark	10		£75	£85	£235
2007	Mon 22 Oct 2012	Bloomsbury	10		£75	£85	£235
2010	Mon 19 Nov 2012	Southwark	10		£150	£160	£299
2007	Wed 21 Nov 2012	Bloomsbury	10		£75	£85	£235
2007	Mon 3 Dec 2012	Bloomsbury	10		£75	£85	£235
2003	Wed 5 Dec 2012	Limehouse	10		£75	£85	£235
2010	Thu 13 Dec 2012	Bloomsbury	10		£150	£160	£299
2007	Mon 28 Jan 2013	Limehouse	10		£75	£85	£235
2010	Wed 13 Feb 2013	Southwark	10		£150	£160	£299
2007	Mon 25 Feb 2013	Bloomsbury	10		£75	£85	£235

"What do I get on the day?"

• Microsoft qualified 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.