Microsoft Access 2013 Advanced

This course builds upon basic Microsoft Access skills to help students become power users. In this advanced Microsoft Access 2013 course, students will delve deeper into the program by studying a dozen different topics. Modules in this course cover how to manage data and data entry; create forms, macros, and dialog boxes; create and use SQL queries; split databases; and much more.

 

After completing this course, students will be able to:

Manage Data

Create Advanced Table Tasks

Manage Data Entry in Tables

Create Subforms

Create Navigation Forms

Create Advanced Query Tasks

Create Modal Dialog Boxes

Split Databases

Use Access with SharePoint Server

Create Basic Macros

Create Advanced Macro Tasks

Use Visual Basic for Applications

–

Prerequisites

 

Before attending this course, students must have:

Windows 7 or 8

Microsoft Office Access 2013: Introduction

 

Topics

 

Module 1: Managing Data

Module 2: Advanced Table Tasks

Module 3: Managing Data Entry in Tables

Module 4: Creating Subforms

Module 5: Creating Navigation Forms

Module 6: Advanced Query Tasks

Module 7: Creating Modal Dialog Boxes

Module 8: Splitting the Database

Module 9: Using Access with SharePoint Server

Module 10: Creating Basic Macros

Module 11: Advanced Macro Tasks

Module 12: Using Visual Basic for Applications