| |
| |
Introduction | |
| |
| |
CD-ROM Installation | |
| |
| |
Log of Exercises | |
| |
| |
Directory of Documents | |
| |
| |
Microsoft Office 97 Basics | |
| |
| |
About Microsoft Office 97 for Windows 95 | |
| |
| |
Using The Mouse | |
| |
| |
Microsoft Office Shortcut Bar | |
| |
| |
Starting Microsoft Office 97 | |
| |
| |
Office Windows | |
| |
| |
Menus, Toolbars, and Commands | |
| |
| |
Select Menu Items | |
| |
| |
Dialog Box Options | |
| |
| |
Shortcut Menus | |
| |
| |
Using the Keyboard | |
| |
| |
The Zoom Option | |
| |
| |
Help Features | |
| |
| |
Office Assistant | |
| |
| |
Microsoft Word 97 | |
| |
| |
Create and Print Documents | |
| |
| |
Start Word | |
| |
| |
The Word Window | |
| |
| |
Default Settings | |
| |
| |
If You Make an Error | |
| |
| |
Create a New Document | |
| |
| |
Save a New Document | |
| |
| |
Close a Document | |
| |
| |
AutoCorrect | |
| |
| |
Automatic Spell Checking | |
| |
| |
Spelling | |
| |
| |
Grammar Check | |
| |
| |
Properties | |
| |
| |
Insertion Point Movements | |
| |
| |
Create a Business Letter | |
| |
| |
The Date and Time Feature | |
| |
| |
Create a Modified-Block Business Letter | |
| |
| |
Set Tabs | |
| |
| |
Print | |
| |
| |
Preview a Document | |
| |
| |
Full Screen View | |
| |
| |
Uppercase Mode | |
| |
| |
Change Case | |
| |
| |
Create a Personal Business Letter | |
| |
| |
Open and Edit Documents | |
| |
| |
Open and Revise a Document | |
| |
| |
Open a Recently Saved Document | |
| |
| |
Open a Document Not Recently Saved | |
| |
| |
Open a Document Outside the Word Program | |
| |
| |
Insert Text | |
| |
| |
Overtype Mode | |
| |
| |
Save Changes to a Document | |
| |
| |
Open a Document as Read Only | |
| |
| |
Save As | |
| |
| |
Undo | |
| |
| |
Redo | |
| |
| |
Delete Text | |
| |
| |
Select Text | |
| |
| |
Show/Hide Codes | |
| |
| |
Track Changes | |
| |
| |
Mark Changes | |
| |
| |
Customize the Way Revisions Display | |
| |
| |
Accept/Reject Revisions | |
| |
| |
Shortcut menu | |
| |
| |
Non-breaking Spaces | |
| |
| |
Preview a File | |
| |
| |
Print a File without Opening | |
| |
| |
Print Multiple Files | |
| |
| |
Find Files | |
| |
| |
Text Alignments and Enhancements | |
| |
| |
Text Alignments | |
| |
| |
Vertical Centering | |
| |
| |
Fonts | |
| |
| |
Font Faces | |
| |
| |
Font Style | |
| |
| |
Font Size | |
| |
| |
Emphasis styles: Bold, Underline, Italics, Highlight, Strikethrough, and Small Caps | |
| |
| |
Remove Emphasis Styles | |
| |
| |
Font Color | |
| |
| |
Use Symbols | |
| |
| |
Bullets and Numbering | |
| |
| |
Format and Edit Documents | |
| |
| |
Line Spacing | |
| |
| |
Paragraph Spacing | |
| |
| |
Indent Text | |
| |
| |
Hanging Indent | |
| |
| |
First-Line Indents | |
| |
| |
Format a One-Page Report | |
| |
| |
Set Margins and Tabs | |
| |
| |
Cut and Paste | |
| |
| |
Drag and Drop | |
| |
| |
Format Painter | |
| |
| |
Move Text | |
| |
| |
Shrink to Fit | |
| |
| |
Copy and Paste | |
| |
| |
Drag and Drop | |
| |
| |
Additional Formatting and Editing | |
| |
| |
Thesaurus | |
| |
| |
Find and Replace Text | |
| |
| |
Hyphenate Text | |
| |
| |
Select Browse Object | |
| |
| |
The Outline Feature | |
| |
| |
Create an Outline | |
| |
| |
Enter Outline Text | |
| |
| |
Edit an Outline | |
| |
| |
Styles | |
| |
| |
Create a Style/Edit a Style | |
| |
| |
Work with Multiple-Page Documents | |
| |
| |
Hard vs. Soft Page Breaks | |
| |
| |
Section Breaks | |
| |
| |
Headers/Footers | |
| |
| |
Page Numbers | |
| |
| |
Letters with Special Notations | |
| |
| |
Print Specific Pages | |
| |
| |
Bookmarks | |
| |
| |
Footnotes | |
| |
| |
Endnotes | |
| |
| |
Comments | |
| |
| |
Widow/Orphan Lines | |
| |
| |
Page Numbering Placement and Formats | |
| |
| |
Move Text From One Page to Another | |
| |
| |
Document Map | |
| |
| |
Full Screen View | |
| |
| |
Work with Multiple Documents; Macros | |
| |
| |
Switch Among Open Documents | |
| |
| |
Display Multiple Documents | |
| |
| |
Copy/Move Text From One Document to Another | |
| |
| |
Close/Maximize a Document Window | |
| |
| |
Insert a File | |
| |
| |
AutoText | |
| |
| |
Record a Macro | |
| |
| |
Run a Macro | |
| |
| |
Clip Art and Templates; Envelopes and Labels | |
| |
| |
Work with Clip Art | |
| |
| |
Import Clip Art into a Document | |
| |
| |
Size Clip Art Images | |
| |
| |
Text Boxes | |
| |
| |
Wrap Text | |
| |
| |
Drop Capital | |
| |
| |
Draw Lines | |
| |
| |
Create a Newsletter | |
| |
| |
Create a Memo Using a Template | |
| |
| |
Use a Template Wizard to Create a Fax Cover Sheet | |
| |
| |
Envelopes and Labels | |
| |
| |
Microsoft Excel 97 | |
| |
| |
Create, Save, and Exit a Worksheet | |
| |
| |
Start Excel | |
| |
| |
The Excel Window | |
| |
| |
Excel Menu and Toolbars | |
| |
| |
Exit Excel | |
| |
| |
Explore the Worksheet Using the Mouse and Keyboard | |
| |
| |
Open a Blank Workbook | |
| |
| |
Enter Labels | |
| |
| |
Make Simple Corrections | |
| |
| |
The View Menu | |
| |
| |
Save a Workbook | |
| |
| |
Close a Workbook | |
| |
| |
Exit Excel | |
| |
| |
Numeric Labels and Values | |
| |
| |
Label Alignment | |
| |
| |
Indent Text in Cells | |
| |
| |
Use Formulas; Format; Copy; Print | |
| |
| |
Use Formulas | |
| |
| |
Open Files | |
| |
| |
Check for Virus | |
| |
| |
Save Files | |
| |
| |
Format Data | |
| |
| |
Use Ranges | |
| |
| |
Copy Data | |
| |
| |
Print a Worksheet | |
| |
| |
Copy a Formula (Absolute Reference) | |
| |
| |
Format Data (Percent, Fonts and Font Size) | |
| |
| |
Use Formulas and Functions; Edit; Print Options | |
| |
| |
Use Functions | |
| |
| |
Formula Bar and Palette | |
| |
| |
Paste Function | |
| |
| |
AutoCalculate | |
| |
| |
Change Column Width | |
| |
| |
Create a Series | |
| |
| |
Natural Language Formulas | |
| |
| |
AutoComplete | |
| |
| |
Comma Format | |
| |
| |
Print Options | |
| |
| |
Edit Data | |
| |
| |
Comments | |
| |
| |
Page Setup | |
| |
| |
Multiple Undo and Redo | |
| |
| |
Page Breaks | |
| |
| |
Page Break Preview | |
| |
| |
Headers and Footers | |
| |
| |
Spell Check | |
| |
| |
Print Titles | |
| |
| |
Range Entry Using Collapse Button | |
| |
| |
Additional Formatting and Editing; Working with Workbooks | |
| |
| |
Insert and Delete Columns and Rows | |
| |
| |
Move (Cut/Paste) | |
| |
| |
Drag and Drop | |
| |
| |
Undo a Command | |
| |
| |
Copy and Paste Special | |
| |
| |
Transpose Data | |
| |
| |
AutoCorrect | |
| |
| |
Freeze Titles | |
| |
| |
Split Panes | |
| |
| |
Scroll Tips | |
| |
| |
Create New Workbook | |
| |
| |
Select Workbook | |
| |
| |
Copy and Paste Special (Extract Data) | |
| |
| |
Workbook Sheets | |
| |
| |
Group Sheets | |
| |
| |
Print Workbook | |
| |
| |
Print Worksheet on Specified Number of Pages | |
| |
| |
Named Ranges | |
| |
| |
Copy and Paste Special (Extract and Combine Data) | |
| |
| |
Arrange Workbooks | |
| |
| |
Drag and Drop Between Workbooks | |
| |
| |
Use Templates (Spreadsheet Solutions) | |
| |
| |
Original Templates | |
| |
| |
Link Workbooks | |
| |
| |
3-D Formulas | |
| |
| |
Workbook Sheets | |
| |
| |
Duplicate Workbook Window | |
| |
| |
Logical Functions; Autoformat; Protecting and Hiding Data | |
| |
| |
Insert IF Functions | |
| |
| |
Use the Paste Function Feature | |
| |
| |
IF Function | |
| |
| |
Enter a Date as Numerical Data | |
| |
| |
Format Numerical Dates | |
| |
| |
AutoFormat | |
| |
| |
Color Buttons | |
| |
| |
What-If Data Tables | |
| |
| |
Payment Function | |
| |
| |
Insert Lookup Functions | |
| |
| |
Protect a Sheet | |
| |
| |
Lock Cells in a Worksheet | |
| |
| |
Charting | |
| |
| |
Chart Basics | |
| |
| |
Select Chart Data | |
| |
| |
Chart Elements | |
| |
| |
Create Charts | |
| |
| |
Change Chart Types | |
| |
| |
Select, Size, and Edit Embedded Chart | |
| |
| |
Enable Chart Editing | |
| |
| |
Edit Chart Text | |
| |
| |
Change Chart Subtype | |
| |
| |
Custom Chart Types | |
| |
| |
Chart Toolbar | |
| |
| |
Delete an Embedded Chart | |
| |
| |
Chart Tips | |
| |
| |
Edit Chart in its Own Window | |
| |
| |
Change Legend Position | |
| |
| |
Print Charts | |
| |
| |
Print Embedded Chart Separately | |
| |
| |
Change Location of Chart | |
| |
| |
Format Chart Area | |
| |
| |
Use Data Map Feature | |
| |
| |
Edit Map and Legend | |
| |
| |
Data Map Toolbar | |
| |
| |
Microsoft Access 97 | |
| |
| |
Create a Database Form | |
| |
| |
What is Access? | |
| |
| |
What is a Database? | |
| |
| |
What is a Database Management System? | |
| |
| |
What are Database Objects? | |
| |
| |
How is an Access Database Organized? | |
| |
| |
What are Access Tables? | |
| |
| |
How are Access Tables Related? | |
| |
| |
Database Basics | |
| |
| |
Plan a Database | |
| |
| |
Create a Table (Datasheet) Design | |
| |
| |
Switch Between Table Views | |
| |
| |
Save a Datasheet Design | |
| |
| |
Open a Database File | |
| |
| |
Create a Table in Datasheet View | |
| |
| |
Primary Key | |
| |
| |
Use Date/Time and Currency Data Types | |
| |
| |
Yes/No Data Type | |
| |
| |
Open a Datasheet | |
| |
| |
Enter Records | |
| |
| |
Input Mask | |
| |
| |
Correct a Field Entry | |
| |
| |
Change Datasheet Column Width | |
| |
| |
Security | |
| |
| |
Open an Existing Table | |
| |
| |
Enhance a Table (Datasheet) | |
| |
| |
Create a Form from an Existing Datasheet | |
| |
| |
Enter Records | |
| |
| |
Use Form Design View | |
| |
| |
Undo Control Adjustments | |
| |
| |
Change Form Data Area Width | |
| |
| |
Repeat Data Entry | |
| |
| |
Edit and Print a Database | |
| |
| |
Add, Delete, and Move Fields in Design View | |
| |
| |
Add a Lookup Value List Field | |
| |
| |
Simple Print | |
| |
| |
Hide Datasheet Fields | |
| |
| |
Print Setup | |
| |
| |
Form View Toolbox | |
| |
| |
Print with headers and Footers | |
| |
| |
Edit a Record | |
| |
| |
Add and Delete a Record | |
| |
| |
Remove Gridlines | |
| |
| |
Form Backgrounds | |
| |
| |
Window Between Objects | |
| |
| |
Form AutoFormat | |
| |
| |
Lookup Field Values from Another Table | |
| |
| |
Search and Sort a Database | |
| |
| |
Find Records | |
| |
| |
Find Records and Replace Data | |
| |
| |
Search Using Wildcards | |
| |
| |
Sort Records | |
| |
| |
Quick Sort | |
| |
| |
Multiple Sorts | |
| |
| |
Filter a Record Subset | |
| |
| |
Sort a Record Subset | |
| |
| |
Edit a Record Subset | |
| |
| |
Shortcut Filters | |
| |
| |
Advanced Filter/Sort | |
| |
| |
Filter Forms | |
| |
| |
Sort a Form Subset | |
| |
| |
Queries | |
| |
| |
Create a Query | |
| |
| |
Change a Query Design | |
| |
| |
Save a Query | |
| |
| |
Use All Fields of a Table for a Query | |
| |
| |
Reposition a Datasheet Column | |
| |
| |
Rename a Query | |
| |
| |
Print a Query Datasheet | |
| |
| |
Change Field Format in Query Design | |
| |
| |
Change Field Names in a Query Design | |
| |
| |
Create a Query Using Data from Multiple Tables | |
| |
| |
Print a Query Table | |
| |
| |
Reports | |
| |
| |
Reports | |
| |
| |
Create Reports with Report Wizard | |
| |
| |
Move Design View Items (Controls) | |
| |
| |
Change and Enhance a Report | |
| |
| |
Edit Report Sections and Controls | |
| |
| |
Change Item Order | |
| |
| |
Change Control Properties | |
| |
| |
Hide Duplicate Entries | |
| |
| |
Create a Report from a Query | |
| |
| |
Add Report Sections and Controls | |
| |
| |
Group Controls and Headers and Footers | |
| |
| |
Add Report Statistics | |
| |
| |
Add New Fields to a Report | |
| |
| |
Create a Database with the Database Wizard | |
| |
| |
Microsoft Powerpoint 97 | |
| |
| |
Create, Save, and Print a Presentation | |
| |
| |
About PowerPoint | |
| |
| |
Start PowerPoint | |
| |
| |
The Blank Presentation Option | |
| |
| |
Use the Template Option | |
| |
| |
Add Slides to a Presentation | |
| |
| |
Save a Presentation | |
| |
| |
Exit PowerPoint | |
| |
| |
Open a Presentation | |
| |
| |
Slide Views | |
| |
| |
Move from Slide to Slide | |
| |
| |
Spell Checking | |
| |
| |
Print a Presentation | |
| |
| |
Change a Slide's Layout or Template | |
| |
| |
Work with Object Slides | |
| |
| |
Use Undo | |
| |
| |
Move, Copy, Duplicate, and Delete Slides | |
| |
| |
Slide Sorter View | |
| |
| |
Outline View | |
| |
| |
Enhance Slides; Work with Text and Objects | |
| |
| |
Select, Align, and Change the Appearance of Text | |
| |
| |
Change a Slide's Color Scheme | |
| |
| |
Change Case | |
| |
| |
Copy Text Formatting | |
| |
| |
Move and Copy Text | |
| |
| |
Increate/Decrease Paragraph Formatting | |
| |
| |
Move and Size Placeholders | |
| |
| |
Use Slide and Title Master | |
| |
| |
Insert Slide Numbers, Date and Time, and Footer | |
| |
| |
Format Bullets | |
| |
| |
Use Slide Rulers and Guides | |
| |
| |
Floating Toolbars | |
| |
| |
Draw Graphic Objects | |
| |
| |
AutoShapes | |
| |
| |
Create Text Objects | |
| |
| |
Group and Ungroup Objects | |
| |
| |
Layer Objects | |
| |
| |
Create a Chart, Table, or an Excel Worksheet on a Slide | |
| |
| |
Insert Organization Chart Slide | |
| |
| |
Work with Slide Shows | |
| |
| |
Show a Presentation | |
| |
| |
Add Transitions, Sound, and Timing | |
| |
| |
Animate Text and Objects | |
| |
| |
Animation Effects Toolbar | |
| |
| |
Present Animation for Bulleted Lists | |
| |
| |
Custom Animation | |
| |
| |
PowerPoint Central | |
| |
| |
The Annotator | |
| |
| |
Create Continuously Running Presentations | |
| |
| |
Set Up a Slide Show | |
| |
| |
Create Notes Pages and Handouts | |
| |
| |
Notes Master and Handout Master | |
| |
| |
Print Notes Master and Handout Master | |
| |
| |
Pack and Go | |
| |
| |
Integration | |
| |
| |
Window Files in One Application | |
| |
| |
Window Files From Different Applications | |
| |
| |
Integrate an Excel Worksheet and a Word Document | |
| |
| |
Internet Basics | |
| |
| |
Use Internet Features | |
| |
| |
Object Linking and Embedding | |
| |
| |
Link Files | |
| |
| |
Edit a Linked File | |
| |
| |
Embed a File | |
| |
| |
Office Links | |
| |
| |
Financial Data on the Internet | |
| |
| |
Integrate an Excel Charge and a Word Document (OLE) | |
| |
| |
Embed a Chart | |
| |
| |
Link a Chart | |
| |
| |
Edit a Chart | |
| |
| |
Favorites on the Web Toolbar | |
| |
| |
Office Links | |
| |
| |
Export an Access Database to an Excel | |
| |
| |
Copy Images from the Internet | |
| |
| |
Merge an Access Table with a Word Main Document | |
| |
| |
Mail Merge | |
| |
| |
Use Internet Locator/Map Sites | |
| |
| |
Import/Export an Outline | |
| |
| |
Link an Excel Worksheet | |
| |
| |
Hyperlinks | |
| |
| |
Create Hyperlinks in Word | |
| |
| |
Hyperlink to the Internet | |
| |
| |
Export a PowerPoint Slide or File into a Word Document | |
| |
| |
Import a PowerPoint Presentation into a Word Document | |
| |
| |
Internet Research | |