MS Access 2013 – Advanced

Course Overview

This MS Access 2013 Advance is designed for users who already have intermediate knowledge. By the end of the two days training programme, candidates would have a full understanding of MS Access concept and how to use the advanced features on Microsoft Access 2013.

Pre-requisite

It is recommended that candidates have good working knowledge of MS Access, which would have been gained at the basic/ intermediate level. Candidates MUST come with their laptops, with 2013 Access already installed.

Course Outline

• Aggregation and Calculations Queries
• Create Multi-table Queries
• Query with SQL
• Use of action Queries
• Parameter Queries
• Macros, Advance Macros and AutoExec
• Query Automation
• Importing , Exporting and Linking Objects
• Modifying Forms and Applying Macros on Forms
• Automating report
• Protect Databases

Course Duration

2 days

Course Package

• Detailed user manual
• Refreshments
• After course support
• Experienced Microsoft qualified tutor