Access 2013 Advanced

Course details

The Advanced Access 2013 training course is designed for existing users of Access who want to customize forms, queries and reports.

Objectives

You will learn how to create Subforms and Navigation Forms, Create SQL Queries, Create a Modal Dialog Box, Split a Database, Create Macros and Use Visual Basic for Applications.

Content

Creating Subforms & Navigation Forms

• Create Subforms
• Link Subforms with Parent Forms
• Format a Subform within a Main Form
• Create a Navigation Form
• Add Tabs to a Navigation Form
• Create a Tab Hierarchy
• Display the Navigation Form when the Database Opens

Advanced Query Tasks

• Understand SQL Statements and Keywords
• Create SQL Queries
• Use the Expression Builder

Creating Modal Dialog Boxes

• Create a Modal Dialog Box
• Add Controls
• Set Properties
• Format a Modal Dialog Box

Splitting the Database

• Back up the Database
• Split the Database
• Configure Access 2013 for a Multi-Use Database
• Set Record Locking Options

Creating Basic Macros

• Create a Standalone Macro
• Use the Action Catalogue
• Add Comments to Macros
• Use IF-Then Actions
• Handle Macro Errors

Advanced Macro Tasks

• Create Event Procedures
• Create Data Macros
• Create Submacros
• Group Submacros

Using Visual Basic for Applications

• Convert a Macro to Visual Basic
• Use Visual Basic for Applications
• Understand Modules
• Build Visual Basic Procedures

Prerequisites

It is also recommended that proposed delegates have attended a Microsoft Access 2010 Introduction/Intermediate course or have obtained comparable knowledge from the workplace.

Who should attend?

Existing users of Microsoft Access who want to customise forms, queries and reports.