Instructor-led training - Access in London Microsoft Advanced

verified by visa - mastercard securecode

about microsoft training company london uk

Add to favourites

Printable version

Email 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

Customer account

New booking

Enquiries

Contact us Training vacancies

Information

Pricing and availability Access 2003 Advanced Forum Hints and tips Location/map/parking

Training

Public schedule On-site training Closed company E-Learning

Pricing

Public schedule On-site training Closed company E-Learning

Advanced Microsoft Access in 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:

"The trainer was really good."
Julia B, Murphy Group
[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]

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

Related Links

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

Microsoft Access 2003 Advanced

Microsoft Access 1 day instructor-led, courses never cancelled, 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?

Our advanced Micorosoft Access training 2003 course is suitable for those with a sound working knowledge of Access who wish to progress to the most complicated functions and features.

Prerequisites

A working knowledge of Access or our Access Intermediate course will allow sufficient knowledge to attend our access advanced courses.

Benefits

At the end of this course you will have a complete understanding of the higher functions of Access. You will learn to automate functions by creating simple and then very advanced macros. You will advance your querying ability and then to use SQL statements in your queries. You will discover how to work with objects, and the fundamentals of database management. Finally you will be taught how to protect your valuable data sources.

You will then be qualified 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:
Access Advanced 1 day course				List price £245
Version	Date	Location	Places available	Book	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.

We offer training for advanced microsoft access in london and UK wide.

Institute of IT Training - Accredited Training Provider

Institute of IT Training - Accredited Training Provider

Prodigy Platinum Learning Partner

Microsoft Office Specialist Authorised Testing Centre

Association of Computer Trainers

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 Software Training London. All Rights Reserved. A Microsoft software training company. info (at) microsofttraining (dot) net
All prices offered for business users and exclude VAT. E&OE