Table of Contents

FastCourse Access 2007
(back to Class Materials) (back to Course List)

Level 1 | Level 2 | Level 3

Level 1

• Exploring Access 2007

  • Defining Access Databases

  • What Is a Database?

  • Database Structures

  • Storing Your Exercise Files

  • Exploring the Access Environment

  • Launching Access 2007

  • Identifying Elements of the Access Window

  • Opening a Database and Identifying Features of the Database Window

  • Enabling Macros Controlling Database Security

  • Identifying Features of the Database Window

  • Using the Navigation Pane

  • Opening, Navigating, and Closing Database Objects

  • Working with Tables

  • Viewing Forms

  • Viewing Reports

  • Glimpsing the Power of Queries

  • Closing a Database and Exiting Access

• Using an Access Database

  • Adding Records and Formatting Datasheet Layout

  • Adding Records Using a Table

  • Formatting a Table Datasheet Layout

  • Adding Records Using a Form

  • Retrieving Data

  • Sorting Records

  • Sorting Records Using Multiple Fields

  • Locating and Deleting Records Using Table Datasheets

  • Using Forms to Locate and Edit Records

  • Using Find and Replace to Update Records

  • Filtering Records

  • Previewing and Printing Data

  • Setting Up Data to Print

  • Examining the Preview Window

  • Saving a Database as a New File

  • Using the Save As Command

• Building a Database

  • Designing a Database

  • Planning a Database Design

  • Documenting a Database Design

  • Creating a Blank Database

  • Creating Database Objects

  • Creating Tables in Datasheet View

  • Creating and Using Forms

  • Creating and Generating Reports

  • Creating a Query

  • Creating a Table from an Excel Worksheet

  • Creating a New Database Using a Template

• Managing a Database

  • Creating Tables Using Table Design View

  • Displaying Table Design View

  • Entering Field Names

  • Identifying Field Data Types

  • Entering Descriptions

  • Setting Field Properties

  • Identifying a Primary Key

  • Appending Records to a Database Table

  • Creating and Testing Queries

  • Query Defined

  • Creating a Query Using Query Design

  • Adding Criteria to a Query

  • Creating Forms and Reports Using Wizards

  • Creating Forms Using the Form Wizard

  • Creating Reports Using the Report Wizard

  • Managing Databases and Database Objects

  • Saving Database Objects as New Objects

  • Backing Up a DatabaseCompacting and Repairing a Database

• Maintaining and Documenting a Database

  • Modifying Table Structures

  • Editing, Adding, and Deleting Table Fields

  • Assigning Primary Keys

  • Setting Lookup Fields Using the Lookup Wizard

  • Examining the Benefits of Lookup Tables

  • Performing a Lookup

  • Setting Field Properties

  • Why Set Field Properties?

  • Setting Field Size

  • Setting Captions

  • Formatting Data Using Input Masks

  • Setting Validation Rules

  • Setting Default Field Values

  • Analyzing and Documenting a Database

  • Reviewing Performance Results

  • Documenting a Database

(back to top)

Level 2

• Designing a Relational Database
  

  • Designing a Relational Database—An Overview

  • Principles for Good Database Design

  • Planning a Relational Database

  • Normalizing Data

  • Examining and Editing Database Objects

  • Modifying Table Field Settings

  • Storing Your Exercise Files

  • Testing Control Settings

  • Creating Lookup Fields

  • Creating a Split Form

  • Working with Relationships

  • Identifying Relationship Types

  • Creating and Modifying Relationships

  • Editing Relationships

  • Printing Relationships

  • Identifying Object Dependencies

• Querying a Database
  

  • Designing a Query Using Multiple Tables

  • Choosing Fields to Include in a Query

  • Selecting a Field Appearing in Multiple Tables

  • Additional Query Points

  • Saving Filters as Queries

  • Setting Query Criteria

  • Using Comparison Operators and Wildcards

  • Setting AND and OR Criteria

  • Entering Date Criteria

  • Sorting a Query and Limiting Results

  • Setting a Query Sort Order

  • Performing Calculations in Queries

  • Identifying Parts of a Calculated Field

  • Creating and Formatting a Calculated Field

  • Using a Function in a Query Expression

  • Creating Special Types of Queries

  • Creating a Crosstab Query

  • Creating Unmatched and Duplicates Queries

• Customizing Input Forms
  

  • Customizing Form Design

  • Examining Form Design View

  • Identifying Layout View Elements

  • Creating Forms

  • Identifying a Record Source

  • Working with Form Controls

  • Modifying Form Controls

  • Editing Labels

  • Deleting Controls

  • Using Design Font Tools

  • Applying Conditional Formatting

  • Using the Property Sheet

  • Arranging Controls

  • Modifying Form Layout

  • Displaying Form Header and Form Footer

  • Formatting Form Section Background

  • Adding Design Elements to Forms

  • Setting Form Properties

  • Setting a Form Tab Order

  • Creating Multiple Items Forms

  • Applying AutoFormats to Forms

  • Printing Forms

  • Printing All Record Forms

  • Printing Selected Record Form

• Creating Custom Reports
  

  • Using Report Design View

  • Identifying Report Design View Elements

  • Displaying Report Views

  • Creating a Report in Design View

  • Working with Report Controls

  • Modifying a Report in Design View

  • Adding Report Sorting and Grouping Levels

  • Adding Date and Time Data to a Report

  • Adding Graphics to Reports

  • Applying AutoFormats

  • Formatting Controls

  • Adding a Title to the Report Header

  • Using the Property Sheet

  • Performing Report Calculations

  • Using the Expression Builder

  • Creating Controls to Calculate Totals

  • Creating Labels Using the Label Wizard

  • Setting Up the Labels

  • Adding Fields to the Labels

  • Printing Reports

  • Setting Report Print Layout

  • Controlling Page Breaks

(back to top)

Level 3

• Working with Advanced Queries

  • Advanced Queries—An Overview

  • Querying Tables Containing No Relationships

  • Creating Select Queries

  • Storing Your Exercise Files

  • Reviewing Relationship Join Properties

  • Setting Join Properties

  • Identifying Join Types

  • Defining Left and Right Joins

  • Creating and Running Parameter Queries

  • Setting Up a Parameter Query

  • Formatting the Criteria Expression

  • Creating Complex Parameter Prompts

  • Creating a Calculated Field in a Query

  • Identifying Features of a Calculated Field

  • Creating and Running Action Queries

  • Identifying Action Query Types

  • Identifying Queries by Their Icons

  • Enabling Content

  • Creating an Append Action Query

  • Creating an Update Query

  • Creating a Delete Query

  • Creating a Make Table Query

• Setting Up Complex Forms

  • Identifying Complex Form Features

  • Creating a Main Form Containing a Subform

  • Removing the Layout

  • Connecting Related Tables in Forms

  • Creating a Form with Subform

  • Editing a Data Source

  • Formatting a Form

  • Creating a New AutoFormat

  • Adding a Calculated Control to a Form

  • Totaling Calculated Fields

  • Positioning Calculated Controls in Form Sections

  • Using the Expression Builder

  • Adding the Current Date to the Form

  • Setting Properties to Assist and Control Data Entry

  • Disabling Form Fields

  • Locking Form Fields

  • Adding Tips to Controls

  • Creating a Pop-up Form

  • Hiding Form Screen Elements 

• Creating Complex Reports

  • Importing a Report into a Database

  • Identifying Report Record Sources

  • Using SmartTags

  • Adding a Subreport to a Main Report

  • Examining the TechCache Database Objects

  • Identifying Procedures for Adding a Subreport

  • Creating a Report from a Subreport

  • Numbering Items in a Report

  • Setting Properties to Number Items

  • Numbering Subreports Separately

  • Creating Calculated Controls on a Subreport

  • Positioning Calculated Controls

  • Growing a Subreport

  • Setting Page Breaks and Customizing Controls

  • Positioning the Page Break Control

  • Analyzing Report Performance

  • What the Performance Analyzer Analyzes

• Customizing the Database Interface and Setting Security

  • Setting Access Options

  • Displaying Access Options

  • Enabling Error Checking

  • Customize the Navigation Pane

  • Set Database Properties

  • Setting Up Current Database Format

  • Setting Datasheet Colors and Default Font

  • Customizing the Database Interface

  • Splitting a Database

  • Creating a Database Switchboard

  • Setting Startup Options to Open the Switchboard

  • Setting Database Security

  • Opening a Database Exclusively

  • Encrypting a Database Using a Password

  • Setting Up Trusted Locations

  • Deploying a Signed Database

• Integrating Access with Other Applications

  • Converting Access 2007 Databases to Other Access Formats

  • Identifying the Format of an Access Database

  • Sharing Data Among Microsoft Office Applications

  • Attaching Files to Access Table Records

  • Sharing Data Between Access and Word

  • Sharing Data Between Access and Excel

  • Collecting Data Using Outlook

  • Displaying Access Data on the Web

  • Exporting Access Objects as Web Pages

  • Saving HTML Formatted Objects

  • Importing HTML Files

  • Adding Hyperlinks to Database Objects

  • Creating PivotTables and PivotCharts

  • Creating PivotTables

  • Creating PivotChart

(back to top)