Course outline for
Microsoft Office Access 2007 - Expert

Section 1: Add-ons to Access

Lesson 1.1: COM Add-Ins

What is a COM Add-In?

Using the Add-Ins Tab

Opening the Add-In Manager

Loading Add-Ins

Using the Trust Center

Step-By-Step

Skill Sharpener

Lesson 1.2: Digital Signatures

What is a Digital Signature?

Obtaining a Digital Signature

Attaching Your Signature to a Database

Skill Sharpener

Lesson 1.3: Smart Tags

What is a Smart Tag?

Inserting Smart Tags into a Database

Customizing Smart Tags

Setting Smart Tag Options

Step-By-Step

Skill Sharpener

Lesson 1.4: Managing Your Database

Analyzing Performance

Analyzing Tables

Viewing Object Dependencies

Splitting a Database

Database Replication

Step-By-Step

Skill Sharpener

Lesson 1.5: Customizing Access

Opening the Options Dialog

Overview of the Options Dialog

Changing User Information

Setting Security Options

Making Access Work Backwards

Step-By-Step

Skill Sharpener

Section 1: Case Study

Section 1: Review Questions

Section 2: Using Scripts in Access

Lesson 2.1: Macro Basics

Creating Macros

Playing Macros

Macro Security

Deleting Macros

Step-By-Step

Skill Sharpener

Lesson 2.2: Other Macro Tasks

Embedding a Macro

Assigning a Macro to a Keystroke

Assigning a Macro to an Event

Assigning a Macro to a Control

Step-By-Step

Skill Sharpener

Lesson 2.3: Visual Basic and Macros

Opening the Visual Basic Editor

Adding Code to your Macro

Adding Comments to VBA Code

Declaring Variables

Prompting for User Input

Using If-Then-Else Statements

Step-By-Step

Skill Sharpener

Lesson 2.4: Macro Groups

Creating a Macro Group

Running a Macro Group

Editing a Macro Group

Step-By-Step

Skill Sharpener

Section 2: Case Study

Section 2: Review Questions

Section 3: Using Access to Collaborate

Lesson 3.1: SharePoint Basics

What is SharePoint?

System Requirements

Creating a Workspace

Accessing a Workspace

Publishing to a Workspace

Step-By-Step

Skill Sharpener

Lesson 3.2: SharePoint Data

Using Offline Lists

Exporting a List

Restricting Permission for Data Objects

Skill Sharpener

Lesson 3.3: Your Personal SharePoint Space

Public and Private Views

Shared and Private Documents

Creating a List

Creating a Page

Personalizing your Space

Step-By-Step

Skill Sharpener

Section 3: Case Study

Section 3: Review Questions

Section 4: SQL and Microsoft Access

Lesson 4.1: Understanding SQL

What is an SQL Database?

What is an SQL Statement?

What is an SQL Convention?

What is SQL Syntax?

Linking a Database to an SQL Server

Step-By-Step

Skill Sharpener

Lesson 4.2: Using the SELECT Statement

Selecting All Data

Selecting Specific Data

Selecting Conditional Data

Using the ORDER BY Statement

Step-By-Step

Skill Sharpener

Lesson 4.3: Using Subqueries

What is a Subquery?

Creating a Subquery

Subqueries with Equality

Subqueries with Aggregate Functions

Nested Subqueries and Uses of the IN Keyword

Step-By-Step

Skill Sharpener

Lesson 4.4: Using SQL Joins

Creating Simple Joins

Using an Alias

Sorting Joins

Creating Outer Joins

Step-By-Step

Skill Sharpener

Section 4: Case Study

Section 4: Review Questions

Index