Course outline for
Microsoft Office Access 2010 - Intermediate

Introduction

Prerequisites

Section 1: Advanced File Tasks

Lesson 1.1: Using Windows Explorer within Access

Navigating with Windows Explorer

Performing Basic Tasks with Windows Explorer

Changing Views in Windows Explorer

Using the Navigation Pane

Step-By-Step

Skill Sharpener

Lesson 1.2: Database Management

Compact and Repair a Database

Backing Up your Database

Editing Database Properties

Adding or Removing Database Passwords

Step-By-Step

Skill Sharpener

Lesson 1.3: Saving Your Files

Using the Save As Dialog

An Overview of Additional Database Formats

Packaging a Database

About AutoRecover

Step-By-Step

Skill Sharpener

Lesson 1.4: Exporting Files

Exporting to PDF or XPS

Exporting to Microsoft Office Word and Excel

Exporting to Other Destinations

Using Saved Exports

Packaging and Signing Data

Exporting to Older Versions of Access

Step-By-Step

Skill Sharpener

Lesson 1.5: Linking Files

Linking to a Microsoft Excel Spreadsheet

Linking to Another Database

Linking to a SharePoint Site

Other Types of Linked Documents

Creating Hyperlinks

Step-By-Step

Skill Sharpener

Section 1: Case Study

Section 1: Review Questions

Section 2: Working with Tables

Lesson 2.1: Customizing Tables

Understanding Field Properties

Adding a Primary Key

Indexing a Field.

Inserting, Deleting, and Moving Fields

Adding Quick Start Elements

Importing a Table from another Source

Step-By-Step

Skill Sharpener

Lesson 2.2: Formatting Tables.

Formatting Number Fields

Formatting Text Fields

Adding Field Descriptions

Changing Field Data Types

Adding Captions

Step-By-Step

Skill Sharpener

Lesson 2.3: Controlling Table Data Entry

Setting a Default Value

Setting a Required Value

Creating and Using Input Masks

Creating and Removing Table Relationships

Step-By-Step

Skill Sharpener

Lesson 2.4: Managing Table Data Entry

Using the Table Tools - Design Tab

Validating Data

Creating a Lookup Field

Modifying a Lookup Field

Creating a Value List

Modifying a Value List

Step-By-Step

Skill Sharpener

Section 2: Case Study

Section 2: Review Questions

Section 3: Working with Forms

Lesson 3.1: Basic Form Controls

Types of Forms

Types of Form Controls

Adding a Control

Using the Control Wizard

Cutting, Copying, Pasting, and Moving a Control

Formatting a Control

Step-By-Step

Skill Sharpener

Lesson 3.2: Advanced Form Controls

Modifying a Control's Properties

Changing a Control's Data Source

Changing a Control's Default Value

Creating a Calculated Control

Using Form Properties

Step-By-Step

Skill Sharpener

Lesson 3.3: Formatting Your Form

Formatting Gridlines

Modifying the Font

Adding Logos

Changing the Layout

Step-By-Step.

Skill Sharpener

Lesson 3.4: Formatting Controls

Changing the Color of a Control

Using Control Properties

Aligning and Sizing Controls

Applying Special Effects

Step-By-Step

Skill Sharpener

Lesson 3.5: Using Themes

Using Themes

Modifying Fonts

Modifying Colors

Saving Customized Themes

Step-By-Step

Skill Sharpener

Section 3: Case Study

Section 3: Review Questions

Section 4: Working with Reports

Lesson 4.1: Organizing Report Data

Adding and Removing Fields

Using Report Sections

Changing Section Properties

Grouping and Sorting in a Report

Doing More with Grouping and Sorting

Using Calculated Controls in a Report

Step-By-Step

Skill Sharpener

Lesson 4.2: Formatting Reports

Formatting Gridlines

Modifying the Font

Adding Logos

Changing the Layout

Using Themes

Step-By-Step

Skill Sharpener

Lesson 4.3: Common Report Tasks

Adding a Photo

Adjusting Page Properties

Adding Page Numbers

Using the Label Wizard

Adding Conditional Formatting

Step-By-Step

Skill Sharpener

Section 4: Case Study

Section 4: Review Questions

Section 5: Working with Queries

Lesson 5.1: Basic Queries

Review of Queries

Creating a Query

Sorting a Query

Filtering a Query

Showing and Hiding Fields

Step-By-Step.

Skill Sharpener

Lesson 5.2: Doing More with Queries

Using AND/OR Operators

About IIF Functions

Creating Multiple Table Queries

Creating a Calculated Field

About the Expression Builder

Using Queries to Summarize Data

Step-By-Step

Skill Sharpener

Lesson 5.3: Creating Advanced Queries

Creating a Parameter Query

Using Parameter Queries

Creating Crosstab Queries

Using Crosstab Queries

Using Make-Table Queries

Step-By-Step

Skill Sharpener

Lesson 5.4: Creating Management (Action) Queries

Append Queries

Delete Queries

Update Queries

Exporting Queries

Step-By-Step

Skill Sharpener

Section 5: Case Study

Section 5: Review Questions

Index