did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9780789513328

Microsoft Office 97 : Introductory Concepts and Techniques

by
  • ISBN13:

    9780789513328

  • ISBN10:

    0789513323

  • Edition: Disk
  • Format: Paperback
  • Copyright: 1997-04-08
  • Publisher: Course Technology
  • View Upgraded Edition

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $91.95 Save up to $22.99
  • Buy Used
    $68.96
    Add to Cart Free Shipping Icon Free Shipping

    USUALLY SHIPS IN 2-4 BUSINESS DAYS

Supplemental Materials

What is included with this book?

Table of Contents

Introduction to Computers 1(1)
Introduction to Computers
1(1)
Objectives
1(1)
Why Study Computers and Application Software?
2(1)
What Is a Computer?
3(1)
What Does a Computer Do?
3(1)
What Are the Components of a Computer?
4(10)
Input Devices
5(2)
The Processor Unit
7(1)
Output Devices
7(3)
Auxiliary Storage
10(4)
Computer Software
14(1)
System Software
14(1)
Application Software
14(1)
Personal Computer Application Software Packages
15(3)
What Is Communications?
18(2)
Communications Channels
19(1)
Communications Equipment
19(1)
Communication Networks
20(2)
Local Area Networks (LANs)
20(2)
Wide Area Networks (WANs)
22(1)
How to Purchase, Install, and Maintain a Personal Computer
22(1)
How to Purchase a Computer System
23(4)
How to Install a Computer System
27(2)
How to Maintain Your Computer System
29(1)
Summary of Introduction to Computers
30(1)
Student Assignments
30(2)
Index
32(1)
Photo Credits
32
Microsoft Windows 95 1(1)
PROJECT ONE FUNDAMENTALS OF USING WINDOWS 95
Objectives
1(3)
Introduction
4(1)
Microsoft Windows 95
4(4)
What Is a User Interface?
5(1)
Starting Microsoft Windows 95
6(1)
Closing the Welcome Screen
7(1)
The Desktop as a Work Area
7(1)
Communicating with Microsoft Windows 95
8(15)
Mouse Operations
8(1)
Point and Click
8(2)
Right-Click
10(1)
Double-Click
11(1)
My Computer Window
12(1)
Minimize Button
13(1)
Maximize and Restore Buttons
14(2)
Close Button
16(1)
Drag
17(2)
Sizing a Window by Dragging
19(1)
Scrolling in a Window
19(2)
Resizing a Window
21(1)
Closing a Window
21(1)
Right-Drag
21(2)
The Keyboard and Keyboard Shortcuts
23(1)
Creating a Document by Starting an Application Program
23(9)
Creating a Document
26(1)
Saving a Document on Disk
26(4)
Printing a Document
30(2)
Closing a Program
32(1)
Modifying a Document Stored on Disk
32(4)
Closing the Notepad Program
35(1)
Using Windows Help
36(6)
Contents Sheet
36(4)
Index Sheet
40(2)
Shutting Down Windows 95
42(2)
Project Summary
44(1)
What You Should Know
44(1)
Test Your Knowledge
45(3)
Use Help
48(2)
In the Lab
50(2)
Cases and Places
52
PROJECT TWO USING WINDOWS EXPLORER
Objectives
1(3)
Introduction
4(1)
Starting Windows 95
4(3)
Starting Windows Explorer and Maximizing Its Window
5(2)
Windows Explorer
7(5)
Displaying the Contents of a Folder
8(2)
Expanding a Folder
10(1)
Collapsing a Folder
11(1)
Copying Files to a Folder on a Floppy Disk
12(14)
Creating a New Folder
12(3)
Displaying the Destination Folder
15(1)
Displaying the Contents of the Windows Folder
16(2)
Changing the View
18(2)
Selecting a Group of Files
20(2)
Copying a Group of Files
22(1)
Displaying the Contents of the My Files Folder
23(1)
Renaming a File or Folder
24(2)
Deleting a File or Folder
26(6)
Deleting a File by Right-Clicking Its Filename
27(1)
Deleting a File by Right-Dragging Its Filename
28(3)
Deleting a Folder
31(1)
Quitting Windows Explorer and Shutting Down Windows 95
32(1)
Project Summary
33(1)
What You Should Know
33(1)
Test Your Knowledge
34(3)
Use Help
37(1)
In the Lab
38(4)
Cases and Places
42
Microsoft Office 97 1(1)
PROJECT ONE AN INTRODUCTION TO MICROSOFT OFFICE 97
Microsoft Office 97
2(1)
Microsoft Office 97 and the Internet
2(1)
Microsoft Word 97
3(1)
Microsoft Word 97 and the Internet
4(1)
Microsoft Excel 97
4(2)
Microsoft Excel 97 and the Internet
5(1)
Microsoft Access 97
6(1)
Microsoft Access 97 and the Internet
6(1)
Microsoft PowerPoint 97
7(1)
Microsoft PowerPoint 97 and the Internet
7(1)
The Web Toolbar
8(1)
Microsoft Outlook 97
9(5)
Viewing Electronic Mail (E-Mail)
9(1)
Viewing Appointments
10(1)
Viewing Contacts
11(1)
Viewing Tasks
11(1)
Viewing Journal Entries
12(1)
Viewing Notes
13(1)
The Office Assistant
14(1)
Hardware Innovations and Microsoft Office 97
14(1)
Project Summary
15(1)
In the Lab
16
Microsoft Word 97 1(1)
PROJECT ONE CREATING AND EDITING A WORD DOCUMENT
Objectives
3(3)
What Is Microsoft Word?
6(1)
Project One --- Paradise Island Announcement
6(2)
Document Preparation Steps
7(1)
Mouse Usage
8(1)
Starting Word
8(2)
The Word Screen
10(4)
Word Document Window
10(2)
Menu Bar, Toolbars, Rulers, and Status Bar
12(2)
Changing the Default Font Size
14(1)
Entering Text
15(10)
Entering Blank Lines into a Document
17(1)
Displaying Nonprinting Characters
18(1)
Entering More Text
19(1)
Using the Wordwrap Feature
19(1)
Checking Spelling Automatically as You Type
20(1)
Entering Documents that Scroll the Document Window
21(2)
AutoFormat As You Type
23(2)
Saving a Document
25(3)
Formatting Paragraphs and Characters in a Document
28(11)
Selecting and Formatting Paragraphs and Characters
29(1)
Selecting Multiple Paragraphs
29(1)
Centering Selected Paragraphs
30(1)
Selecting a Single Line
31(1)
Changing the Font Size of Selected Text
31(1)
Changing the Font of Selected Text
32(1)
Bold Selected Text
33(1)
Continuing to Format Text
34(1)
Scrolling
34(1)
Selecting a Single Word
35(1)
Underlining Selected Text
36(1)
Selecting a Group of Words and Formatting Them
36(2)
Centering a Paragraph
38(1)
Inserting a Picture from the Web into a Word Document
39(7)
Resizing an Imported Graphic
44(2)
Restoring a Resized Graphic to Its Original Size
46(1)
Saving an Existing Document with the Same File Name
46(1)
Printing a Document
47(2)
Quitting Word
49(1)
Opening a Document
50(1)
Correcting Errors
51(3)
Types of Changes Made to Documents
51(1)
Inserting Text into an Existing Document
52(1)
Deleting Text from an Existing Document
53(1)
Undoing Recent Actions
53(1)
Closing the Entire Document
54(1)
Microsoft Word Help
54(6)
Using the Office Assistant
54(3)
Using the Contents and Index Command to Obtain Help
57(2)
Obtaining Web Information
59(1)
Using What's This? or the Question Mark Button
59(1)
Wizards
60(1)
Project Summary
60(1)
What You Should Know
60(1)
Test Your Knowledge
61(2)
Use Help
63(1)
Apply Your Knowledge
64(1)
In the Lab
65(4)
Cases and Places
69
PROJECT TWO USING WORD'S WIZARDS AND TEMPLATES TO CREATE A COVER LETTER AND RESUME
Objectives
1(3)
Introduction
4(1)
Project Two --- Cover Letter and Resume
5(1)
Document Preparation Steps
6(1)
Using Word's Resume Wizard to Create a Resume
6(8)
Personalizing the Resume
14(11)
Displaying Nonprinting Characters
14(1)
Tables
15(1)
Styles
15(1)
Inserting a Blank Line above a Paragraph
16(1)
Selecting and Replacing Text
16(3)
Entering a Line Break
19(1)
AutoFormat As You Type
20(3)
Changing the Font Size of Characters in the Resume
23(2)
Viewing and Printing the Resume in Print Preview
25(2)
Saving the Resume
27(1)
Creating a Cover Letter
27(4)
Components of a Business Letter
27(1)
Using a Letter Template to Create a Resume Cover Letter
28(2)
Printing the Cover Letter Generated Using Word's Professional Letter Template
30(1)
Personalizing the Cover Letter
31(15)
Zooming a Document on the Screen
31(1)
Selecting and Replacing Template Placeholder Text
32(2)
Creating an Auto Text Entry
34(2)
Saving the Cover Letter
36(1)
Applying Formatting Using Shortcut Keys
36(2)
Inserting an Auto Text Entry
38(2)
Switching Two Sentences in the Resume
40(2)
Using the TAB Key
42(4)
Checking Spelling at Once
46(3)
Saving Again and Printing the Cover Letter
48(1)
Working with Multiple Open Documents
49(2)
Project Summary
51(1)
What You Should Know
51(1)
Test Your Knowledge
52(3)
Use Help
55(1)
Apply Your Knowledge
56(1)
In the Lab
57(3)
Cases and Places
60
PROJECT THREE CREATING A RESEARCH PAPER WITH A TABLE
Objective
1(3)
Introduction
4(1)
Project Three --- Research Paper with a Table
4(3)
Starting Word
5(1)
MLA Documentation Style
6(1)
Document Preparation Steps
6(1)
Displaying Nonprinting Characters
7(1)
Changing the Margins
7(2)
Adjusting Line Spacing
9(3)
Using a Header to Number Pages
12(3)
Headers and Footers
12(3)
Typing the Body of the Research Paper
15(1)
Changing the Default Font Size
15(1)
Entering Name and Course Information
16(1)
Centering a Paragraph Before Typing
16(21)
Saving the Research Paper
18(1)
Indenting Paragraphs
18(2)
Zooming Page Width
20(1)
Using Word's AutoCorrect Feature
21(4)
Adding Footnotes
25(4)
Automatic Page Breaks
29(1)
Creating a Table with the Insert Table Button
30(2)
Entering Data into a Word Table
32(2)
Formatting a Table
34(1)
Changing the Line Spacing of the Table
35(1)
Changing Paragraph Formatting
36(1)
Creating an Alphabetical Works Cited Page
37(7)
Manual Page Breaks
38(1)
Centering the Title of the Works Cited Page
39(1)
Creating a Hanging Indent
40(1)
Creating a Hyperlink
41(2)
Sorting Paragraphs
43(1)
Proofing and Revising the Research Paper
44(8)
Going to a Specific Location in a Document
45(1)
Finding and Replacing Text
46(2)
Finding Text
48(1)
Using the Thesaurus
48(1)
Using Word Count
49(1)
Checking Spelling, Saving Again, and Printing the Document
50(1)
Navigating to a Hyperlink
51(1)
Project Summary
52(1)
What You Should Know
52(1)
Test Your Knowledge
53(2)
Use Help
55(1)
Apply Your Knowledge
56(1)
In the Lab
57(6)
Cases and Places
63
INTEGRATION FEATURE CREATING WEB PAGES
Introduction
1(2)
Saving a Word Document as a Web Page
3(4)
Viewing a Web Page Document
5(2)
Using Word's Web Page Wizard to Create a Web Page
7(2)
Personalizing the Web Page with Hyperlinks
9(2)
Converting Text to a Hyperlink
10(1)
Summary
11(1)
In the Lab
12
Microsoft Excel 97 1(1)
PROJECT ONE CREATING A WORKSHEET AND EMBEDDED CHART
Objectives
3(3)
What Is Microsoft Excel?
6(1)
Project One --- Computer Daily Sales
6(4)
Preparation Steps
7(1)
Mouse Usage
8(1)
Starting Excel
8(2)
The Excel Window
10(4)
The Workbook
10(1)
The Worksheet
10(1)
Cell, Active Cell, Gridlines, and Mouse Pointer
11(1)
Worksheet Window
12(1)
Menu Bar, Standard Toolbar, Formatting Toolbar, Formula Bar, Sheet and Scroll Tabs, and Status Bar
12(2)
Selecting a Cell
14(1)
Entering Text
14(6)
Entering the Worksheet Title
15(1)
Correcting a Mistake While Typing
16(1)
AutoCorrect
16(1)
Entering Column Titles
17(1)
Entering Row Titles
18(2)
Entering Numbers
20(1)
Calculating a Sum
21(2)
Using the Fill Handle to Copy a Cell to Adjacent Cells
23(3)
Determining Row Totals
25(1)
Formatting the Worksheet
26(5)
Fonts, Font Size, and Font Style
27(1)
Bolding a Cell
28(1)
Increasing the Font Size
29(1)
Centering the Worksheet Title Across Columns
30(1)
Using AutoFormat to Format the Body of a Worksheet
31(2)
Using the Name Box to Select a Cell
33(2)
Adding a 3-D Column Chart to the Worksheet
35(4)
Saving a Workbook
39(4)
Printing the Worksheet
43(1)
Quitting Excel
44(1)
Starting Excel and Opening a Workbook
45(2)
AutoCalculate
47(2)
Correcting Errors
49(3)
Correcting Errors Prior to Entering Data into a Cell
49(1)
In-Cell Editing
49(1)
Undoing the Last Entry
50(1)
Clearing a Cell or Range of Cells
51(1)
Clearing the Entire Worksheet
51(1)
Excel Online Help
52(9)
Using the Office Assistant
52(2)
Displaying Tips to Improve Your Work Habits
54(1)
Using the Contents Sheet to Obtain Help
55(2)
Using the Index Sheet to Obtain Help
57(2)
Using the Find Sheet to Obtain Help
59(1)
Obtaining Help and Other Information from the Web
60(1)
Using the Question Mark Button or What's This? Command to Define Items on the Screen
60(1)
Quitting Excel
61(1)
Project Summary
61(1)
What You Should Know
61(1)
Test Your Knowledge
62(2)
Use Help
64(2)
Apply Your Knowledge
66(1)
In the Lab
67(4)
Cases and Places
71
PROJECT TWO FORMULAS, FORMATTING, CHARTS, AND WEB QUERIES
Objectives
1(3)
Introduction
4(1)
Project Two --- High-Tech Stock Club
4(3)
Preparation Steps
5(2)
Starting Excel
7(1)
Entering the Titles and Numbers into the Worksheet
7(2)
Entering Formulas
9(6)
Order of Operations
10(1)
Entering Formulas Using Point Mode
11(1)
Entering Formulas Using Natural Language
12(1)
Copying the Formulas Using the Fill Handle
13(1)
Determining the Totals Using the AutoSum Button
14(1)
Using the AVERAGE, MAX, and MIN Functions
15(6)
Determining the Average of a Range of Numbers
15(1)
Determining the Highest Number in a Range of Numbers
16(1)
Determining the Lowest Number in a Range of Numbers
17(2)
Copying the AVERAGE, MAX, and MIN Functions
19(1)
Entering the Percentage Gain/Loss Formula
20(1)
Applying Formats to the Text
21(7)
Changing the Font and Centering the Worksheet Title
23(2)
Changing Worksheet Title Background and Font Colors and Applying an Outline Border
25(2)
Applying Formats to the Column Titles
27(1)
Applying Formats to the Numbers
28(6)
Formatting Numbers Using the Formatting Toolbar
29(2)
Formatting Numbers Using the Format Cells Command on the Shortcut Menu
31(2)
Formatting Numbers Using the Percent Style Button and Increase Decimal Button
33(1)
Changing the Widths of Columns and Heights of Rows
34(5)
Changing the Widths of Columns
35(2)
Changing the Heights of Rows
37(2)
Checking Spelling
39(2)
Saving a Workbook a Second Time Using the Same File Name
41(1)
Adding a 3-D Pie Chart to the Workbook
41(10)
Drawing the 3-D Pie Chart
42(4)
Formatting the Chart Title and Chart Labels
46(1)
Changing the Colors of the Slices
47(2)
Exploding the 3-D Pie Chart
49(1)
Rotating and Tilting the 3-D Pie Chart
49(2)
Changing the Sheet Names and Rearranging the Order of the Sheets
51(2)
Previewing and Printing Selected Sheets in a Workbook
53(6)
Printing Selected Sheets in a Workbook
55(2)
Printing a Section of the Worksheet
57(2)
Displaying and Printing the Formulas in the Worksheet
59(2)
Changing the Print Scaling Option Back to 100%
61(1)
Getting External Data from a Web Source Using a Web Query
61(4)
Quitting Excel
65(1)
Project Summary
65(1)
What You Should Know
66(1)
Test Your Knowledge
67(3)
Use Help
70(1)
Apply Your Knowledge
71(1)
In the Lab
72(8)
Cases and Places
80
PROJECT THREE WHAT-IF ANALYSIS AND WORKING WITH LARGE WORKSHEETS
Objectives
1(3)
Introduction
4(2)
Project Three --- Home Network Computers Six-Month Plan
6(2)
Preparation Steps
6(1)
Starting Excel
7(1)
Changing the Font of the Entire Worksheet to Bold
7(1)
Entering the Worksheet Titles
7(1)
Rotating Text and Using the Fill Handle to Create a Series
8(2)
Copying a Cell's Format Using the Format Painter Button
10(2)
Increasing the Column Widths and Entering Row Titles
12(1)
Copying a Range of Cells to a Nonadjacent Paste Area
13(2)
Using Drag and Drop to Move or Copy Cells
15(1)
Inserting and Deleting Cells in a Worksheet
15(2)
Inserting Rows
15(2)
Inserting Columns
17(1)
Inserting Individual Cells or a Range of Cells
17(1)
Deleting Columns and Rows
17(1)
Deleting Individual Cells or a Range of Cells
17(1)
Entering Numbers with a Format Symbol
17(2)
Freezing Worksheet Titles
19(2)
Entering the Projected Sales
20(1)
Displaying the System Date
21(2)
Absolute Versus Relative Addressing
23(2)
Entering the January Advertising and Commission Formulas
24(1)
Making Decisions --- The If Function
25(6)
Entering the Remaining Projected Expense and Net Income Formulas for January
28(1)
Copying the January Projected Expenses and Totals Formulas to the Other Months
29(1)
Determining the Projected Total Expenses by Category and Total Net Income
29(1)
Unfreezing Worksheet Titles and Saving the Workbook
30(1)
Formatting the Worksheet
31(4)
Formatting the Numbers
31(2)
Formatting the Worksheet Titles
33(2)
Displaying the Drawing Toolbar
35(6)
Moving and Docking a Toolbar
36(1)
Adding a Drop Shadow to the Title Area
37(1)
Formatting the Category Row Titles and Net Income Row
38(2)
Formatting the Assumptions Table
40(1)
Hiding a Toolbar
41(1)
Creating a 3-D Column Chart on a Chart Sheet
41(6)
Drawing the 3-D Column Chart
42(2)
Enhancing the 3-D Column Chart
44(3)
Displaying the Magnitude of a Column in the Chart
47(1)
Changing the Name of the Sheets and Rearranging the Order of the Sheets
47(1)
Checking Spelling, Saving, Previewing, and Printing the Workbook
48(1)
Checking Spelling in Multiple Sheets
49(1)
Previewing and Printing the Workbook
49(1)
Changing the View of the Worksheet
49(5)
Shrinking and Magnifying the View of a Worksheet or Chart
49(3)
Splitting the Window into Panes
52(2)
What-If Analysis
54(2)
Goal Seeking
56(2)
Quitting Excel
57(1)
Project Summary
58(1)
What You Should Know
58(1)
Test Your Knowledge
59(4)
Use Help
63(1)
Apply Your Knowledge
64(1)
In the Lab
65(9)
Cases and Places
74
INTEGRATION FEATURE LINKING AN EXCEL WORKSHEET TO A WORD DOCUMENT
Introduction
1(2)
Opening a Word Document and an Excel Workbook
3(1)
Linking an Excel Worksheet to a Word Document
4(2)
Printing and Saving the Word Document with the Linked Worksheet
6(2)
Editing the Linked Worksheet
8(1)
Summary
9(1)
What You Should Know
9(1)
In the Lab
9
Microsoft Access 97 1(1)
PROJECT ONE CREATING A DATABASE USING DESIGN AND DATASHEET VIEWS
Objectives
3(3)
Introduction
6(2)
Project One --- Pilotech Services Database
8(1)
What Is Microsoft Access?
8(1)
Overview of Project Steps
9(1)
Mouse Usage
9(1)
Starting Access and Creating a New Database
10(2)
The Access Desktop and the Database Window
12(1)
Creating a Table
13(6)
Defining the Fields
16(2)
Correcting Errors in the Structure
18(1)
Saving a Table
19(1)
Adding Records to a Table
20(4)
Closing a Table and a Database and Quitting Access
24(1)
Opening a Database
24(2)
Adding Additional Records
26(2)
Correcting Errors in the Data
28(1)
Previewing and Printing the Contents of a Table
28(4)
Creating Additional Tables
32(3)
Adding Records to the Additional Table
34(1)
Using a Form to View Data
35(5)
Creating a Form
35(1)
Closing and Saving the Form
36(1)
Opening the Saved Form
37(1)
Using the Form
38(1)
Switching Between Form View and Datasheet View
39(1)
Creating a Report
40(6)
Selecting the Fields for the Report
42(1)
Completing the Report
43(2)
Printing the Report
45(1)
Closing the Database
46(1)
Microsoft Access Help
46(8)
Using the Office Assistant
46(3)
Using the Contents Sheet to Obtain Help
49(2)
Using the Index Sheet to Obtain Help
51(1)
Using the Find Sheet to Obtain Help
52(1)
Obtaining Web Information
53(1)
Using the Question Mark Button or Help Button to Define Items on the Screen
54(1)
Designing a Database
54(3)
Project Summary
57(1)
What You Should Know
57(1)
Test Your Knowledge
58(3)
Use Help
61(1)
Apply Your Knowledge
62(3)
In the Lab
65(8)
Cases and Places
73
PROJECT TWO QUERYING A DATABASE USING THE SELECT QUERY WINDOW
Objectives
1(3)
Introduction
4(1)
Project Two --- Querying the Pilotech Services Database
4(3)
Overview of Project Steps
6(1)
Opening the Database
6(1)
Creating a New Query
7(9)
Using the Select Query Window
10(1)
Displaying Selected Fields in a Query
10(2)
Running a Query
12(1)
Printing the Results of a Query
13(1)
Returning to the Select Query Window
14(1)
Closing a Query
15(1)
Including All Fields in a Query
16(1)
Clearing the Design Grid
17(1)
Entering Criteria
18(6)
Using Text Data in Criteria
18(1)
Using Wildcards
19(1)
Criteria for a Field Not in the Result
20(2)
Using Numeric Data in Criteria
22(1)
Using Comparison Operators
23(1)
Using Compound Criteria
24(3)
Sorting Data in a Query
27(5)
Sorting on Multiple Keys
28(2)
Omitting Duplicates
30(2)
Joining Tables
32(4)
Restricting Records in a Join
35(1)
Using Computed Fields in a Query
36(2)
Calculating Statistics
38(6)
Using Criteria in Calculating Statistics
40(2)
Grouping
42(2)
Saving a Query
44(1)
Closing a Database
45(1)
Project Summary
46(1)
What You Should Know
46(1)
Test Your Knowledge
47(4)
Use Help
51(2)
Apply Your Knowledge
53(1)
In the Lab
54(4)
Cases and Places
58
PROJECT THREE MAINTAINING A DATABASE USING THE DESIGN AND UPDATE FEATURES OF ACCESS
Objectives
1(3)
Introduction
4(1)
Project Three --- Maintaining the Pilotech Services Database
4(1)
Overview of Project Steps
5(1)
Opening the Database
6(1)
Adding, Changing, and Deleting
6(6)
Adding Records
6(2)
Searching for a Record
8(1)
Changing the Contents of a Record
9(1)
Switching Between Views
10(1)
Deleting Records
11(1)
Changing the Structure
12(11)
Changing the Size of a Field
13(1)
Adding a New Field
14(2)
Updating the Restructured Database
16(1)
Resizing Columns
17(2)
Using an Update Query
19(2)
Using a Delete Query to Delete a Group of Records
21(2)
Creating Validation Rules
23(8)
Specifying a Required Field
23(1)
Specifying a Range
24(1)
Specifying a Default Value
25(1)
Specifying a Collection of Legal Values
26(1)
Using a Format
26(1)
Saving Rules, Values, and Formats
27(1)
Updating a Table that Contains Validation Rules
28(2)
Making Individual Changes to a Field
30(1)
Specifying Referential Integrity
31(4)
Ordering Records
35(3)
Ordering Records on Multiple Fields
36(2)
Creating and Using Indexes
38(7)
How Does Access Use an Index?
41(1)
When Should You Create an Index?
41(1)
Creating Single-Field Indexes
42(1)
Creating Multiple-Field Indexes
43(2)
Closing the Database
45(1)
Project Summary
45(1)
What You Should Know
45(1)
Test Your Knowledge
46(4)
Use Help
50(2)
Apply Your Knowledge
52(2)
In the Lab
54(7)
Cases and Places
61
INTEGRATION FEATURE INTEGRATING EXCEL WORKSHEET DATA INTO AN ACCESS DATABASE
Introduction
1(2)
Creating an Access Database
3(1)
Converting an Excel Worksheet to an Access Database
3(5)
Using the Access Table
8(1)
Summary
8(1)
What You Should Know
8(1)
Use Help
9
Microsoft PowerPoint 97 1(1)
PROJECT ONE USING A DESIGN TEMPLATE AND STYLE CHECKER TO CREATE A PRESENTATION
Objectives
3(3)
What Is PowerPoint?
6(2)
Project One --- Unlocking the Internet
8(2)
Mouse Usage
9(1)
Slide Preparation Steps
10(1)
Starting a Presentation as a New Office Document
10(5)
The PowerPoint Window
14(1)
PowerPoint Views
15(3)
PowerPoint Window in Slide View
15(3)
Creating a Title Slide
18(2)
Entering the Presentation Title
18(1)
Correcting a Mistake When Typing
19(1)
Entering the Presentation Subtitle
19(1)
Attributes
20(3)
Changing the Font Size
21(1)
Changing the Style of Text to Italic
22(1)
Saving a Presentation to a Floppy Disk
23(2)
Adding a New Slide to a Presentation
25(2)
Creating a Bulleted List Slide
27(4)
Entering a Slide Title
28(1)
Selecting a Text Placeholder
28(1)
Typing a Multi-level Bulleted List
29(2)
Adding a New Slide with the Same AutoLayout
31(2)
Saving a Presentation with the Same File Name
33(1)
Moving to Another Slide in Slide View
34(1)
Using the Vertical Scroll Bar to Move to Another Slide
34(1)
Viewing the Presentation Using Slide Show
35(3)
Starting Slide Show View
35(1)
Advancing through a Slide Show Manually
36(1)
Displaying the Popup Menu in Slide Show View
37(1)
Using the Popup Menu to End a Slide Show
38(1)
Quitting PowerPoint
38(1)
Opening a Presentation
39(2)
Opening an Existing Presentation
39(2)
Checking a Persentation for Visual Clarity, Consistency, and Style
41(3)
Starting Style Checker
42(2)
Correcting Errors
44(1)
Types of Corrections Made to Presentations
45(1)
Deleting Text
45(1)
Replacing Text into an Existing Slide
45(1)
Changing Line Spacing
45(5)
Displaying the Slide Master
46(1)
Changing Line Spacing on the Slide Master
47(3)
Displaying a Presentation in Black and White
50(1)
Printing a Presentation
51(3)
Saving Before Printing
52(1)
Printing the Presentation
52(2)
Making a Transparency
54(1)
PowerPoint Help
54(8)
Using Office Assistant
54(3)
Using the Contents Sheet to Obtain Help
57(2)
Using the Index Sheet to Obtain Help
59(1)
Using the Find Sheet to Obtain Help
60(2)
Using the Question Mark Button to Obtain Online Help
62(1)
Quitting PowerPoint
62(1)
Project Summary
63(1)
What You Should Know
63(1)
Test Your Knowledge
64(3)
Use Help
67(1)
Apply Your Knowledge
68(1)
In the Lab
69(3)
Cases and Places
72
PROJECT TWO USING OUTLINE VIEW AND CLIP ART TO CREATE AN ELECTRONIC SLIDE SHOW
Objectives
1(3)
Creating a Presentation from an Outline
4(1)
Project Two --- Break Away Bargains
5(2)
Presentation Preparation Steps
6(1)
Starting a New Presentation
7(1)
Using Outline View
7(3)
The PowerPoint Window in Outline View
9(1)
Creating a Presentation in Outline View
10(2)
Creating a Title Slide in Outline View
10(2)
Adding a Slide in Outline View
12(1)
Creating Multi-level Bulleted List Slides in Outline View
13(3)
Creating a Subordinate Slide
15(1)
Creating a Second Subordinate Slide
16(1)
Creating a Slide with Multiple Text Objects in Outline View
16(1)
Creating a Closing Slide in Outline View
17(1)
Saving a Presentation
18(1)
Reviewing a Presentation in Slide Sorter View
19(1)
Adding a Blank Line to a Bulleted List
20(3)
Adding a Blank Line to Slide 2
21(2)
Changing Slide Layout
23(1)
Moving Text
24(2)
Adding Clip Art to a Slide
26(7)
Using AutoLayouts to Add Clip Art
26(1)
Changing Slide Layout to Clip Art & Text
27(2)
Inserting Clip Art into a Clip Art Placeholder
29(3)
Inserting Clip Art on a Slide without a Clip Art Placeholder
32(1)
Moving Clip Art
33(1)
Changing the Size of Clip Art
33(3)
Saving the Presentation Again
36(1)
Adding a Header and Footer to Outline Pages
36(2)
Using the Notes and Handouts Sheet to Add Headers and Footers
36(2)
Checking the Presentation for Spelling and Style Errors
38(1)
Adding Animation Effects
38(4)
Adding Slide Transitions to a Slide Show
39(3)
Slide Sorter Toolbar
42(1)
Applying Animation Effects to Bulleted Slides
42(5)
Animating Clip Art Objects
47(3)
Displaying a Slide in Slide View
47(1)
Animating Clip Art
47(3)
Formatting and Animating a Title Slide
50(1)
Saving the Presentation Again
51(1)
Running an Animated Slide Show
51(2)
Printing in Outline View
53(5)
Printing an Outline
53(3)
Printing Presentation Slides
56(2)
Saving and Quitting PowerPoint
58(1)
Project Summary
58(1)
What You Should Know
58(1)
Test Your Knowledge
59(3)
Use Help
62(1)
Apply Your Knowledge
63(2)
In the Lab
65(7)
Cases and Places
72
INTEGRATION FEATURE IMPORTING CLIP ART FROM THE MICROSOFT CLIP GALLERY LIVE WEB SITE
Introduction
1(1)
Opening an Existing Presentation and Saving it with a New File Name
2(2)
Opening an Existing Presentation
3(1)
Saving a Presentation with a New File Name
3(1)
Moving to Another Slide
3(1)
Importing Clip Art from Microsoft Clip Gallery Live on the World Wide Web
4(1)
Opening Microsoft Clip Gallery 3.0
5(1)
Connecting to the Microsoft Clip Gallery Live World Wide Web Site
5(1)
Searching for Microsoft Clip Gallery Live Clip Art
6(3)
Quitting a Web Session
9(2)
Adding Animation Effects
9(1)
Saving the Presentation
9(1)
Running an Animated Slide Show
10(1)
Printing Presentation Slides
10(1)
Quitting PowerPoint
10(1)
Project Summary
11(1)
What You Should Know
11(1)
In the Lab
11
Microsoft Outlook 97 1(1)
PROJECT ONE DESKTOP INFORMATION MANAGEMENT USING OUTLOOK
Objectives
1(3)
What Is Microsoft Outlook?
4(1)
Project One --- Best Montgomery's DIM System
4(2)
Preparation Steps
6(1)
Starting Outlook
6(1)
Opening the Calendar Folder
7(1)
The Calendar-Microsoft Outlook Window
8(3)
Creating a Personal Subfolder in the Calendar Folder
9(2)
Entering Appointments Using the Appointment Area
11(8)
Entering Appointments Using the Appointment Window
13(1)
Recurring Appointments
14(2)
Moving to the Next Day in the Calendar
16(2)
Using Natural Language Phrases to Enter Appointment Dates and Times
18(1)
Editing Appointments
19(2)
Deleting Appointments
20(1)
Moving Appointments to a New Time
21(1)
Moving Appointments to a New Date
22(1)
Moving an Appointment to a New Month
23(2)
Creating an Event
25(1)
Displaying the Calendar in Week and Month Views
26(2)
Week View
26(1)
Month View
27(1)
Creating a Task List Using the TaskPad
28(2)
Printing a Calendar
30(3)
Daily Style
30(1)
Weekly Style
31(1)
Monthly Style
32(1)
Printing the Task List
32(1)
Contacts
33(1)
Creating a Personal Subfolder in the Contacts Folder
33(2)
Creating a Contact List
35(2)
Printing the Contact List
37(1)
Exporting Subfolders
38(2)
Deleting Subfolders
40(1)
Importing Subfolders
41(1)
Quitting Outlook
42(1)
Project Summary
42(1)
What You Should Know
43(1)
Test Your Knowledge
43(2)
Use Help
45(1)
In the Lab
45(2)
Cases and Places
47
Office 97 Integration 1
PROJECT ONE INTRODUCTION TO INTEGRATING OFFICE 97 APPLICATIONS
Objectives
1(5)
Introduction
6(1)
Integration Project --- High-Tech Stock Club Monthly Reporting System
7(3)
Reporting System Preparation Steps
10(1)
Opening an Excel Workbook
10(1)
Creating a 3-D Reference
11(4)
Applying Currency Style to a Cell
13(1)
Copying a 3-D Reference to Other Cells
14(1)
Saving a Workbook with a New File Name
14(1)
Refreshing External Data from a Web Source Using a Web Query
15(1)
Embedding an Excel Chart and a Worksheet into a Word Document
16(9)
Embedding an Excel Chart into a Word Document
17(3)
Changing the Size of an Embedded Object
20(2)
Embedding an Excel Worksheet into a Word Document
22(3)
Using an Access Database
25(2)
Printing an Access Report
26(1)
Quitting Access
26(1)
Sending an E-mail Message from Word
27(6)
Inserting an Access File into an E-mail Message
29(2)
Printing an Outlook Message
31(1)
Quitting Outlook
31(1)
Quitting Word
31(1)
Quitting Excel
32(1)
Project Summary
33(1)
What You Should Know
33(1)
Test Your Knowledge
34(3)
Use Help
37(2)
Apply Your Knowledge
39(2)
In the Lab
41(6)
Cases and Places
47
Index I.1

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program