MS Access 2007 - Level 3

Your training in and use of Microsoft® Office Access™ 2007 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft® Office Access™ 2007. You have worked with the various Access objects, such as tables, queries, forms, and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.

After completing this course, students will be able to:

Analyze Tables Create a Junction Table Create Subqueries Summarize Data Using a Crosstab Query Create a PivotTable and a PivotChart Simplify Tasks with Macros Create and Attach a Macro Automate Data Entry Using a Macro Implement effective Use of Forms Include a Chart in a Report Create a Report Snapshot Maintain an Access Database Determine Object Dependency Analyze the Performance of a Database

Mode of delivery: Fully instructor-led classroom training
Duration:  8 hours

For more information click Course Details