1). WORKING WITH THE NORTHWIND SAMPLE DATABASE

INSTALLING THE NORTHWIND DATABASE
About Northwind
Checking for Northwind
Installing Northwind

2). DESIGNING TABLES IN ACCESS 2002

NORMALIZING DATA
Setting a Primary Key
Removing Non-related Data
Removing Redundant Data
Removing Repeating Data
Setting Required Values in Columns

ESTABLISHING RELATIONSHIPS
Using the Relationship Tool
Identifying a Related Table
Creating Join Types
Enforcing Referential Integrity
Working with Cascading Updates and Deletes

WORKING WITH INDEXES
Creating a Single-Field Index
Creating a Multiple-Field Index
Setting the Index Sort Order
Setting Index Properties
Deleting Indexes

WORKING WITH DATA TYPES
Choosing Appropriate Data Types
Setting Column Data Types
Formatting Data Types
Converting Between Data Types

3). DESIGNING QUERIES IN ACCESS 2002

CREATING ACTION QUERIES
Creating Update Queries
Creating Delete Queries
Creating Append Queries
Creating Make-Table Queries

CREATING PARAMETER QUERIES
Creating a One-Parameter Query
Creating a Two-Parameter Query
Using Wildcards as Parameters

CREATING CALCULATED COLUMNS IN QUERIES
Creating Calculated Fields
Using Common Functions in Calculated Fields

JOINING TABLES
Creating a Two-Table Join
Adding Fields from Different Tables to the Query Grid
Removing Tables from the Query Builder

4). DESIGNING FORMS IN ACCESS 2002

CREATING DATA ENTRY FORMS
About Forms
Choosing an Appropriate Control
Placing Controls on a Form
Moving a Control
Resizing a Control
Setting Control Properties
Creating Page Headers and Footers
Creating Form Headers and Footers
Setting Form Properties
Working with Identifiers

WORKING WITH SUBFORMS
Creating a Subform
Creating a Form with Two Subforms
Creating Nested Subforms
Deleting a Subform

CREATING POP-UP FORMS
Creating a Modal Pop-up Form
Creating a Modeless Pop-up Form

WORKING WITH SWITCHBOARDS
Creating a Switchboard
Editing a Switchboard Item
Deleting a Switchboard

5). DESIGNING REPORTS IN ACCESS 2002

WORKING WITH STANDARD REPORTS
About Reports
Placing Controls on a Report
Moving a Control
Resizing a Control
Setting Control Properties
Creating Page Headers and Footers
Creating Report Headers and Footers
Sorting Records on a Report
Grouping Records on a Report
Setting Report Properties

WORKING WITH POP-UP REPORTS
Creating a Modal Pop-up Report
Creating a Modeless Pop-up Report

WORKING WITH SUBREPORTS
Creating a Subreport
Creating a Report with Two Subreports
Deleting a Subreport

WORKING WITH REPORT SNAPSHOTS
Creating Report Snapshots
Distributing Report Snapshots

DEVELOPING DATA ACCESS PAGES
Using the New Data Access Page Wizard
Defining a Data Source for a Stand-Alone Data Access Page
Creating Stand-Alone Data Access Pages

6). WORKING WITH PIVOTTABLES AND PIVOTCHARTS

CREATING PIVOTTABLES AND PIVOTCHARTS
Creating PivotTables
Creating PivotCharts
Selecting Elements of a PivotTable
Selecting Elements of a PivotChart

CREATING PIVOTTABLE FORMS
Using the PivotTable AutoForm Wizard
Deleting Items from a PivotTable
Filtering Items in the PivotTable List
Using the AutoCalc Feature
Displaying Subtotals

CREATING PIVOTCHART FORMS
Using the PivotChart AutoForm Wizard
Deleting Items from a PivotChart
Filtering Items in the PivotChart List
Changing PivotChart Types

7). IMPORTING AND EXPORTING

LINKING TO EXTERNAL DATA SOURCES
Linking to Text Files
Linking to Microsoft Excel Spreadsheets
Linking to HTML Files
Linking to Other Access Databases
Linking to a SQL Server ODBC Data Source

IMPORTING DATA INTO ACCESS
Importing from Excel Files
Importing from Other Access Databases
Importing from ODBC Data Sources

EXPORTING DATA FROM ACCESS
Exporting to Files
Exporting to Access Databases
Exporting to ODBC Data Sources

8). BUILDING EXPRESSIONS

USING THE EXPRESSION BUILDER
Using the Expression Builder in Queries
Using the Expression Builder in Forms
Using the Expression Builder in Reports

USING COMMON BUILT-IN FUNCTIONS
Using Date/Time Functions
Using Financial Functions
Using Math Functions
Using Text Functions

1). WORKING WITH THE NORTHWIND SAMPLE DATABASE

INSTALLING THE NORTHWIND DATABASE
About Northwind
Checking for Northwind
Installing Northwind

2). INTRODUCING STRUCTURED QUERY LANGUAGE

WRITING SQL COMMANDS
Structured Query Language (SQL) Bases
Understanding SQL Statements
Understanding SQL Conventions
Understanding SQL Syntax

WRITING SQL QUERIES
Using SELECT Statement
Selecting All Data
Selecting Specific Data
Selecting Conditional Data
Using ORDER BY Statement
Sorting Data
Using Aggregate Functions
Calculating Data
Using GROUP BY Statement
Grouping Data

WRITING SQL SUBQUERIES
Creating a Subquery with Equality
Creating a Subquery with an Aggregate Function
Using ANY and ALL Statements

WRITING SQL JOINS
Understanding SQL Joins
Creating a Simple Join
Sorting a Join
Creating Outer Joins
Creating Left Outer Joins
Creating Right Outer Joins
Creating Full Outer Joins

INSERTING DATA
Using INSERT Statement
Understanding INSERT Statement Rules
Inserting Data using VALUES
Inserting Data using Defaults
Inserting Data using SELECT

UPDATING DATA
Using UPDATE Statement
Updating All Rows
Updating Specific Rows
Updating Multiple Columns

DELETING DATA
Using DELETE FROM Statement
Deleting Specific Rows
Deleting All Rows

WRITING SQL QUERIES IN ACCESS 2002
Viewing SQL in Access 2002
Understanding SQL in Access 2002
Writing SQL Specific Queries
Finding Help on SQL Queries

3). WORKING WITH MACROS

AUTOMATING TASKS
Understanding Macros

INTRODUCING THE MACRO WINDOW TOOLBAR
Using the Macro Window Toolbar

CREATING MACROS
Creating New Macros

TESTING AND DEBUGGING MACROS
Running a Macro
Stepping Through a Macro

MODIFYING MACROS

CONDITIONAL PROGRAMMING IN MACROS
Adding Conditions to Macros
Using the Expression Builder to create Conditions
Running Macros with Conditions

ADDING MACROS TO FORMS
Attaching Macros to a Form

ADDING MACROS TO REPORTS
Attaching Macros to a Report

FILTERING DATA
Filtering Records

DOCUMENTING MACROS
Commenting Macros
Printing Macro Definitions
Viewing Macro Definitions

4). PROGRAMMING ACCESS USING VISUAL BASIC

USING MACROS VERSUS VISUAL BASIC
Using Visual Basic Modules
Converting Macros to Visual Basic Code

UNDERSTANDING VISUAL BASIC CONCEPTS
Understanding Modules
Creating Modules
Understanding Module Declarations
Understanding Procedures
Using Naming Rules
Declaring Variables
Setting Variable Scope
Declaring Constants
Using Methods
Using Arguments

USING THE VISUAL BASIC EDITOR WINDOW
Customizing the Visual Basic Editor Window
Setting the Visual Basic Editor Options

GETTING HELP WITH VISUAL BASIC
Using Microsoft Visual Basic Help
Getting Visual Basic Syntax Help

5). USING DATA ACCESS PAGES

CREATING DATA ACCESS PAGES
Using Data Access Pages
Creating pages using the AutoPage
Creating pages using the Page Wizard
Creating pages using an Existing HTML Document
Creating pages using the Design View

MODIFYING DATA ACCESS PAGES
Choosing a Theme
Adding Text
Adding Controls
Formatting Text and Labels
Aligning Content
Sizing Content
Adding Images
Adding Backgrounds

SORTING DATA IN DATA ACCESS PAGES
Sorting Data

SUMMARIZING DATA IN DATA ACCESS PAGES
Summarizing Data

EDITING DATA IN DATA ACCESS PAGES
Adding a New Record
Deleting a Record

PROTECTING DATA IN DATA ACCESS PAGES
Customizing Navigation Bar
Protecting Fields

6). CONVERTING ACCESS DATABASES

CONVERTING DATABASES TO ACCESS 2002
Converting Databases
Converting Database Objects
Enabling Databases
Sharing Databases across various Access versions

CONVERTING FROM ACCESS 2002 TO ACCESS 97
Converting an Access 2002 database to an Access 97 database
CONVERTING FROM ACCESS 2002 TO ACCESS 2000
Converting an Access 2002 database to an Access 2000 database

7). CUSTOMIZING ACCESS 2002

CONFIGURING ACCESS 2002 OPTIONS
Setting Access 2002 Options
Setting View Options
Setting General Options
Setting Edit/Find Options
Setting Keyboard Options
Setting Datasheet Options
Setting Forms/Reports Options
Setting Pages Options
Setting Advanced Options
Setting International Options
Setting Spelling Options
Setting Tables/Queries Options

CONFIGURING AUTOCORRECT OPTIONS
Setting AutoCorrect Options
Excluding AutoCorrect Rules
Removing AutoCorrect Rules
Adding Replace AutoCorrect Rules
Removing Replace AutoCorrect Rules

CUSTOMIZING MENUS AND TOOLBARS
Opening Customize Dialog Box
Customizing Toolbars
Creating Custom Toolbars
Removing Toolbars
Customizing Commands
Adding Buttons to Toolbars
Removing Buttons from Toolbars
Customizing Options

8). ANALYZING ACCESS DATABASES

OPTIMIZING DATABASES WITH TABLE ANALYZER
Using the Table Analyzer
Renaming Tables
Adding Key Fields

OPTIMIZING DATABASES WITH PERFORMANCE ANALYZER
Using the Performance Analyzer

DOCUMENTING DATABASES WITH DOCUMENTER ANALYZER
Using the Documenter Analyzer
Printing Documentation
Exporting Documentation