Advanced Microsoft Access Training London & UK wide
Microsoft Access 2002 XP Advanced
1 day instructor-led. Courses never cancelled: Guaranteed. From £75 (list price £245)
Training formats available
- 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
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 Creating Advanced Forms Macros Creating Advanced Macros |
Exploring Access SQL Integrating the Internet Managing Databases Security Fundamentals |
Public Schedule - Pricing and Availability
|
|||||||||
| Version | Date | Location | Places available |
Book | Next place rate (£) | List price |
|||
|---|---|---|---|---|---|---|---|---|---|
| Pay by Card |
Pay by Invoice |
||||||||
| 2007 | Tue 4 Jun 2013 | Limehouse | 9 |  |
£227 | £237 | £245 | ||
| 2010 | Thu 4 Jul 2013 | Bloomsbury | 6 | |
£285 | £295 | £299 | ||
| 2007 | Fri 30 Aug 2013 | Southwark | 8 | |
£211 | £221 | £245 | ||
| 2007 | Thu 10 Oct 2013 | Bloomsbury | 10 | |
£245 | £245 | £245 | ||
| 2010 | Thu 17 Oct 2013 | Bloomsbury | 10 | |
£150 | £160 | £299 | ||
| 2007 | Tue 3 Dec 2013 | Southwark | 9 | |
£75 | £85 | £245 | ||
| 2010 | Tue 3 Dec 2013 | Bloomsbury | 10 | |
£299 | £299 | £299 | ||
| 2010 | Wed 8 Jan 2014 | Southwark | 10 | |
£150 | £160 | £299 | ||
| 2007 | Fri 31 Jan 2014 | Southwark | 10 | |
£245 | £245 | £245 | ||
| 2010 | Mon 24 Feb 2014 | Bloomsbury | 10 | |
£299 | £299 | £299 | ||
| 2007 | Thu 3 Apr 2014 | Bloomsbury | 10 | |
£75 | £85 | £245 | ||
| 2010 | Fri 11 Apr 2014 | Limehouse | 10 | |
£150 | £160 | £299 | ||
| 2010 | Fri 23 May 2014 | Southwark | 10 | |
£299 | £299 | £299 | ||
| 2007 | Mon 23 Jun 2014 | Bloomsbury | 10 | |
£245 | £245 | £245 | ||
| 2010 | Thu 10 Jul 2014 | Bloomsbury | 10 | |
£150 | £160 | £299 | ||
| 2007 | Fri 29 Aug 2014 | Southwark | 10 | |
£75 | £85 | £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.