

•	Table of Contents

Show Me Microsoft® Office Access 2003
By Steve Johnson Perspection, Inc.

Publisher	: Que
Pub Date	: October 15, 2003
ISBN	: 0-7897-3004-9
Pages	: 384

Acknowledgements

Perspection, Inc.

Acknowledgements

About The Author

We Want To Hear From You!

Introduction

Find the Best Place to Start

What's New

How This Book Works

Step-by-Step Instructions

Real World Examples

Troubleshooting Guide

Show Me Live Software

Microsoft Office Specialist

Chapter 1. Getting Started with Access

Introduction

What Is a Database?

Understanding How Databases Store Data

Starting Access

Using Task Panes

Opening a Database

Finding a File or Contents in a File

Viewing the Access Window

Arranging Windows

Choosing Menu Commands

Choosing Dialog Box Options

Working with Toolbars

Viewing Database Objects

Getting Help While You Work

Getting Help from the Office Assistant

Getting Access Updates on the Web

Saving Your Work

Recovering an Office Program

Detecting and Repairing Problems

Closing a Database and Quitting Access

Chapter 2. Touring Access Databases

Introduction

Opening a Sample Database

Using a Switchboard

Working with Database Objects

Grouping Database Objects

Creating a Database Using a Wizard

Stepping Through a Database Wizard

Creating a Database Using a Template

Warnings About Templates and Add-Ins

Chapter 3. Planning and Creating a Custom Database

Introduction

Creating a New Database

Planning Tables

Creating Tables in a Database

Creating a Table Using a Wizard

Setting a Primary Key Using the Table Wizard

Assigning Table Relationships Using the Table Wizard

Creating a Table by Entering Data

Importing Data into Tables

Working with a Table in Design View

Specifying a Primary Key in Design View

Planning Table Relationships

Defining Table Relationships

Ensuring Referential Integrity

Identifying Object Dependencies

Modifying Object Dependencies

Chapter 4. Working with Fields

Introduction

Inserting, Deleting, and Reordering Fields

Specifying Data Types and Field Properties

Viewing Field Properties

Changing Field Properties

Updating Field Properties

Setting Field Size

Formatting Text Values

Formatting Number and Currency Values

Formatting Date and Time Values

Creating Input Masks

Specifying Required Fields and Default Values

Adding a Caption to a Field

Creating Indexed Fields

Validating Field Values

Using Expression Builder

Creating a Lookup Field

Setting Lookup Properties

Chapter 5. Working with Tables

Introduction

Working with a Table

Moving to a Specific Record in a Table

Searching for and Replacing Text

Entering Data Accurately with AutoCorrect

Using Smart Tags

Editing Text

Working with the Clipboard

Checking Spelling

Arranging Columns

Changing the Size of Rows and Columns

Managing Columns in Datasheet View

Formatting a Datasheet

Repairing Renaming Errors

Sorting Records

Copying and Pasting Records

Viewing a Subdatasheet

Filtering Out Records

Creating Complex Filters Using Forms

Chapter 6. Locating Specific Information Using a Query

Introduction

Understanding Types of Queries

Creating a Query in Design View

Getting Information with a Query

Modifying a Query in Design View

Creating a Query Using a Wizard

Changing the Query Fields

Specifying Criteria for a Single Field

Specifying Criteria for Multiple Fields

Creating Queries with Comparison and Logical Operators

Performing Calculations in Queries

Creating a Parameter Query

Finding Duplicate Fields

Finding Unmatched Records

Creating New Tables with a Query

Adding Records with a Query

Deleting Records with a Query

Updating Records with a Query

Summarizing Values with a Crosstab Query

Creating SQL-Specific Queries

Chapter 7. Simplifying Data Entry with Forms

Introduction

Creating Forms

Working with Form Controls

Creating a Form Using AutoForm

Creating a Form Using a Wizard

Creating a Form in Design View

Editing an Existing Form

Adding and Modifying Controls

Using the Control Wizards

Creating a Subform

Editing in Form View

Entering and Editing Data in a Form

Using Windows XP Themes in Forms

Chapter 8. Creating Reports to Convey Information

Introduction

Exploring Different Ways to Create a Report

Creating a Report Using a Wizard

Using Sections in Design View

Working with Controls

Creating a Report in Design View

Using Toolbox Buttons and Controls

Arranging Information

Creating Mailing Labels

Setting Properties

Performing Calculations in Reports

Grouping Records

Inserting a Header or Footer

Assigning a Shortcut Key to a Control

Checking for Errors in Reports and Forms

Changing the Page Setup

Previewing Information

Printing Information

Chapter 9. Improving the Appearance of Forms and Reports

Introduction

Formatting a Form or Report

Adding Lines and Rectangles

Changing Line or Border Thickness

Changing Colors

Applying Special Effects to Controls

Applying Conditional Formatting

Aligning and Grouping Controls

Sharing Information Among Documents

Copying and Pasting Objects

Inserting a New Object

Inserting an Object from a File

Inserting a Picture

Inserting Excel Charts and Worksheets

Inserting a Graph Chart

Formatting Chart Objects

Moving and Resizing an Object

Chapter 10. Working on the Web

Introduction

Integrating Access and the Internet

Creating a Hyperlink Field

Inserting a Hyperlink to a File or Web Page

Linking to an Object in a Database

Linking to a New Document

Navigating Hyperlinks

Working with the Web Toolbar

Exporting Database Objects to HTML

Exporting Database Objects to ASP Files

Holding an Online Meeting

Creating a Data Access Page Using a Wizard

Working with a Data Access Page in Design View

Adding a Theme to a Page

Grouping a Data Access Page

Viewing a Data Access Page

Analyze Pivot Data from the Web

Chapter 11. Importing and Exporting Information

Introduction

Importing and Linking Data

Importing or Linking Data from an Access Database

Importing or Linking Data from an Excel Spreadsheet

Importing or Linking Data from a Mail Program

Getting Data from Other Programs

Importing and Exporting XML Data

Exporting Data to Other Programs

Merging Data with Word

Analyzing Data in Excel

Chapter 12. Managing a Database

Introduction

Securing a Database

Creating a Workgroup Information File

Joining a Workgroup

Creating User and Group Accounts

Activating User Logons

Setting User and Group Permissions

Setting Object Ownership

Setting a Database Password

Encoding a Database

Locking Database Records

Replicating a Database

Backing Up a Database

Compacting and Repairing a Database

Splitting a Database

Documenting a Database

Analyzing a Database

Converting Access Databases

Using Add-Ins

Creating a Database Switchboard

Managing a Switchboard

Creating a Splash Screen

Setting Access Startup Options

Chapter 13. Customizing Access

Introduction

Adding and Removing Toolbar Buttons

Customizing a Toolbar

Customizing the Menu Bar

Editing Toolbar Buttons and Menu Entries

Learning About Macros

Creating a Macro

Running and Testing a Macro

Creating Macro Groups

Creating Conditional Macros

Assigning a Macro to a Button

Assigning a Macro to an Event

Creating a Message Box

Controlling Access with your Voice

Executing Voice Commands

Dictating Text

Recognizing Handwriting

Using Multiple Languages

Chapter 14. Enhancing a Database with Programming

Introduction

Enhancing a Database with VBA

Creating a Standard Module

Understanding Parts of the Visual Basic Editor

Creating a Sub Procedure

Writing VBA Commands

Running a Sub Procedure

Copying Commands from the Object Browser

Creating a Custom Function

Running a Custom Function

Creating a Class Module for a Form or Report

Setting Project Properties

Debugging a Procedure

Identifying VBA Debugging Tools

Optimizing Performance with an MDE File

Chapter 15. Working Together on Office Documents

Introduction

Viewing SharePoint Team Services

Administering SharePoint Team Services

Storing Documents in the Library

Viewing Team Members

Setting Up Alerts

Assigning Project Tasks

Creating an Event

Creating Contacts

Holding Web Discussions

Importing and Exporting Access Data with SharePoint

Installing Windows 2003 and SharePoint Server 2003

Microsoft Office Specialist

About the Microsoft Office Specialist Program

What Does This Logo Mean?

Preparing for a Microsoft Office Specialist Exam

Taking a Microsoft Office Specialist Exam

Getting More Information

New! Features

Microsoft Office Access 2003

Troubleshooting

Clip art and objects

Columns

Database

Entering and editing data

Importing and exporting

Language, voice and handwriting options

Macros

Managing

Menus, toolbars, and task panes

Microsoft Office Specialist