Bookmark page
Printable version
Course updatesAccess 2010 Advanced Course
2007 / 2003 courses - click here
London and UK wide
1 day instructor-led. Courses never cancelled: Guaranteed. From £150 (list price £299)
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 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.
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 2010 PivotTables and PivotCharts Creating Advanced Forms Macros Creating Advanced Macros |
Exploring Access SQL Integrating the Internet Managing Databases Security Fundamentals |
Public Schedule - Pricing and Availability
|
|||||||||
| Version | Date | Location | Places available |
Book | Next place rate (£) | List price |
|||
|---|---|---|---|---|---|---|---|---|---|
| Pay by Card |
Pay by Invoice |
||||||||
| 2010 | Wed 21 Mar 2012 | Limehouse | 9 |  |
£263 | £273 | £299 | ||
| 2010 | Fri 1 Jun 2012 | Southwark | 9 | |
£160 | £170 | £299 | ||
| 2010 | Thu 9 Aug 2012 | Limehouse | 10 | |
£150 | £160 | £299 | ||
| 2010 | Fri 14 Sep 2012 | Bloomsbury | 10 | |
£150 | £160 | £299 | ||
| 2010 | Wed 9 Jan 2013 | Southwark | 10 | |
£150 | £160 | £299 | ||
"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.
 |
How To Filter And Sort Data In Access 2010 Tables The advantage of having direct access to the data tables is that you don’t always have to write a query or a report in order to get to the data you want to see. Sometimes it is necessary to check for a specific record or alter something directly in the table, without having to write a SQL statement to do it. Filtering and sorting can be used instead and this article explains how. » Article: Database+courses+london |
» Tip: Case Keyboard short-cut |
A very good course which has really helped me brush up my knowledge. Thanks! Clark
|
|
» Forum post: Link to graphic |
To change case from upper or lower case, highlight the text area, hold down the Shift key and press F3
What is the best way to link to a graphic within access. assuming the graphics are held in a folder outside of access/the database.
