Advanced Access
MS Access 2007-
2010

|
 |
Introduction Access Training
Our introduction Access training course is aimed at the complete beginner, so this course is for people who have never used Access before, or have had a little experience in using Access. At the end of this introduction Access training course you will have a firm grasp of the basics of Access and databases. You will be able to design and create a database from scratch and you will have a practical understanding of tables, forms, reports and simple queries.
Intermediate Access Training
Our intermediate course is suitable for those that have already taken our introduction course or if you have a fairly basic working knowledge of Access. During the course you will learn how to use the slightly more advanced features of Access that you may not have encountered before. You will then move on and learn about the more complex queries, forms and reports. Finally you will tackle PivotTables and PivotCharts.
If you wish to further your knowledge of Microsoft Access after taking the intermediate Access training you could move on and attend the advanced Access training course.
Advanced Access Training
Our advanced Access training course is suitable for anyone who has previously taken our intermediate course or for those with a solid working knowledge of Access who wish to progress to learn the most complicated features.
Once you have completed the course you will have learnt to automate functions using both simple and complex macros, you will have again improved your knowledge of queries and acquired practical experience of working with SQL statements. You will also have gained a knowledge of how to work with objects and the principals of database management.
For more details about our advanced Access training or any of our Access training courses, please see our Access overview page.
If after taking an advanced Access training course, you still want to further your knowledge of Access, you can look into taking an Access VBA training course.
MOS certifications
Gain Microsoft Office Specialist (MOS) certification from our Microsoft authorised testing centres. The MOS certification is the only credential of its kind approved by Microsoft and demonstrates end-user proficiency with Microsoft Office products.
The MOS certificate illustrates a measurement of proficiency in Microsoft Office applications. Successful qualified candidates gain the recognition for having advanced desktop Office skills. Professionals and students will then be able to confirm their expertise in the Microsoft Office suite. After taking an advanced Access training course, why not cement your skills with the MOS certification. 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.
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.
|
|
|
| |