|
|
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 Microsoft Access 2007 Intermediate course is suitable for those with a basic working knowledge of Microsoft Access.
Prerequisites
A working knowledge of Access is required, or our Access 2007 Introduction course.
Objectives
This course is designed for those users who wish to step their current knowledge of Access to take advantage of the more complex features. On completion delegates will understand relational databases and be able to work with related tables. They will learn how to generate much more complicated queries and create more advanced forms and reports before tackling PivotCharts and PivotTables.After completing this course you will be prepared to attend the Access 2007 Advanced training course.
Course Syllabus
|
What's new in Access 2007 Creating relational databases Database normalising Working with related tables The lookup wizard Defining data entry rules Using input masks Using advanced query features How to join a table in queries | Creating advanced queries Summarise and group values Creating advanced form design Working with graphics Using advanced report features Create customized headers and footers |
|
|||||||||
| Version | Date | Location | Places available |
Book | Next place rate (£) | List price |
|||
|---|---|---|---|---|---|---|---|---|---|
| Pay by Card |
Pay by Invoice |
||||||||
| 2007 | Tue 6 Aug 2013 | Limehouse | 9 |  |
£204 | £214 | £235 | ||
| 2007 | Mon 23 Sep 2013 | Southwark | 9 | |
£189 | £199 | £235 | ||
| 2007 | Wed 16 Oct 2013 | Limehouse | 9 | |
£75 | £85 | £235 | ||
| 2007 | Tue 3 Dec 2013 | Limehouse | 10 | |
£235 | £235 | £235 | ||
| 2007 | Thu 9 Jan 2014 | Southwark | 10 | |
£75 | £85 | £235 | ||
| 2007 | Tue 4 Mar 2014 | Bloomsbury | 10 | |
£235 | £235 | £235 | ||
| 2007 | Thu 15 May 2014 | Limehouse | 10 | |
£75 | £85 | £235 | ||
| 2007 | Wed 16 Jul 2014 | Bloomsbury | 10 | |
£75 | £85 | £235 | ||
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:
|
