Course outline for
Microsoft Access 2010: Part One

About This Course

Course Prerequisites

Course Overview

Course Objectives

How To Use This Book

Lesson 1: Getting Started with Access

TOPIC A: Orientation to Microsoft Access

Microsoft Access 2010

Access Files

The Access 2010 Application Window

Tables

Forms

Queries

Reports

The Ribbon Interface

Activity 1-1

TOPIC B: Create a Simple Access Database

Database Templates

Using Database Objects

Setting Navigation Options

Save Options

Field Definition

Methods to Create a Form

Form Object Views

Form Sections

Activity 1-2

TOPIC C: Get Help in Microsoft Access

Access Help

Activity 1-3

Summary

Review Questions

Lesson 2: Working with Table Data

TOPIC A: Modify Table Data

AutoCorrect and Spell Check

Commit, Save, and Undo

Quick Search

The Find and Replace Dialog Box

Datasheet Totals

Activity 2-1

TOPIC B: Sort and Filter Records

The Sort Feature

The Filter Feature

Filter Commands

Activity 2-2

TOPIC C: Create Lookups

Lookup Fields

The Property Sheet Pane

Activity 2-3

TOPIC D: Format Text

Copying, Cutting, and Pasting

Using Paste Special

Using Font Tools

Using the Format Painter

Activity 2-4

Summary

Review Questions

Lesson 3: Querying a Database

TOPIC A: Join Data from Different Tables in a Query

Query Object Views

The Simple Query Wizard

Types of Queries

The Run Command

Query Design

Activity 3-1

TOPIC B: Sort and Filter Data in a Query

Query Criteria

Comparison Operators

Logical Operators

Sorting Query Results

Grouping Query Results

The Zoom Dialog Box

Activity 3-2

TOPIC C: Perform Calculations in a Query

Arithmetic Operators

Activity 3-3

Summary

Review Questions

Lesson 4: Creating Advanced Queries

TOPIC A: Create Parameter Queries

Parameter Queries

Wildcards and Parameter Queries

The Ampersand Operator

Activity 4-1

TOPIC B: Create Action Queries

Action Queries

Types of Action Queries

Activity 4-2

TOPIC C: Create Unmatched and Duplicate Queries

The Find Unmatched Query Wizard

The Find Duplicates Query Wizard

Activity 4-3

TOPIC D: Summarize Data

Crosstab Queries

PivotTables

PivotCharts

Activity 4-4

Summary

Review Questions

Lesson 5: Generating Reports

TOPIC A: Create Reports

Report Creation Tools

Report Object Views

The Report Wizard

Activity 5-1

TOPIC B: Add Controls to a Report

Report Sections

Control Properties

Activity 5-2

TOPIC C: Enhance the Appearance of a Report

Galleries

Themes

Activity 5-3

TOPIC D: Prepare a Report for Print

Page Setup Options

The Print Preview Tab

Activity 5-4

Summary

Review Questions

Lesson 6: Customizing the Access Environment

TOPIC A: The Access Options Dialog Box

Access Options

Activity 6-1

Summary

Review Questions

Lesson 7: Designing a Relational Database

TOPIC A: Relational Database Design

Relational Databases

The Relational Database Design Process

The Statement of Purpose

Existing Data

Guidelines for Determining Fields

Business Rules

Guidelines for Grouping Fields into Tables

Primary Keys

Foreign Keys

Composite Keys

Table Relationships

Activity 7-1

TOPIC B: Create a Table

Table Views

Data Types

Quick Start Fields

Calendar for Picking Dates

The Lookup Wizard

The Table Properties Dialog Box

Activity 7-2

TOPIC C: Manage Table Fields

Insert Fields

Rename Fields

Delete Fields

Hide and Unhide Fields

Freeze and Unfreeze Fields

Modify the Field Description

Activity 7-3

TOPIC D: Create Table Relationships

The Relationship View

Referential Integrity

Guidelines for Enforcing Referential Integrity

The Edit Relationships Dialog Box

Join Lines

Relationship Report

Activity 7-4

Summary

Review Questions

Lesson 8: Joining Tables

TOPIC A: Create Query Joins

Query Joins

Inner Joins

Outer Joins

The Join Properties Dialog Box

Activity 8-1

TOPIC B: Join Tables That Have No Common Fields

Joining Tables with No Common Fields

Activity 8-2

TOPIC C: Relate Data within a Table

Self-Joins

The Alias Property

Activity 8-3

TOPIC D: Work with Subdatasheets

Subdatasheets

Activity 8-4

TOPIC E: Create Subqueries

Subqueries

Activity 8-5

Summary

Review Questions

Lesson 9: Organizing a Database for Efficiency

TOPIC A: Data Normalization

First Normal Form

Second Normal Form

Third Normal Form

Denormalization

The Table Analyzer Wizard

Activity 9-1

TOPIC B: Create a Junction Table

Many-to-Many Relationships

Junction Tables

Activity 9-2

Summary

Review Questions

Lesson 10: Sharing Data Across Applications

TOPIC A: Import Data into Access

Data Importing

The Get External Data Wizard

Delimiters

Activity 10-1

TOPIC B: Export Data to Text File Formats

Data Exporting

Activity 10-2

TOPIC C: Export Access Data to Excel

Exporting Access Data to Excel

Activity 10-3

TOPIC D: Create a Mail Merge

The Microsoft Word Mail Merge Wizard

Merge Fields

The Mail Merge Task Pane

Activity 10-4

Summary

Review Questions

Lesson 11: Advanced Reporting

TOPIC A: Organize Report Information

Report Design Elements

Report Design Tools

Adding a Background Image to a Report

Activity 11-1

TOPIC B: Format Reports

The Rich Text Property

Report Format Tools

Report Control Properties

Report Pagination

Activity 11-2

TOPIC C: Include Charts in a Report

Data Bars

Charts

Activity 11-3

TOPIC D: Add a Calculated Field to a Report

Calculated Fields

Activity 11-4

TOPIC E: Add a Subreport to an Existing Report

Subreports

Activity 11-5

Summary

Review Questions

Lesson 12: Additional Reporting Options

TOPIC A: Create a Mailing Label Report

The Label Wizard

Activity 12-1

TOPIC B: Publish a Report as PDF

Publish a Report as PDF

Activity 12-2

Summary

Review Questions

Lesson Labs

Lesson 1

Lesson Lab 1-1

Lesson 2

Lesson Lab 2-1

Lesson Lab 2-2

Lesson 3

Lesson Lab 3-1

Lesson 4

Lesson Lab 4-1

Lesson Lab 4-2

Lesson 5

Lesson Lab 5-1

Lesson Lab 5-2

Lesson 6

Lesson Lab 6-1

Lesson 7

Lesson Lab 7-1

Lesson Lab 7-2

Lesson 8

Lesson Lab 8-1

Lesson Lab 8-2

Lesson 9

Lesson Lab 9-1

Lesson 10

Lesson Lab 10-1

Lesson Lab 10-2

Lesson 11

Lesson Lab 11-1

Lesson Lab 11-2

Lesson 12

Lesson Lab 12-1

Course Wrap-Up

Post-Course Assessment

Course Summary

Next Steps

Appendices

Keyboard Shortcut Quick Reference Sheet

Mapping to Microsoft Office Access 2010, Exam 77-885

Glossary

Index