Bookmark page
Printable version
Course updatesAccess Course London & UK wide
Microsoft Access 97 Intermediate
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 2003 Intermediate course is suitable those with a basic working knowledge of Microsoft Access.
Prerequisites
A rudimentary knowledge of Microsoft Access is required, or completion of our Microsoft Access Introduction course.
Benefits
This course has been created for delegates with a basic knowledge needing to increase their knowledge of Access to take advantage of the more complex features. By the end of the course delegates will have created relational databases and have worked with related tables, learning how to troubleshoot along the way. After studying advanced table design factors, 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 Advanced training course.
Course Syllabus
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 | 2 |  |
£213 | £223 | £235 | ||
| 2010 | Tue 20 Mar 2012 | Bloomsbury | 7 | |
£273 | £283 | £299 | ||
| 2003 | Wed 18 Apr 2012 | Southwark | 8 | |
£190 | £200 | £235 | ||
| 2010 | Thu 31 May 2012 | Southwark | 9 | |
£160 | £170 | £299 | ||
| 2003 | Wed 11 Jul 2012 | Southwark | 10 | |
£75 | £85 | £235 | ||
| 2007 | Wed 11 Jul 2012 | Bloomsbury | 7 | |
£148 | £158 | £235 | ||
| 2010 | Tue 7 Aug 2012 | Bloomsbury | 10 | |
£150 | £160 | £299 | ||
| 2007 | Mon 24 Sep 2012 | Southwark | 8 | |
£148 | £158 | £235 | ||
| 2010 | Tue 9 Oct 2012 | Southwark | 10 | |
£150 | £160 | £299 | ||
| 2003 | Thu 11 Oct 2012 | Southwark | 10 | |
£75 | £85 | £235 | ||
| 2007 | Mon 15 Oct 2012 | Limehouse | 9 | |
£75 | £85 | £235 | ||
| 2010 | Thu 6 Dec 2012 | Limehouse | 10 | |
£150 | £160 | £299 | ||
| 2003 | Fri 7 Dec 2012 | Southwark | 10 | |
£75 | £85 | £235 | ||
| 2007 | Wed 19 Dec 2012 | Bloomsbury | 10 | |
£75 | £85 | £235 | ||
| 2010 | Wed 16 Jan 2013 | Southwark | 10 | |
£150 | £160 | £299 | ||
| 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.
 |
Find Out About The Join Property In An Access Query This article recaps how to create a one to many relationship and then summarises how to use the join property in an Access query, and describes the two basic kinds of join properties, an inner join and outer join. » Article: Microsoft access course |
» Forum post: Removing duplicate information in reports |
Whenever I run a report collating information from various tables within my database, it repeats the information from each table at least twice (16 times in one case!). If I select "Hide Duplicates", it doesn't differentiate sufficiently - it g..
