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.   The Plus Edition will provide students with beginning and intermediate Excel and Access coverage. This text is perfect for instructors who want to cover more advanced Excel and Access topics in the Office 2003 course"

Full Product Details

Author:   Robert T. Grauer ,  Maryann Barber
Publisher:   Pearson Education (US)
Imprint:   Pearson
Dimensions:   Width: 27.40cm , Height: 4.00cm , Length: 27.40cm
Weight:   2.380kg
ISBN:  

9780132370363

ISBN 10:   0132370360
Pages:   1216
Publication Date:   27 April 2005
Audience:   Professional and scholarly ,  Professional & Vocational
Replaced By:   9780132393812
Format:   Paperback
Publisher's Status:   Out of Print
Availability:   Out of stock  

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 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)

Reviews

Author Information

Dr. Robert T. Grauer        Dr. Robert T. Grauer is an Associate Professor in the Department of Computer Information Systems at the University of Mniami where he has been honored with the Outstanding Teacher Award in the School of Business. Dr. Grauer has written more than 20 books on programming and information systems. His work has been translated into three foreign languages and is in use at all levels of higher education at both the national and international level. Dr. Grauer has also been a consultant to several major corporations including IBM and American Express. He received his Ph.D. in Operations Research in 1972 from the Polytechnic Institute of Brooklyn. Maryann M. Barber Maryann M. Barber is a lecturer in the Department of Computer Information Systems at the University of Miami. She has been honored with several teaching awards, including the Excellence in Teaching Awards for the School of Business, the Freshman Teaching Award, the Apple Polishing Award, the Student Government Professor of the Year Award, the Interfraternity Council Professor of the Year Award, and the University of Miami Excellence in Teaching Award. Maryann is also the Faculty Master at Stanford Residential College. She is a member of numerous leadership honor societies at the University of Miami, including Iron Arrow, Mortar Board, and Omicron Delta Kappa.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions