Access 2007 Intermediate Course
2003 / 2010 courses - click here
London and UK wide
1 day instructor-led. Courses never cancelled: Guaranteed. From £75 (list price £235)
Training formats available
- on a public schedule at one of our London training venues
- on-site at your company office UK wide (60 second quote)
- closed group at one of our London training venues (60 second quote)
- 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 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.
Benefits
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 Working with related tables Defining data entry rules Using advanced query features |
Creating advanced queries Creating advanced form design Using advanced report features |
Public Schedule - Pricing and Availability
|
|||||||||
| Version | Date | Location | Places available |
Book | Next place rate (£) | List price |
|||
|---|---|---|---|---|---|---|---|---|---|
| Pay by Card |
Pay by Invoice |
||||||||
| 2007 | Mon 13 Feb 2012 | Southwark | 0 | FULL | £235 | ||||
| 2007 | Fri 16 Mar 2012 | Bloomsbury | 3 | ![]() |
£213 | £223 | £235 | ||
| 2007 | Wed 11 Jul 2012 | Bloomsbury | 7 | ![]() |
£148 | £158 | £235 | ||
| 2007 | Mon 24 Sep 2012 | Southwark | 8 | ![]() |
£148 | £158 | £235 | ||
| 2007 | Mon 15 Oct 2012 | Limehouse | 9 | ![]() |
£75 | £85 | £235 | ||
| 2007 | Wed 19 Dec 2012 | Bloomsbury | 10 | ![]() |
£75 | £85 | £235 | ||
| 2007 | Tue 29 Jan 2013 | Bloomsbury | 10 | ![]() |
£75 | £85 | £235 | ||
"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.
|
Learn The Secrets Of Customising An Autonumber Primary Key In Access This article shows you how to reset an auto numbered primary key in an Access table and how to create a customised auto number primary key - essential reading for Access users » Article: Microsoft access courses london |
» Forum post: Floating form |
Guide To Adding A Text Box Form Control In Access 2010 Once you've starting using Microsoft Access 2010 you'll no doubt have created forms based on your tables of data. All forms use text box Form controls to do this, and this short article describes what these are and summarises how to use them. » Article: Microsoft access courses london |



Course updates



