Exploring Microsoft Office Access 2007, Volume 1

Chapter 1 - Introduction to Access: Finding Your Way through a Database

 

Section 1: Data and Files Everywhere!

    Exploring, Describing, and Navigating Among the Objects in an Access Database

    Understanding the Difference Between Working in Storage and Memory

    Practicing Good File Management

    Backing up, Compacting, and Repairing Access Files

        Hands-On Exercises 1 Introduction to Databases

 

Section 2: Filters, Sorts, and Access Versus Excel

    Creating Filters

    Sorting Table Data on One or More Fields

    Knowing When to Use Access or Excel  to Manage Data

        Hands-On Exercises 2: Data Manipulation: Filters and Sorts

 

Section 3: The Relational Database

    Using the Relationship Window

    Understanding Relational Power

        Hands-On Exercises 3: Introduction to Relationships

 

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Chapter 2 - Relational Databases and Multi-Table Queries: Designing Databases and Using

 

Section 1: Related Data

    Table Design, Properties, Views, and Wizards

    Designing Data

    Creating Tables

        Hands-On Exercises 1: Table Design, Properties, Views, and Wizards

 

Section 2: Multiple Table Database

    Understanding Table Relationships

    Sharing Data with Excel

    Establishing Table Relationships

        Hands-on Exercises 2: Imports and Relationships

 

Section 3: Queries

    Creating a Query

    Specifying Criteria for Different Data Types

    Copying and Running a Query

    Using the Query Wizard

    Understanding Large Database Differences

        Hands-On Exercises 3: Multi-Table Query

 

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Chapter 3 - Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

 

Section 1: Data Summary and Analysis

    Understanding the Order of Precedence

    Creating a Calculated Field in a Query

        Hands-On Exercises 1: Calculated Query Fields

 

Section 2: Expression Builder

    Creating Expressions with the Expression Builder

    Creating and Editing Access Functions

    Performing Date Arithmetic

        Hands-On Exercises 2: Expression Builder, Functions, and Date Arithmetic

 

Section 3: Data Aggregates

    Creating and Working with Data Aggregates

        Hands-On Exercises 3: Data Aggregates

 

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Chapter 4 - Create, Edit and Perform Calculations in Reports: Creating Professional and Useful Reports

Section 1: Appearance Matter

    Planning Reports

    Using Different Report Views

    Creating and Editing a Report

        Hands-On Exercises 1: Introduction to Access Reports

 

Section 2: The Anatomy of a Report

    Identifying Report Elements, Sections and Controls

    Adding Grouping Levels Using the Layout View

    Adding Fields to a Report

        Hands-On Exercises 2: Create, Sort, Edit, Nest and Remove Groups from Reports

 

Section 3: The Report and Label Wizard

    Using the Report Wizard

        Hands-On Exercises 3: Report Wizard

 

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases