Microsoft Access 2013 Advanced

Course details

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.

What will I learn?

1. Simple Query Wizard
2. Summarise Data
3. Action Queries
   • Make-Table
   • Append
   • Delete
   • Update
   • Crosstab
4. Form Design
   • Create a Standard Form
   • Manipulating Layouts
   • Working with Form Template
   • Form Control Essentials
5. Report Design
   • Working with Controls
   • Add Field
   • Page Break
   • Creating Serial Number on a Report
   • Adding the Calculated Control
6. Macro
   • If…then…Else Macro Block
   • Adding Comments
   • Submacros
   • Group Macro
   • Built-in Functions
   • Standalone Macro
   • Embed Macro to Form Control
   • Connect Macro to Table
7. Navigation System
   • Build Forms with Navigation
   • Using MSysObjects
   • Create Navigation Forms
   • Designating a Startup Form

Who is this course for?

Learners who have attended our Microsoft Acess 2013 Basic to Intermediate course or for users with good working knowledge and experience in using Microsoft Access 2013.