(NOTE: The Plus Edition extends the coverage of Access and Excel to six and seven chapters, respectively (as opposed to four chapters each in Volume I). It also maintains the same level of coverage for PowerPoint and Word as in Volume I so that both applications are Microsoft Office Specialist certified. The Plus Edition includes a new module on XML.)
WINDOWS XP
Chapter 1: Getting Started with Microsoft Windows XP
Welcome to Windows XP
The Desktop
Moving and Sizing a Window
Anatomy of a Window
Pull-Down Menus
Dialog Boxes
Help and Support Center
Files and Folders
The Exploring Office Practice Files
Connecting to the Internet
Windows Explorer
Personal Folders
Moving and Copying a File
Deleting a File
Backup
Increasing Productivity
The Control Panel
Shortcuts
The Search Companion
Fun with Windows XP
Windows Media Player
Digital Photography
Windows Messenger
MICROSOFT OFFICE WORD 2003
Chapter 1:Microsoft Word: What Will Word Processing Do for Me?
The Basics of Word Processing
The Insertion Point
Word Wrap
Toggle Switches
Insert versus Overtype
Deleting Text
Introduction to Microsoft Word
The File Menu
Learning by Doing
Troubleshooting
Introduction to Formatting
The Spell Check
AutoCorrect and AutoText
Thesaurus
Grammar Check
Save As Command
Backup Options
Chapter 2: Gaining Proficiency: Editing and Formatting
Undo and Redo Commands Moving and Copying Text
Find, Replace, and GO TO Commands
Scrolling
View Menu
Typography Type Size
Format Font Command
Page Setup Command Page Breaks
An Exercise in Design
Paragraph Formatting
Alignment
Indents
Tabs
Hyphenation
Line Spacing
Format Paragraph Command Borders and Shading
Column Formatting
Chapter 3: Enhancing a Document: The Web and Other Resources
Enhancing a Document
The Microsoft Clip Organizer
The Insert Symbol Command
Microsoft Word Art
The Drawing Toolbar
Microsoft Word and the Internet
Copyright Protection
Wizards and Templates
Mail Merge
Chapter 4: Advanced Features: Outlines, Tables, Styles and Sections Requirements of a Term Paper
Bullets and Lists
Creating an Outline
Tables
Styles
The Outline View The AutoFormat Command
Working in Long Documents
Page Numbers
Headers and Footers
Sections
Table of Contents
Creating an Index
The Go To Command
MICROSOFT OFFICE EXCEL 2003
Chapter 1: Introduction to Excel: What is a Spreadsheet?
Introduction to Spreadsheets
The Accountant's Ledger
The Professor's Grade Book
Row and Column Headings
Formulas and Constants
Introduction to Microsoft Excel Toolbars
The File Menu
Modifying a Worksheet
The Page Setup Command
A Better Grade Book
Cell Ranges
Copy Command
Move Operation
Learning by Doing
Formatting
Format Cells Command Alignment
Fonts
Borders, Patterns, and Shading
Chapter 2: Getting Proficiency: The Web and Business Applications
Employee Payroll
Pointing
The Fill Handle
Comments
Excel and the Internet
Web Queries
Chapter 3: Graphs and Charts: Delivering a Message
Charts Types
Pie Charts
Column and Bar Charts
Creating a Bar Chart The Chart Wizard
Modifying a Chart
Multiple Data Series Stacked Column Charts
Object Linking and Embedding
Chapter 4: Using Spreadsheets in Decision Making: What If?
Spreadsheets in Decision Making Analysis of a Car Loan
PMT Function
FV Function
Inserting a Function
The Goal Seek Command
Home Mortgages Relative versus Absolute Addresses
Mixed Reference
The Grade Book Revisited Statistical Functions
Arithmetic Expressions versus Functions
IF Functions
VLOOKUP Function
Working with Large Spreadsheets Freezing Panes
Hiding Rows and Columns
Printing a Large Worksheet
AutoFilter Command
Chapter 5: Consolidating Data: Worksheet References and File Linking
Consolidating Data
The Three-Dimensional Workbook
Copying Worksheets
Multiple Worksheets
Worksheet References 3-D Reference
Grouping Worksheets
The AutoFormat Command
The Documentation Worksheet
Linking Workbooks 3-D Reference
Grouping Worksheets
The AutoFormat Command
Chapter 6: A Financial Forecast: Auditing, Protection, and Templates
A Financial Forecast
Advanced Formatting
Scenario Manager
Workgroups and Auditing Data Validation
Templates
Chapter 7: List and Data Management: Converting Data to Information
Lists and Data Management
Implementation in Excel
Data Form Command
Sort Command
The Text Import Wizard Excel and XML
Data versus Information AutoFilter Command
Advanced Filter Command
Criteria Range
Database Functions
Insert Name Command
Subtotals
Pivot Tables and Pivot Charts
MICROSOFT OFFICE ACCESS 2003
Chapter 1: Introduction to Access: What Is a Database?
The College Bookstore
Introduction to Microsoft Access
The Database Window
Tables
Forms, Queries, and Reports
Filters and Sorting
Looking Ahead: A Relational Database
Chapter 2: Tables and Forms: Design, Properties, Views, and Wizards
A Student Database Include the Necessary Data
Store Data in Its Smallest Parts
Avoid Calculated Fields
Creating a Table Primary Key
Views
Properties
Forms Properties
AutoForms and the Form Wizard
Modifying a Form
A More Sophisticated Form
Chapter 3: Information from the Database: Reports and Queries
Data versus Information
Reports
Anatomy of a Report
The Report of a Wizard
Apply What You Know
Bound, Unbound, and Calculated Controls
Introduction to Queries Query Design View
Selection Criteria
Access Functions and Calculated Controls
Grouping Records
Crosstab Queries
Action Queries
Chapter 4: Proficiency: Relational Databases, Pivot Charts, and the Switchboard
The Investment Database
Multiple-Table Queries
Maintaining the Database
The Import Spreadsheet Wizard
Total Queries
Microsoft Graph
Pivot Tables and Pivot Charts
The User Interface
The Switchboard Manager
Other Access Utilities
Chapter 5: One-to-Many Relationship: Subforms and Multiple-table Queries
A Database for Consumer Loans
The AutoNumber Field Type
Referential Integrity
Implementation in Access
Subforms The Form Wizard
Multiple Table Queries
Expanding the Database Multiple Subforms
Chapter 6: Many-to-many Relationships: A More Complex System
The Computer Store
The AutoNumber Field Type
The Relationship Window
Subforms, Queries, and AutoLookup
Parameter Queries
Total Queries
Learning by Doing Expanding the Database
The Sales Commission Query
MICROSOFT OFFICE POWERPOINT 2003
Chapter 1: Introduction to PowerPoint: Presentations Made Easy
Introduction to PowerPoint
The Common User Interface
PowerPoint Views
The File Menu
Creating a Presentation Slide Layouts
Templates
The Slide Show Delivering the Presentation
Enhancing a Presentation The Microsoft Clip Organizer
Office Art
Microsoft WordArt
Chapter 2: Gaining Proficiency: Slide Show Tools and Digital Photography
Slide Show Tools
Reviewing a Presentation
PowerPoint and the Internet Copyright Protection
Fun with Photographs Photographs, File Formats, and File Folders
Transitions and Animations
The Auto-Content Wizard
GETTING STARTED WITH XML
Chapter 1: Using XML with Microsoft Office 2003
Introduction to XML
Microsoft Word and XML
Microsoft Excel and XML
Microsoft Access and XML
INTEGRATED CASE STUDIES
The Totally Fit Wellness Center
Totally Fit Revenue Workbook and Chart
(Excel)
Report to the President (Word and Excel)
Presentation to the President (PowerPoint and Excel)
Last-minute Change (Word, Excel, and PowerPoint)
Importing Data (Access and Excel)
Access Objects: Forms, Queries, and Reports (Access)
An Access Switchboard (Access)
Mail Merge (Word and Access)
Worksheet References (Excel)
Presentation to the Board (PowerPoint and Excel)
Letter to the Board (Word and Excel)
Create a Home Page (Word)
Submission Checklist (Word)
Alternate Airways Objectives Alternate Revenue Workbook and Chart
(Excel)
Report to the President (Word and Excel)
Presentation to the President (PowerPoint and Excel)
Last-minute Change (Word, Excel, and PowerPoint)
Importing Data (Access and Excel)
A Relational Database (Access)
Access Objects: Forms, Queries, and Reports (Access)
An Access Switchboard (Access)
Mail Merge (Word and Access)
Worksheet References (Excel)
Presentation to the Board (PowerPoint and Excel)
Letter to the Board (Word and Excel)
Create a Home Page (Word)
Submission Checklist (Word)
University Housing Objectives University Housing Workbook and Chart
(Excel)
Report to the Provost (Word and Excel)
Presentation to the Provost (PowerPoint and Excel)
Last-minute Change (Word, Excel, and PowerPoint)
Importing Data (Access and Excel)
A Relational Database (Access)
Access Objects: Forms, Queries, and Reports (Access)
An Access Switchboard (Access)
Mail Merge (Word and Access)
Worksheet References (Excel)
Presentation to Trustees (PowerPoint and Excel)
Letter to Trustees (Word and Excel)
Create a Home Page (Word)
Submission Checklist (Word)
