Instructor-led training - access 2007 advanced course
Microsoft Office Training verified by visa - mastercard securecode about microsoft training company london ukadd this page to your favourites/bookmarksAdd to favourites
view a printable version of this pagePrintable version
email this page to somebodyEmail 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
 
spacer Customer account
At a glance
 
spacer New booking
Choose courses
 
spacer Enquiries
Contact usTraining vacancies
 
spacer Information
Pricing and availabilityAccess 2007 AdvancedForumHints and tipsLocation/map/parking
 
spacer Training
Public schedule On-site training Closed company E-Learning
 
spacer Pricing
Public schedule On-site training Closed company E-Learning

Access 2007 Advanced Course

London and UK wide

Microsoft Access 1 day instructor-led, courses never cancelled, from £75 (list price £245)

Training formats available

Currently demand for public schedule is growing slowly and dates will be scheduled accordingly.

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
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 2007 1 day course List price £245
Version Date Location Places
available
Book Next place rate:
Card Invoice
2007 2008 Jun 25 Wed Bloomsbury 6 book now £229 £240
2007 2008 Jul 25 Fri Bloomsbury 6 book now £218 £240
2007 2008 Sep 24 Wed Bloomsbury 0 FULL    
2007 2009 May 27 Wed Bloomsbury 8 book now £75 £240
2007 2009 Jun 24 Wed Bloomsbury 8 book now £75 £240
2007 2009 Jul 29 Wed Bloomsbury 8 book now £75 £240
2007 2009 Aug 26 Wed Bloomsbury 8 book now £75 £240
2007 2009 Sep 30 Wed Bloomsbury 8 book now £75 £240
2007 2009 Oct 28 Wed Bloomsbury 8 book now £75 £240
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.

Institute of IT Training - Accredited Training Provider Institute of IT Training - Accredited Training Provider Prodigy Platinum Learning Partner Microsoft Office Specialist Authorised Testing Centre

Microsoft Registered Partner
microsoft office
ms office project server

Association of Computer Trainers Valid HTML 4.01 Transitional
Valid CSS Markup

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