Instructor-led training - London Training Microsoft Access Advanced
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Advanced Microsoft Access Training London & UK wide

Microsoft Access 2002 XP Advanced

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

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

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

Access Advanced 1 day course Onsite/Closed Quote
Version Date Location Places
available
Book Next place rate (£) List
price
Pay by
Card
Pay by
Invoice
2007 Tue 4 Jun 2013 Limehouse 9 Book now £227 £237£245
2010 Thu 4 Jul 2013 Bloomsbury 6 Book now £285 £295£299
2007 Fri 30 Aug 2013 Southwark 8 Book now £211 £221£245
2007 Thu 10 Oct 2013 Bloomsbury 10 Book now £245 £245£245
2010 Thu 17 Oct 2013 Bloomsbury 10 Book now £150 £160£299
2007 Tue 3 Dec 2013 Southwark 9 Book now £75 £85£245
2010 Tue 3 Dec 2013 Bloomsbury 10 Book now £299 £299£299
2010 Wed 8 Jan 2014 Southwark 10 Book now £150 £160£299
2007 Fri 31 Jan 2014 Southwark 10 Book now £245 £245£245
2010 Mon 24 Feb 2014 Bloomsbury 10 Book now £299 £299£299
2007 Thu 3 Apr 2014 Bloomsbury 10 Book now £75 £85£245
2010 Fri 11 Apr 2014 Limehouse 10 Book now £150 £160£299
2010 Fri 23 May 2014 Southwark 10 Book now £299 £299£299
2007 Mon 23 Jun 2014 Bloomsbury 10 Book now £245 £245£245
2010 Thu 10 Jul 2014 Bloomsbury 10 Book now £150 £160£299
2007 Fri 29 Aug 2014 Southwark 10 Book now £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.



Access training London
Course rating:
4.8 stars - based on 4042 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Facebook · Twitter · Google+ · LinkedIn · Pinterest