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.

Updated on 08 November, 2015

About SureSkills Ltd

We have been growing our expertise, service offering and solution delivery for the past two decades. One of the largest IT training companies in Ireland, we deliver our global learning solutions worldwide against a backdrop of integrated learning and consulting experience. Our in-house expertise allows for synergy between our three divisions; training & certification, learning services and consulting and solutions. 

See all SureSkills Ltd courses
Are you from SureSkills Ltd ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Access starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or