D

 

data access objects (DAO)

Create a Form for Online Invoices

data entry, database

Add a Record to Your Database
Create a Contact Management Database
Type Your Contact Information
Share Your Order Entry Database
Create a Great-Looking Product Form
Make Data Entry Easy and Accurate
Simplify Typing Phone Numbers
Automate Repetitive Tasks in Microsoft Access
Create a Macro to Display a Message

data labels, chart

Label the Data Markers

data markers, chart

Change the Data Markers
Label the Data Markers

data series, chart

Create the Chart
Add Data to the Chart
Is Your Data More Complex?
Format and Position the Legend
Set Up Your Data
Display Scientific Data in a Chart

data, worksheet:aligning

Change the Way Text and Data Look

data, worksheet:clearing

Modify the Data

data, worksheet:copying

Modify the Data

data, worksheet:editing

Modify the Data

data, worksheet:entering series

Enter Data Automatically

data, worksheet:entering

Create Your First Microsoft Excel Workbook
Enter Your Contact Information

data, worksheet:formatting

Change the Way Text and Data Look

data, worksheet:linking to databases

Create a Form for Online Invoices

data, worksheet:moving to Microsoft Access

Move a Product List into Microsoft Access

data, worksheet:moving

Modify the Data

data, worksheet:saving

Save, Preview, and Print a Sheet

data, worksheet:selecting for Microsoft Excel charts

Create the Chart

data, worksheet:selecting

What’s on the Screen?
Work in Cells and Ranges

Database window

Create an Order Entry Database

Database Wizard

Need Help Setting Up a Database?
Track Your Business Contacts in Microsoft Access
Create a Contact Management Database
Track Orders in a Shared Database
Catalog Your Music Collection
Create a Music Database
Create a Household Inventory Database

databases (Microsoft Access):adding command buttons to forms and reports

Add a Command Button That Prints a Report

databases (Microsoft Access):adding hyperlinks

Store a Hyperlink in a Table
Display a Hyperlink on a Form

databases (Microsoft Access):adding pictures to records

Add a Record to Your Database

databases (Microsoft Access):adding records

Add a Record to Your Database
Help Others Use the Form to Add Database Records

databases (Microsoft Access):columns

View Information in a Database

databases (Microsoft Access):controlling access to

Share Your Order Entry Database

databases (Microsoft Access):creating and opening

About Creating and Opening Documents and Databases

databases (Microsoft Access):creating charts from

Create a Chart from a Database

databases (Microsoft Access):creating from Microsoft Excel worksheets

Move a Product List into Microsoft Access

databases (Microsoft Access):creating from scratch

Create a Music Database

databases (Microsoft Access):creating with Database Wizard

Track Your Business Contacts in Microsoft Access
Track Orders in a Shared Database
Catalog Your Music Collection

databases (Microsoft Access):defined

View Information in a Database

databases (Microsoft Access):deleting records

Add a Record to Your Database
Help Others Use the Form to Add Database Records

databases (Microsoft Access):editing records

Add a Record to Your Database

databases (Microsoft Access):employee data in

Use Your First Microsoft Access Database

databases (Microsoft Access):entering data in

Add a Record to Your Database

databases (Microsoft Access):entering today's date automatically

Let Microsoft Access Enter Information for You

databases (Microsoft Access):expressions

Show Only Last Month’s Orders

databases (Microsoft Access):filtering records

Find and Display Only the Information You Need

databases (Microsoft Access):finding

Find and Open Documents and Databases
Make Your Documents and Databases Easier to Find

databases (Microsoft Access):for household inventory

Record Your Home Assets

databases (Microsoft Access):forms in

Use Your First Microsoft Access Database
Make It Easier to Read Records
Add a Record to Your Database

databases (Microsoft Access):frequently used

Create Shortcuts for Frequently Used Files

databases (Microsoft Access):importing data to

Use Data from Other Applications or Databases

databases (Microsoft Access):linking data from external databases

What Method Should You Use to Analyze Your Sales Data?

databases (Microsoft Access):linking multiple workbooks to

Link Template Cells to Database Fields

databases (Microsoft Access):linking worksheet data to

View and Update Your Data in Microsoft Access

databases (Microsoft Access):macros for repetitive data entry

Automate Repetitive Tasks in Microsoft Access
Create a Macro to Display a Message

databases (Microsoft Access):moving contact information to and from

Can I Move My Contact Data to Another Application?

databases (Microsoft Access):opening

About Creating and Opening Documents and Databases
Find and Open Documents and Databases

databases (Microsoft Access):overview

Use Your First Microsoft Access Database

databases (Microsoft Access):passwords for

Protect Your Database with a Password

databases (Microsoft Access):personal uses for

Catalog Your Music Collection
Record Your Home Assets

databases (Microsoft Access):placing on networks

Share Your Order Entry Database

databases (Microsoft Access):preventing changes to

Share Your Order Entry Database

databases (Microsoft Access):protecting

Protect Your Database with a Password

databases (Microsoft Access):publishing imported data to intranet

Publish Your Data

databases (Microsoft Access):querying

Evaluate Sales Performance in a Microsoft Access Database

databases (Microsoft Access):relational, defined

View Information in a Database

databases (Microsoft Access):relationships between tables

Use Tables to Organize Data in Your Database
View Relationships Between Tables

databases (Microsoft Access):reports in

Use Your First Microsoft Access Database
Present Data in the Format You Need
Create and Enhance an Inventory Report

databases (Microsoft Access):rows

View Information in a Database

databases (Microsoft Access):shared usage on networks

Share Your Order Entry Database

databases (Microsoft Access):shared

Track Orders in a Shared Database

databases (Microsoft Access):sharing information between applications

Use Office Applications Together

databases (Microsoft Access):sorting records

Sort Records Alphabetically

databases (Microsoft Access):specifying properties for

Make Your Documents and Databases Easier to Find

databases (Microsoft Access):splitting in two

Share Your Order Entry Database

databases (Microsoft Access):storing

Create Shortcuts for Frequently Used Files

databases (Microsoft Access):summarizing data from Microsoft Excel forms

Create Reports from the Database

databases (Microsoft Access):tables in

Use Your First Microsoft Access Database

databases (Microsoft Access):tracking business contacts

Track Your Business Contacts in Microsoft Access

databases (Microsoft Access):tracking data

Create a Form for Online Invoices

databases (Microsoft Access):transferring data to other applications with OfficeLinks button

Other Easy Ways to Share Office Information

databases (Microsoft Access):turning into applications

Turn Your Inventory Database into an Application

databases (Microsoft Access):updating records

Add a Record to Your Database

databases (Microsoft Access):uses for

Create a Music Database

databases (Microsoft Access):using first database

Use Your First Microsoft Access Database

databases (Microsoft Access):vs. Microsoft Excel worksheets, which to use when

Move a Product List into Microsoft Access
What Method Should You Use to Analyze Your Sales Data?

databases (Microsoft Access):when to store contact information in

Where Should You Store Your Contact Information?

databases (Microsoft Access):when to use forms in

What’s the Best Way to Create a Form?

databases, external

Turn Your Form into a Data-Tracking Template
Help Others Use the Form to Add Database Records
Use Data from Other Applications or Databases
View and Update Your Data in Microsoft Access
Look Up Prices
What Method Should You Use to Analyze Your Sales Data?
Get Sales Information from a Database
Set Up a Link to Your Database
How Well Are Products Selling over Time?

datasheets (Microsoft Graph)

Create Charts with Microsoft Graph

dates:entering automatically in database forms

Let Microsoft Access Enter Information for You

dates:entering series automatically in worksheets

Enter Data Automatically

dates:entering today's date in Word documents

Add Text to Your Document

dates:formatting in worksheets

Use the Best Number Format

dates:in PivotTables

What Information Is Buried in Your Data?

dates:in Word headers and footers

Page Numbers, Headers, and Footers

dates:querying databases for

Show Only Last Month’s Orders

dBASE files:importing to Microsoft Access databases

View and Update Your Data in Microsoft Access

dBASE files:linking Microsoft Excel forms to

Turn Your Form into a Data-Tracking Template

dBASE files:linking to Microsoft Access databases

Use Data from Other Applications or Databases

dBASE files:opening into Microsoft Excel worksheets

Set Up a Link to Your Database

default font, changing

Fonts, Bold, Italic, and Other Text Enhancements

default values for database form fields

Let Microsoft Access Enter Information for You

delimited text files

Can I Move My Contact Data to Another Application?

descriptive statistics, analyzing

Run the Analysis

desktop publishing effects

Put It All Together: Design a “Facing Pages” Layout
Tables for Side-by-Side Information

dialing phone numbers

Use Outlook to Call Your Contact

dialog boxes, activating ScreenTips from

Find Out What’s on the Screen

dingbats in letterhead design

Change the Text Design

direct mailings

Create a Mailing

direction keys (Word)

Move Around in the Document

discounts, calculating

Extract and Quote the Prices

distribution lists, creating

Create a Personal Distribution List

DIV/0! error

Count Orders for a Product Across Regions

Document Map feature (Word)

Move Around in the Document
To Outline or Not to Outline?
Make Writing Easier

documents (Word):adding charts

Add a Chart to a Document or Presentation

documents (Word):adding graphics

Get Your Point Across with Graphics

documents (Word):business letters

Write a Business Letter

documents (Word):business reports

Create a Business Report

documents (Word):changing screen view of

Change Your View of the Document

documents (Word):closing

Save, Preview, and Print a Document

documents (Word):commenting on

Decide How Reviewers Will Provide Feedback
Get a Document Ready for Review

documents (Word):comparing versions

Incorporate Changes

documents (Word):converting to HTML

Start the Web Page Wizard

documents (Word):counting words in

Add Your Content to the Newsletter

documents (Word):cover letters

Write a Cover Letter

documents (Word):creating based on templates

Create a New Document

documents (Word):creating based on wizards

Create a New Document

documents (Word):creating from scratch

Create a New Document

documents (Word):dividing into sections

Add Headers and Footers

documents (Word):editing charts from within

Add a Chart to a Document or Presentation
Modify the Chart

documents (Word):editing text

Select the Text You Want to Change

documents (Word):enhancing

Make Your Word Document Look Great

documents (Word):fax cover sheets

Create a Fax Cover Sheet and Send a Fax

documents (Word):first document

Create Your First Word Document

documents (Word):flyers

Create a Flyer

documents (Word):formatting

Change the Appearance of Text
Make Your Word Document Look Great

documents (Word):highlighting

Use Word for Windows as Your E-mail Editor
Get a Document Ready for Review

documents (Word):improving on-screen legibility

Create an Easy-to-Read Design
What View Should Online Readers Use?

documents (Word):inserting Microsoft Excel charts in

Add a Chart That Stays Up-To-Date

documents (Word):legal contracts

Create a Legal Contract

documents (Word):letterhead and matching envelopes

Create Letterhead and Matching Envelopes

documents (Word):linking Microsoft Excel charts to

Add a Chart That Stays Up-To-Date

documents (Word):linking Microsoft Excel data to

Write a Draft of Your Report

documents (Word):linking PowerPoint slides to

Does Your Audience Need a Book?

documents (Word):locking

Get a Document Ready for Review

documents (Word):manuals

Create an Online Manual

documents (Word):memos

Create a Memo

documents (Word):moving around in

Move Around in the Document

documents (Word):navigating online with hyperlinks

For Easy Navigation, Create Hyperlinks

documents (Word):newsletters

Create a Newsletter

documents (Word):online manuals

Create an Online Manual

documents (Word):opening

Save, Preview, and Print a Document

documents (Word):passwords for

Get a Document Ready for Review

documents (Word):pleadings

Create a Pleading

documents (Word):posting

Choose How You Want to Distribute Documents
Post a Document

documents (Word):previewing

Save, Preview, and Print a Document

documents (Word):printing

Save, Preview, and Print a Document

documents (Word):protecting

Get a Document Ready for Review

documents (Word):resumes

Create a Resume and Cover Letter

documents (Word):reviewing online

Have Your Team Review a Word Document

documents (Word):routing

Choose How You Want to Distribute Documents
Route a Document

documents (Word):saving versions

To Outline or Not to Outline?

documents (Word):saving

Save, Preview, and Print a Document
Add a Chart That Stays Up-To-Date

documents (Word):selecting entire

Select the Text You Want to Change

documents (Word):sending out for team review

Have Your Team Review a Word Document

documents (Word):sharing information between applications

Use Office Applications Together

documents (Word):shortcuts for entering text

Add Text to Your Document

documents (Word):tables of contents in

Finish by Adding a Table of Contents

documents (Word):transferring presentation handouts and notes to

Does Your Audience Need a Book?

documents (Word):transferring to PowerPoint

Insert a Word Outline

documents (Word):typing text

Add Text to Your Document

documents (Word):viewing

Change Your View of the Document

documents (Word):when to create forms in

What’s the Best Way to Create a Form?

double-spacing text

Text Spacing and Alignment

Draft copy, as letterhead watermark

Add a Watermark

dragging and dropping:between applications

Other Easy Ways to Share Office Information

dragging and dropping:within applications

Move and Copy Text
Insert Objects to Copy and Edit Information

dragging:to move or copy worksheet ranges

Modify the Data

dragging:to select worksheet ranges

Work in Cells and Ranges

Drawing toolbar

Use the Drawing Toolbar
Manipulate Objects

drawing:in Microsoft Excel

Emphasize Important Data

drawing:in PowerPoint

Add Graphics

drawing:in Word

Clip Art, Graphics, and Drawings

drawing:Word table rows and columns

Build the Form

drivers, ODBC

Get Sales Information from a Database
Set Up a Link to Your Database

drop caps, creating

Fonts, Bold, Italic, and Other Text Enhancements

drop-down list fields

Add Text Fields, Drop-Down Lists, and Check Boxes

E

 

editing Word documents

Insert and Delete Text
Move and Copy Text

electronic presentations

Create a Self-Running Presentation
Create Printed Materials
Create Audience Handouts
Prepare for an Electronic Presentation
Prepare Animations and Slide Transitions
Be Prepared with Hidden Slides
Branch to Other Locations
Organize Your Presentation
Time and Rehearse Your Presentation
Add Multimedia Effects
Use Slide Sorter View
Give an Electronic Presentation
Master the Element of Surprise
Take Notes and Track Action Items on Screen
Customize the Appearance of Your Presentation
Apply Master Formatting
Give a Great Presentation on Paper

elevation (3-D charts)

Formatting a 3-D Chart

e-mail

Distribute Documents Online
Send a Document
Use Word for Windows as Your E-mail Editor
Organize the Inbox
Create Mail Folders to Organize E-mail
Automate Mail Management
Create a Personal Distribution List
Use E-mail to Get Opinions
Include a Hyperlink in an E-mail Message
Create and Send E-mail

employee data:creating phone books

Present Data in the Format You Need

employee data:creating reports

Present Data in the Format You Need

employee data:evaluating sales performance

Evaluate Sales Performance in a Microsoft Access Database

employee data:in databases

Use Your First Microsoft Access Database

employee data:in Northwind database

Use Your First Microsoft Access Database

employee data:printing from Northwind database

Present Data in the Format You Need

employee data:ranking sales performance

Rank Your Sales Staff

employee data:sorting in database

Sort Records Alphabetically

employee data:viewing in database

View Information in a Database

employee handbooks, creating

Create an Online Manual

engineering analysis

Analyze Data from an Experiment

entering worksheet formulas

Enter a Formula to Calculate a Value
Set Up a Model

envelopes

Print an Envelope
Create a Matching Envelope
Print Addresses on Mailing Labels
Write a Cover Letter

equal sign (=) in worksheet formulas

Enter a Formula to Calculate a Value

error bars, in charts

Show “Plus or Minus” with Error Bars

errors, correcting:in PowerPoint presentations

Check for Errors

errors, correcting:in Word documents

Add Text to Your Document

errors, correcting:in worksheets

Enter Your Contact Information

errors, tracing

Count Orders for a Product Across Regions

events, calendar

Add Activities to the Calendar
Mark an Event

events, programming

Create a Macro to Display a Message
Add a Command Button That Prints a Report

exclusive mode

Share Your Order Entry Database

experimental data, analyzing

Analyze Data from an Experiment

exponential growth curve

What If Sales Don’t Follow a Simple Trend?

exponential smoothing

Analyze Data from an Experiment

exporting

Create Printed Materials
Export a Presentation to Word
Can I Move My Contact Data to Another Application?
Convert Your Worksheet to Microsoft Access

expressions

Show Only Last Month’s Orders

external data:importing vs. linking to Office applications

What Method Should You Use to Analyze Your Sales Data?

external data:reading in to Office applications

Can I Move My Contact Data to Another Application?

external data:requirements for linking to

Get Sales Information from a Database