|
|
Need help or advice?
We'll call during UK business hours
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
160 Access events in the next 12 months, live dates & pricing here |
Who is this course for?
Our advanced Micorosoft Access training 2010 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 2010 Intermediate course.
Objectives
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 2010 PivotTables and PivotCharts Create a PivotTable Creating Advanced Forms Designing a form based on joined tables Macros Create and run macros Creating Advanced Macros Create macros to provide user interaction | Exploring Access SQL How to identify different clauses in an SQL statement Integrating the Internet Work with hyperlink fields Managing Databases Work with database utilities to optimise resources Security Fundamentals Protect databases |
|
|||||||||
| Version | Date | Location | Places available |
Book | Next place rate (£) | List price |
|||
|---|---|---|---|---|---|---|---|---|---|
| Pay by Card |
Pay by Invoice |
||||||||
| 2010 | Thu 4 Jul 2013 | Bloomsbury | 6 |  |
£278 | £288 | £299 | ||
| 2010 | Mon 2 Sep 2013 | Limehouse | 10 | |
£299 | £299 | £299 | ||
| 2010 | Thu 17 Oct 2013 | Bloomsbury | 10 | |
£150 | £160 | £299 | ||
| 2010 | Thu 28 Nov 2013 | Southwark | 10 | |
£299 | £299 | £299 | ||
| 2010 | Wed 8 Jan 2014 | Southwark | 10 | |
£150 | £160 | £299 | ||
| 2010 | Fri 11 Apr 2014 | Limehouse | 10 | |
£150 | £160 | £299 | ||
| 2010 | Thu 10 Jul 2014 | Bloomsbury | 10 | |
£150 | £160 | £299 | ||
What you get
 |
Training is held in our modern, comfortable, air-conditioned suites Modern-spec IT, fully networked with internet access |
"What do I get on the day?" |
Learning tools |
 Breaks and timingCourses start at 9:30am. |
 In-course handbookContains unit objectives, exercises and space to write notes |
 RefreshmentsAvailable throughout the day:
|
 Reference materialAvailable online. 100+ pages with step-by-step instructions |
 LunchLunch is provided at a local restaurant or pub. Browse the sample menus: |
 24 months access to Microsoft trainersYour questions answered by Microsoft qualified trainers online. |
Training Formats & Services
|
Some reasons why thousands of businesses trust us
|
|
Some of our clients:
|
