Description
Learn Data Empowerment and Security in Microsoft Access 2010
Course Code: VTLOKMAAX
Duration: 3 Days (21 Hours)
A 3-day hands-on follow on course designed to equip user with the ability to construct advanced queries, design forms using pivot table and pivot chart for more complex data retrieval and record handling. Add controls to reports for more targeted results and layouts to suit your needs.
You will learn how to import and export into Microsoft Excel or to be used in Microsoft Word. Include macros (predefined list of actions) in Microsoft Access to simplify tasks. Learn how to jump into screens and panels quickly with Access’ switchboard features to save time. Receive valuable insights and tips to data handling and get the most out from Access.
This course is designed with appropriate hands-on exercises to allow you to practice key lessons taught to help you understand and become familiar with the components and features in Access.
This course is for
Learners who have attended our Microsoft Acess 2010 Basic to Intermediate course or for users with good working knowledge and experience in using Microsoft Access 2010.
Public Sector – Division 1, 2 & 3
Private Sector – Applicable to All
Course Outline
- Creating Summarized Queries
- Creating Crosstab Queries
- Creating Action Queries
- Designing Forms
- Creating Form with Pivot Table
- Creating Form with Pivot Chart
- Designing Advanced Reports
- Managing a Database
- Working with a Switchboard
- Working with Macros
Questions to Ask Yourself
I am a very experienced user of an earlier version of Microsoft Access; can I attend this course without attending Basic to Intermediate course?
If you have not used Microsoft Access 2007, no, we do not recommend that you skip this course. You are likely to find yourself lagging behind as you would be struggling to find or locate features in the 2007 version which is totally different from the earlier versions.
For Your Delight
Refreshments are provided for morning and afternoon tea breaks.A Certificate of Attendance will be given subject to 90% attendance.
Course Customisation
We can tailor this course to suit your needs in terms of course dates, times and location. If you are an organisation, we can further customise the course to meet your training needs and requirements.