Microsoft Office Access 2007: Level 1 (Second Edition)

Course Content

Lesson 1: Exploring the Microsoft Office Access 2007 Environment
Topic 1A: Examine Database Concepts
Topic 1B: Explore the User Interface
Topic 1C: Use an Existing Access Database
Topic 1D: Customize the Access Environment
Topic 1E: Obtain Help

Lesson 2: Designing a Database
Topic 2A: Describe the Relational Database Design Process
Topic 2B: Define Database Purpose
Topic 2C: Review Existing Data
Topic 2D: Determine Fields
Topic 2E: Group Fields into Tables
Topic 2F: Normalize DataTopic 2G: Designate Primary and Foreign Keys
Topic 2H: Determine Table Relationships

Lesson 3: Building a Database
Topic 3A: Create a New Database
Topic 3B: Create a Table
Topic 3C: Manage Tables
Topic 3D: Create a Table Relationship
Topic 3E: Save a Database as a Previous Version

Lesson 4: Managing Data in a Table
Topic 4A: Modify Table Data
Topic 4B: Sort Records
Topic 4C: Work with Subdatasheets

Lesson 5: Querying a Database
Topic 5A: Filter Records
Topic 5B: Create a Query
Topic 5C: Add Criteria to a Query
Topic 5D: Add a Calculated Field to a Query
Topic 5E: Perform Calculations on a Record Grouping

Lesson 6: Designing Forms
Topic 6A: View Data Using an Access Form
Topic 6B: Create a Form
Topic 6C: Modify the Design of a Form

Lesson 7: Generating Reports
Topic 7A: View an Access Report
Topic 7B: Create a Report
Topic 7C: Add a Custom Calculated Field to a Report
Topic 7D: Format the Controls in a Report
Topic 7E: Apply an AutoFormat Style to a Report
Topic 7F: Prepare a Report for Print

Microsoft Office Access 2007: Level 2 (Second Edition)
Course Content

Lesson 1: Controlling Data Entry
Topic 1A: Restrict Data Entry Using Field Properties
Topic 1B: Establish a Pattern for Entering Field Values
Topic 1C: Create a List of Values for a Field

Lesson 2: Joining Tables
Topic 2A: Create Query Joins
Topic 2B: Join Unrelated Tables
Topic 2C: Relate Data Within a Table

Lesson 3: Creating Flexible Queries
Topic 3A: Set Select Query Properties
Topic 3B: Create Parameter Queries
Topic 3C: Create Action Queries

Lesson 4: Improving Forms
Topic 4A: Design a Form Layout
Topic 4B: Enhance the Appearance of a Form
Topic 4C: Restrict Data Entry in Forms
Topic 4D: Add a Command Button to a Form
Topic 4E: Create a Subform

Lesson 5: Customizing Reports
Topic 5A: Organize Report Information
Topic 5B: Format the Report
Topic 5C: Set Report Control Properties
Topic 5D: Control Report Pagination
Topic 5E: Summarize Report Information
Topic 5F: Add a Subreport to an Existing Report
Topic 5G: Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications
Topic 6A: Import Data into Access
Topic 6B: Export Data
Topic 6C: Analyze Access Data in Excel
Topic 6D: Export Data to a Text File
Topic 6E: Merge Access Data with a Word Document

Microsoft Office Access 2007: Level 3 (Second Edition)
Course Content

Lesson 1: Structuring Existing Data
Topic 1A: Analyze Tables
Topic 1B: Create a Junction Table
Topic 1C: Improve Table Structure

Lesson 2: Writing Advanced Queries
Topic 2A: Create Subqueries
Topic 2B: Create Unmatched and Duplicate Queries
Topic 2C: Group and Summarize Records Using Criteria
Topic 2D: Summarize Data Using a Crosstab Query
Topic 2E: Create a PivotTable and a PivotChart

Lesson 3: Simplifying Tasks with Macros
Topic 3A: Create a Macro
Topic 3B: Attach a Macro
Topic 3C: Restrict Records Using a Condition
Topic 3D: Validate Data Using a Macro
Topic 3E: Automate Data Entry Using a Macro

Lesson 4: Making Effective Use of Forms
Topic 4A: Display a Calendar on a Form
Topic 4B: Organize Information with Tab Pages
Topic 4C: Display a Summary of Data in a Form

Lesson 5: Making Reports More Effective
Topic 5A: Include a Chart in a Report
Topic 5B: Print Data in Columns
Topic 5C: Cancel Printing of a Blank Report
Topic 5D: Create a Report Snapshot

Lesson 6: Maintaining an Access Database
Topic 6A: Link Tables to External Data Sources
Topic 6B: Manage a Database
Topic 6C: Determine Object Dependency
Topic 6D: Document a Database
Topic 6E: Analyze the Performance of a Database

Microsoft Office Access 2007: New Features
Course Content

Lesson 1: Exploring the Access Environment
Topic 1A: Explore the User Interface
Topic 1B: Work with the Ribbon
Topic 1C: Work with Contextual Tabs
Topic 1D: Customize the Access Environment

Lesson 2: Creating Tables and Forms
Topic 2A: Create a Table
Topic 2B: Create a Form
Topic 2C: Design a Form Layout

Lesson 3: Creating Queries and Reports
Topic 3A: Query a Database
Topic 3B: Generate Reports
Topic 3C: Format a Report

Lesson 4: Working with External Data
Topic 4A: Import Data
Topic 4B: Export Data