Access 2007 Advanced Course

Testimonials

Some feedback from recent courses:

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

"The trainer was really good."
Julia B, Murphy Group
[Access Advanced]

"Very imformative and well presented. Trainer was very knowledgable and easy to understand."
Nerine W, Siemens Shared Services
[Access Advanced]

London and UK wide

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?

Our advanced Micorosoft Access training 2007 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 is required, or our Access 2007 Intermediate course.

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

What's new in Access 2007

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

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 2007 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	2009 Aug 26 Wed	Bloomsbury	9	book now	£218	£225
2007	2009 Dec 23 Wed	Bloomsbury	10	book now	£75	£225
2007	2010 Jan 27 Wed	Bloomsbury	9	book now	£75	£225
2007	2010 Mar 24 Wed	Bloomsbury	10	book now	£75	£225

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