Microsoft Access 2002 Book

Introduction
Part I
Getting Started with Access
Chapter 1 Starting and Exiting Access
Starting Access
Exiting Access
Chapter 2 Creating a New Database
Creating a Database from a Template
Displaying the Task Pane
Starting a Database from a Template
Selecting Database Fields
Customizing the Database
Adding a Picture or Logo to Reports
Finishing the Database
Working with a Switchboard
Closing the Switchboard
Creating a Blank Database
Chapter 3 Opening and Using Databases
Opening a Recently Used Database
Opening an Existing Database
Understanding the Database Window
Using the Database Window
Deleting an Object in the Database Window
Viewing Objects in the Database Window
Part I Review Questions
Part II
Working With Tables
Chapter 4 Creating a Table with the Table Wizard

Starting the Table Wizard
Choosing Table Fields
Removing Fields
Renaming Fields
Naming the Table and Setting a Key
Setting Table Relationships
Finishing the Table
Chapter 5 Creating a Table from Scratch

Creating a Table in Datasheet View
Creating a Table in Design View
Setting a Primary Key
Setting Format Properties
Setting Field Size Properties for Text Fields
Saving the Table
Chapter 6 Modifying a Table

Opening a Table in Design View
Inserting a Field
Deleting a Field
Renaming a Field
Moving a Field
Changing the Data Type
Chapter 7 Managing Relationships between Tables
Understanding Relationships
Viewing Table Relationships

Creating Relationships
Adding Tables to the Relationships Window
Creating a Relationship
Understanding Referential Integrity
Enforcing Referential Integrity for a Relationship

Removing a Relationship
Closing the Relationships Window
Part II Review Questions
Part III
Entering, Editing, and Viewing Data
Chapter 8 Entering Data

Opening a Table in Datasheet View
Navigating in Datasheet View
Using Edit Mode to Enter Data
Using Data Entry Mode to Enter Data

Exiting Data Entry Mode
Chapter 9 Editing Data

Modifying Data
Modifying the Entire Field Contents
Modifying Partial Field Contents

Undoing Edits
Replacing Data
Editing Data
Deleting Records
Chapter 10 Changing the Datasheet Layout

Resizing Datasheet Columns
Resizing Datasheet Rows
Freezing and Unfreezing Columns
Freezing Columns
Unfreezing Columns

Hiding and Unhiding Columns
Hiding Columns
Unhiding Columns

Renaming Columns
Working with Subdatasheets
Viewing a Subdatasheet
Closing a Subdatasheet

Part III Review Questions
Part IV
Finding Data
Chapter 11 Sorting, Filtering, and Finding Data
Sorting Data
Removing a Sort

Filtering Data
Filtering by Form
Saving a Filter by Form

Finding Data
Chapter 12 Using the Simple Query Wizard
Starting the Simple Query Wizard
Selecting Fields
Choosing a Detail or Summary Query
Creating a Detail Query
Creating a Summary Query

Finishing the Query
Chapter 13 Creating a Basic Query in Design View
Starting a Query in Design View
Adding Fields
Deleting Fields
Moving Fields
Inserting Fields

Viewing Query Results
Saving a Query
Chapter 14 Creating Queries That Sort, Filter, or Calculate
Reopening a Query for Editing
Specifying Criteria
Specifying Exact Matches
Specifying Wildcard Patterns
Specifying Eliminations
Specifying a Range of Values
Using OR Criteria

Sorting Query Fields
Specifying Calculations
Part VI Review Questions
Part V
Creating and Using Forms
Chapter 15 Creating an AutoForm
Choosing an AutoForm Type
Creating an AutoForm
Saving a Form
Saving and Closing a Form
Chapter 16 Entering Data in a Form
Opening a Form in Form View
Navigating in Form View
Entering a New Record in a Form
Chapter 17 Creating a Form with the Form Wizard
Starting the Form Wizard
Selecting Fields for Your Form
Choosing a Form Layout
Choosing a Form Style
Finishing the Form
Chapter 18 Changing a Form's Appearance
Opening a Form in Design Vew
Displaying the Toolbox
Adding a Label
Changing a Form's Format
Changing Text Properties
Changing the Font
Changing the Font Size
Changing the Font Color
Changing Text Attributes
Setting Alignment
Setting Background Color
Selecting a Form Section
Applying a Background Color
Chapter 19 Working with Form Fields
Adding and Removing Fields
Displaying the Field List
Adding a Field
Moving Controls
Moving the Field and Label Together
Moving the Field or Label Separately
Moving Multiple Controls at Once
Resizing a Field or Other Control
Deleting a Field or Other Control
Chapter 20 Adding Special Control Types

Adding Option Groups
Specfying a Default Choice
Setting Option Values
Saving or Storing the Option Group Value
Specifying Controls and Styles
Finishing the Option Group
Understanding Combo and List Boxes
Creating Combo or List Boxes That Look Up Values
Choosing a Table or Query
Selecting Fields
Specifying Column Width
Determining What to Do with the Value
Finishing the Combo Box or List Box
Creating a Combo Box or List Box in Which You Enter Values
Entering the Box Values
Saving or Storing the Box Value
Finishing the Combo Box or List Box
Part V Review Questions
Part VI
Working with Reports
Chapter 21 Creating an AutoReport
Creating a Columnar AutoReport
Creating a Tabular AutoReport
Saving and Closing a Report
Chapter 22 Printing Reports
Opening a Report in Print Preview
Zooming in on a Report
Printing a Default Report
Printing a Report with Specific Options
Setting up Margins
Chapter 23 Creating a Report with the Report Wizard
Starting the Report Wizard
Selecting Fields
Creating Groupings

Chapter 24 Changing a Report's Appearance
Opening a Report in Design View
Applying an AutoFormat
Changing Fonts

Chapter 25 Creating Mailing Labels
Starting the Label Wizard
Selecting the Label Size and Type
Formatting the Label Text
Choosing and Arranging Label Fields
Setting the Sort Order for Records
Finishing the Label Wizard
Part VI Review Questions

Part VII
Working with the Web
Chapter 26 Adding Hyperlinks
Adding Hyperlinks to a Table in Design View
Adding Hyperlink Columns in Datasheet View
Entering Hyperlinks in Tables

Chapter 27 Creating Data Access Pages
Understanding Data Access Pages
Creating a Columnar AutoPage
Creating a Page with the Page Wizard

Part VIII
Appendixes
Appendix A Installing Office XP
Installing the Software
Appendix B Office Program Basics
Using Menus
Appendix C Using Keyboard Shortcuts
General Shortcuts
Datasheet View Shortcuts
Form View Shortcuts
Print Preview Shortcuts
Text and Data Shortcuts

Appendix D Creating Effective Databases
Planning Your Tables
Normalizing a Database Structure
More Table Design Tips
Glossary
Index