Advanced Microsoft Access Training London & UK wide

Access Training Courses

Testimonials

Some feedback from courses in the last 18 months:

Very imformative and well presented. Trainer was very knowledgable and easy to understand.

Nerine W
Siemens Shared Services
Access Advanced

Well worth attending...

Ian Luckin
LloydsTSB Private Banking
Access Advanced

Very good overall

Ben Askin
Commonwealth Bank of Australia
Access Advanced

Microsoft Access 2002 XP Advanced

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

Training formats available

on a public schedule at one of our London training venues
on-site at your company office UK wide
closed group at one of our London training venues
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

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

Version	Date	Location	Places available	Book	Next place rate (£)		List price
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2010	Fri 17 Sep 2010	Bloomsbury	9		£275	£280	£299
2003	Fri 1 Oct 2010	Bloomsbury	8		£223	£228	£245
2003	Mon 8 Nov 2010	Southwark	8		£218	£223	£245
2010	Thu 25 Nov 2010	Bloomsbury	8		£225	£230	£299
2007	Fri 26 Nov 2010	Bloomsbury	6		£229	£234	£245
2003	Tue 14 Dec 2010	Southwark	10		£142	£147	£245
2003	Fri 21 Jan 2011	Bloomsbury	9		£75	£80	£245
2010	Fri 21 Jan 2011	Bloomsbury	10		£150	£155	£299
2007	Wed 26 Jan 2011	Bloomsbury	8		£144	£149	£245
2003	Fri 25 Feb 2011	Bloomsbury	10		£75	£80	£245
2003	Fri 25 Mar 2011	Bloomsbury	10		£75	£80	£245
2010	Fri 25 Mar 2011	Limehouse (Docklands)	10		£150	£155	£299
2007	Wed 30 Mar 2011	Bloomsbury	9		£75	£80	£245
2003	Tue 5 Apr 2011	Southwark	10		£75	£80	£245
2007	Thu 12 May 2011	Bloomsbury	10		£75	£80	£245
2003	Tue 17 May 2011	Bloomsbury	10		£75	£80	£245
2010	Tue 31 May 2011	Bloomsbury	10		£150	£155	£299
2010	Thu 28 Jul 2011	Bloomsbury	10		£150	£155	£299
2003	Thu 18 Aug 2011	Southwark	10		£75	£80	£245
2007	Thu 25 Aug 2011	Southwark	10		£75	£80	£245
2010	Fri 16 Sep 2011	Bloomsbury	10		£150	£155	£299
2003	Fri 30 Sep 2011	Bloomsbury	10		£75	£80	£245

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