Access 2013 Advanced Essentials Course Outline

Access 2013 Advanced Essentials

Module 1: Managing Data

Types of Relationships

Viewing Relationships

Viewing Object Dependencies

What is Referential Integrity?

Enforcing Referential Integrity

Using Cascade Delete and Cascade Update

Review Questions

Module 2: Advanced Table Tasks

Inserting Application Parts

Using the Table Analyzer Wizard

Creating Validation Rules

Configuring Validation Messages

Review Questions

Module 3: Managing Data Entry in Tables

Marking Fields as Required

Marking a Field for Indexing

Creating Lookup Fields

Creating Value Lists

Creating Input Masks

Review Questions

Module 4: Creating Subforms

Creating Subforms

Using Subforms

Linking Subforms with Parent Forms

Formatting a Subform within a Main Form

Review Questions

Module 5: Creating Navigation Forms

Creating a Navigation Form

Adding Tabs to a Navigation Form

Creating a Tab Hierarchy

Displaying the Navigation Form when the Database Opens

Review Questions

Module 6: Advanced Query Tasks

Understanding SQL Statements

Basic SQL Keywords

Creating SQL Queries

Using the Expression Builder

Review Questions

Module 7: Creating Modal Dialog Boxes

Creating a Modal Dialog Box

Adding Controls

Setting Properties

Formatting a Modal Dialog Box

Review Questions

Module 8: Splitting the Database

Backing Up the Database

Splitting the Database

Configuring Access 2013 for a Multi-User Database

Setting Record Locking Options

Review Questions

Module 9: Using Access with SharePoint Server

Linking Tables and Lists

Moving a Database to SharePoint

Saving a Database to SharePoint

About Access Web Apps

Review Questions

Module 10: Creating Basic Macros

Creating a Standalone Macro

Using the Action Catalog

Adding Comments to Macros

Using If-Then Actions

Handling Macro Errors

Review Questions

Module 11: Advanced Macro Tasks

Creating Event Procedures

Creating Data Macros

Creating Submacros

Grouping Submacros

Review Questions

Module 12: Using Visual Basic for Applications

Converting a Macro to Visual Basic

Using Visual Basic for Applications

Understanding Modules

Building Visual Basic Procedures

Review Questions