Microsoft Office 2003 : with additional Excel & Access coverage
Intended for introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications. This work helps students learn the "How and Why" of performing tasks in Office, and gain an understanding of how to use the individual applications together to solve business problems.
Print Book, English, c2006
Plus ed
Pearson/Prentice Hall, Upper Saddle River, N.J., c2006
xxiii, 1,189 p. : col. ill. ; 28 cm.
9780132370363, 0132370360
1037367956
(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 XPChapter 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 TroubleshootingIntroduction 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 ScrollingView 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 ResourcesEnhancing 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 TemplatesMail Merge Chapter 4: Advanced Features: Outlines, Tables, Styles and Sections Requirements of a Term Paper Bullets and Lists Creating an Outline TablesStyles 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 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)
Includes index