Course outline for
Microsoft Office Access 2010 - Advanced

Introduction

Prerequisites

Section 1: Advanced Data Management

Lesson 1.1: Referential Integrity

Using Relationship View

Using the Relationship Tools - Design Tab

Types of Relationships

Establishing Referential Integrity

Enforcing Referential Integrity

Testing Referential Integrity

Step-By-Step

Skill Sharpener

Lesson 1.2: Table Relationships

About Join Lines

Normalizing Tables

Using the Table Analyzer Wizard

Using Cascade Delete and Cascade Update

Setting Fields for Indexing

Using the Index

Step-By-Step

Skill Sharpener

Lesson 1.3: An Introduction to SQL

What is SQL?

Parts of an SQL Statement

SQL Keywords

Creating SQL Queries

Adding WHERE Clauses

Step-By-Step

Skill Sharpener

Lesson 1.4: Modal Dialog Boxes

Creating a Modal Dialog Box

Adding Controls

Setting Properties

Formatting your Dialog Box

Step-By-Step

Skill Sharpener

Section 1: Case Study

Section 1: Review Questions

Section 2: Advanced Form Tasks

Lesson 2.1: Using Subforms

Creating a Subform

Creating a Form and a Subform

Modifying a Subform

Working with a Subform

Synchronizing Subform Data with a Parent Form

Displaying a Subform within a Main Form

Step-By-Step

Skill Sharpener

Lesson 2.2: Creating a Navigation Form

Creating a Navigation Form

Adding Tabs to a Navigation Form

Creating a Tab Hierarchy

Modifying a Navigation Form

Displaying the Navigation Form when the Database Opens

Step-By-Step

Skill Sharpener

Lesson 2.3: Advanced Form Controls

Limiting User Access to a Form

Creating Check Boxes and Command Buttons

Building Command Button Events

Creating Event Procedures

Step-By-Step

Skill Sharpener

Lesson 2.4: Exporting a Form

Exporting Your Form to XML

Exporting a Form as a Word Document

Exporting a Form as HTML

Sending a Form as an E-mail Attachment

Exporting a Form to Other Formats

Step-By-Step

Skill Sharpener

Lesson 2.5: Other Form Tasks

Using Hyperlinks in a Form

Adding Links to Other Database Objects

Inserting a Mailto Link in a Form

Adding a Browser Control to a Form

Performing Calculations in a Form

Step-By-Step

Skill Sharpener

Section 2: Case Study

Section 2: Review Questions

Section 3: Pivoting Data

Lesson 3.1: Creating a PivotTable

About PivotTables

Creating a PivotTable

Adding Fields to PivotTables

Basic PivotTable Tasks

Step-By-Step

Skill Sharpener

Lesson 3.2: Using PivotTables

Pivoting Data

Refreshing PivotTable Data

Hiding and Showing PivotTable Data

Grouping PivotTable Data

Step-By-Step

Skill Sharpener

Lesson 3.3: Advanced PivotTable Tasks

Using the Properties Dialog

Exporting a PivotTable to Excel

Importing Excel Data

Creating a PivotTable with Excel Data

Step-By-Step

Skill Sharpener

Lesson 3.4: Creating a PivotChart

About PivotCharts

Creating a PivotChart

More about PivotChart Fields

Completing your PivotChart

Step-By-Step

Skill Sharpener

Lesson 3.5: Using PivotCharts

Modifying a PivotChart

Creating a PivotTable and PivotChart from the Same Object

Adding Axis Titles and a Legend

Changing the Chart Type

Step-By-Step

Skill Sharpener

Section 3: Case Study

Section 3: Review Questions

Section 4: Advanced Topics

Lesson 4.1: Access and Windows

Recovering Access

Backing Up an Access Database

Restoring a Database from a Backup Copy

Starting Access on Windows Boot

Repairing Access 2010

Step-By-Step

Skill Sharpener

Lesson 4.2: Splitting Your Database

Why Split your Database?

Splitting the Database

Configuring Access 2010 for a Multi-User Database

Setting Record Locking Options

Step-By-Step

Skill Sharpener

Lesson 4.3: Using Outlook with Access

Importing Contacts from Outlook

Linking to an Outlook Folder

Collecting Data with an E-mail Form

Managing Replies

Step-By-Step

Skill Sharpener

Lesson 4.4: Using Access 2010 with SharePoint Server

Understanding SharePoint Server

System Requirements

Important Terminology

Linking Tables and Lists

Moving a Database to SharePoint

Saving a Database to SharePoint

Step-By-Step

Skill Sharpener

Lesson 4.5: Access and Web Databases

Creating a Web Database

Using Web Database Templates

Checking Compatibility

Publishing a Web Database

Step-By-Step

Skill Sharpener

Section 4: Case Study

Section 4: Review Questions

Section 5: Macros and Visual Basic for Applications (VBA)

Lesson 5.1: Macro Basics

Creating Macros

Macros as Event Procedures

Program Control with If-Then-Else Statements

Using Macros in Tables

Step-By-Step

Skill Sharpener

Lesson 5.2: More about Macros

Embedded Macros

Adding Comments to Macros

Creating a Submacro

Grouping Submacros

Handling Macro Errors

Step-By-Step

Skill Sharpener

Lesson 5.3: Access and VBA

Converting a Macro to VBA

Using the VBA Editor

Building VBA Procedures

Declaring Variables

Gathering Information with DLookup

Adding Comments to VBA Code

Step-By-Step

Skill Sharpener

Lesson 5.4: Building Advanced Procedures

Using Message Boxes

Using Input Boxes

Using the DoCmd Object

Handling VBA Errors

Step-By-Step

Skill Sharpener

Lesson 5.5: Using VBA in a Database

Using VBA and Combo Boxes

Handling Run-Time Errors Using Error Numbers

Enabling and Disabling Form Controls

Preparing a Form for a New Record

Step-By-Step

Skill Sharpener

Section 5: Case Study

Section 5: Review Questions

Index