Exploring Microsoft Office 2003: With Additional Excel and Access Coverage / Edition 1
by Robert T. Grauer
For Introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications.
Master the How and Why of Office 2003! Students master the "How and Why" of performing tasks in Office and gain a greater understanding of how to use the individual applications together to solve
Overview
For Introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications.
Master the How and Why of Office 2003! Students master the "How and Why" of performing tasks in Office and gain a greater understanding of how to use the individual applications together to solve business problems.
Product Details
- ISBN-13:
- 9780132370363
- Publisher:
- Prentice Hall
- Publication date:
- 01/05/2005
- Series:
- Grauer Exploring Office 2003 Series
- Edition description:
- SPIRAL
- Pages:
- 1189
- Product dimensions:
- 9.16(w) x 10.78(h) x 1.50(d)
Table of Contents
(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
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
CommentsExcel 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 FunctionWorking 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
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
Chapter 1: Using
Introduction to
Microsoft Word and
Microsoft Excel and
Microsoft Access and
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)
Customer Reviews
Average Review: