Exploring Microsoft Office
Plus Edition with Additional Excel and Access Coverage
This item is unavailable.
We will email you if this item comes back into stock.
|Format:||Paperback, 1216 pages|
|Other Information: ||illustrations|
|Published In: ||United Kingdom, 06 January 2005|
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
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)
About the Author
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.
|Dimensions: ||27.0 x 23.0 x 4.0 centimeters (2.38 kg)|