Bookmark page
Printable version
Course updatesAccess 2007 Advanced Course
2003 / 2010 courses - click here
London and UK wide
1 day instructor-led. Courses never cancelled: Guaranteed. From £75 (list price £245)
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 2007 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 2007 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 2007 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 |
||||||||
| 2007 | Wed 29 Feb 2012 | Southwark | 7 |  |
£232 | £242 | £245 | ||
| 2007 | Wed 28 Mar 2012 | Bloomsbury | 4 | |
£232 | £242 | £245 | ||
| 2007 | Thu 21 Jun 2012 | Southwark | 0 | FULL | £245 | ||||
| 2007 | Mon 13 Aug 2012 | Limehouse | 10 | |
£75 | £85 | £245 | ||
| 2007 | Mon 17 Dec 2012 | Limehouse | 9 | |
£75 | £85 | £245 | ||
| 2007 | Wed 30 Jan 2013 | Southwark | 10 | |
£75 | £85 | £245 | ||
| 2007 | Wed 27 Feb 2013 | Southwark | 10 | |
£75 | £85 | £245 | ||
"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.
 |
Sub-reports And Sub-forms In Access 2007 Reports can be tricky, complicated things, balancing separate strands of information and sets of data and always trying to make sense of every relevant relationship and interconnection. Fortunately help is at hand thanks to Microsoft Access 2007 and its ability to craft sub-reports to help you better manage your data. » Article: Access+course |
» Forum post: Criteria Query |
I want to create a query when I only get details of people who are older than a certain date. I have set up date of birth in tables with an input mask of short date, but when I query it with <00/00/00 I get a modified query <the day rather than the..
