Frye Curtis, Preppernau Joan, et al. 2007 Microsoft Office System Step by Step

2nd ed. – Microsoft Press, 2008. – 955 p.
Authors: Curtis Frye, Joan Preppernau, Joyce K. Cox, Steve Lambert.The smart way to learn Microsoft Office — one step at a time! The second edition of this popular book features new and expanded content. In addition to covering familiar Microsoft Office applications such as Microsoft Office Access 2007, Excel 2007, Outlook 2007, PowerPoint 2007, and Word 2007 — you now also get coverage of Microsoft Office Publisher 2007, SharePoint Server 2007, Groove 2007, OneNote 2007, and InfoPath 2007. Work at your own pace through the easy numbered steps, practice files on CD, helpful hints, and troubleshooting help to learn the fundamentals of working with the 2007 Microsoft Office system, including how to navigate the new user interface. Learn how to create professional-quality documents, powerful spreadsheets, and compelling slide presentations. And discover how to get your Web site up and running, take notes electronically, and manage your e-mail communications and workday. The companion CD includes skill-building practice files, eBooks, and more. With STEP BY STEP, you can take just the lessons you need or work from cover to cover. Either way, you drive the instruction — building and practicing the skills you need, just when you need them!Introducing the 2007 Microsoft Office System
The Microsoft Office Fluent User Interface.
Certification.
Information for Readers Running Windows XP.
Managing the Practice Files.
Using the Start Menu.
Navigating Dialog Boxes.
Features and Conventions of This Book.
Using the Companion CD.
What’s on the CD?
Minimum System Requirements.
Installing the Practice Files.
Using the Practice Files.
Removing and Uninstalling the Practice Files.
Getting Help.
Getting Help with This Book and Its Companion CD.
Getting Help with an Office Program.
More Information.Quick Reference.Microsoft Office Word 2007
Exploring Word 2007.
Working in the Word Environment.
Opening, Moving Around in, and Closing a Document.
Sidebar: Compatibility with Earlier Versions.
Displaying Different Views of a Document.
Creating and Saving a Document.
Previewing and Printing a Document.
Key Points.Editing and Proofreading Documents
Making Changes to a Document.
Sidebar: What Happened to Overtype?
Sidebar: About the Clipboard.
Inserting Saved Text.
Sidebar: Inserting the Date and Time.
Sidebar: Translating Text.
Finding the Most Appropriate Word.
Sidebar: Researching Information.
Reorganizing a Document Outline.
Finding and Replacing Text.
Correcting Spelling and Grammatical Errors.
Sidebar: Viewing Document Statistics.
Finalizing a Document.
Sidebar: Adding a Digital Signature.
Key Points.Changing the Look of Text
Quickly Formatting Text and Paragraphs.
Manually Changing the Look of Characters.
Sidebar: More About Case and Character Formatting.
Manually Changing the Look of Paragraphs.
Sidebar: Finding and Replacing Formatting.
Creating and Modifying Lists.
Sidebar: Formatting Text as You Type.
Key Points.
Presenting Information in Columns and Tables.
Presenting Information in Columns.
Creating a Tabular List.
Presenting Information in a Table.
Sidebar: Other Layout Options.
Formatting Table Information.
Performing Calculations in a Table.
Sidebar: Creating Table Styles.
Using a Table to Control Page Layout.
Sidebar: Deciding How to Insert Excel Data.
Key Points.Microsoft Office Excel 2007
Setting Up a Workbook.
Creating Workbooks.
Modifying Workbooks.
Modifying Worksheets.
Customizing the Excel 2007 Program Window.
Zooming In on a Worksheet.
Arranging Multiple Workbook Windows.
Adding Buttons to the Quick Access Toolbar.
Key Points.Working with Data and Data Tables
Entering and Revising Data.
Moving Data Within a Workbook.
Finding and Replacing Data.
Correcting and Expanding Upon Worksheet Data.
Definine a Table.
Key Points.Performing Calculations on Data
Naming Groups of Data.
Creating Formulas to Calculate Values.
Summarizing Data That Meets Specific Conditions.
Finding and Correcting Errors in Calculations.
Key Points.
Changing Workbook Appearance.
Formatting Cells.
Defining Styles.
Applying Workbook Themes and Table Styles.
Making Numbers Easier to Read.
Changing the Appearance of Data Based on Its Value.
Adding Images to Documents.
Key Points.Microsoft Office Access 2007
Creating a Database.
Creating a Database from a Template.
Creating a Table Manually.
Creating a Table from a Template.
Manipulating Table Columns and Rows.
Key Points.Simplifying Data Entry by Using Forms
Creating a Form by Using the Form Tool.
Sidebar: Relationships.
Refining Form Properties.
Changing the Arrangement of a Form.
Adding Controls to a Form.
Entering Data in a Form by Using VBA.
Creating a Form by Using an AutoForm.
Sidebar: Simultaneously Creating Forms and Subforms.
Adding a Subform to a Form.
Key Points.Locating Specific Information
Sorting Information in a Table.
Sidebar: How Access Sorts.
Filtering Information in a Table.
Sidebar: Wildcards.
Sidebar: Expressions.
Filtering Information by Using a Form. Locating Information That Matches Multiple Criteria.
Creating a Query Manually.
Sidebar: Filters and Sorts vs. Queries.
Sidebar: Expression Builder.
Creating a Query by Using a Wizard.
Performing Calculations by Using a Query.
Key Points.Keeping Your Information Accurate
Restricting the Type of Data in a Field.
Restricting the Amount of Data in a Field.
Specifying the Format of Data in a Field.
Restricting Data by Using Validation Rules.
Creating a Simple Lookup List.
Creating a Multi-Column Lookup List.
Updating Information in a Table.
Deleting Information from a Table.
Preventing Database Problems.
Key Points.Microsoft Office PowerPoint 2007
Starting a New Presentation.
Quickly Creating a Presentation.
Creating a Presentation Based on a Ready-Made Design.
Converting an Outline to a Presentation.
Sidebar: Exporting a Presentation as an Outline.
Reusing Existing Slides.
Key Points.Working with Slide Text
Entering Text.
Editing Text.
Adding and Manipulating Text Boxes.
Sidebar: Changing the Default Font for Text Boxes.
Correcting and Sizing Text While Typing.
Sidebar: Smart Tags. Checking Spelling and Choosing the Best Words.
Finding and Replacing Text and Fonts.
Changing the Size, Alignment, Spacing, and Look of Text.
Key Points.Adjusting the Layout, Order, and Look of Slides
Changing the Layout of a Slide.
Rearranging Slides in a Presentation.
Applying a Theme.
Switching to a Different Color Scheme.
Sidebar: Changing a Theme’s Fonts and Effects.
Using Colors That Are Not Part of the Scheme.
Adding Shading and Texture to the Background of a Slide.
Sidebar: Adding a Picture to the Slide Background.
Key Points.Delivering a Presentation Electronically
Adapting a Presentation for Different Audiences.
Rehearsing a Presentation.
Sidebar: Creating a Self-Running Presentation.
Preparing Speaker Notes and Handouts.
Preparing a Presentation for Travel.
Showing a Presentation.
Sidebar: Using Two Monitors.
Key Points.Microsoft Office Outlook 2007
Sending E-Mail Messages.
Working in the Message Window.
Sidebar: Outlook Message Formats.
Creating and Sending Messages.
Addressing Messages.
Sending Courtesy Copies.
Saving Message Drafts.
Attaching Files to Messages.
Sidebar: Resending and Recalling Messages.
Sidebar: Sending Contact Information. Creating and Formatting Business Graphics.
Sidebar: Changing Message Settings and Delivery Options.
Personalizing the Appearance of Messages.
Adding Signatures to Messages Automatically.
Key Points.Managing Your Inbox
Quickly Locating Messages.
Arranging Messages in Different Ways.
Sidebar: Using Search Folders.
Organizing Messages by Using Color Categories.
Organizing Messages in Folders.
Sidebar: Creating a OneNote Page from an E-Mail Message.
Archiving Messages.
Key Points.Managing Appointments, Events, and Meetings
Working in the Calendar Item Windows.
Scheduling and Changing Appointments.
Scheduling and Changing Events.
Scheduling, Updating, and Canceling Meetings.
Sidebar: Using the Exchange Server 2007 Smart Scheduling Feature.
Responding to Meeting Requests.
Sidebar: Creating a Meeting Workspace.
Key Points.Managing Your Calendar.
Displaying Different Views of a Calendar.
Sidebar: Adding and Removing Local Holidays.
Defining Your Available Time.
Configuring Outlook for Multiple Time Zones.
Printing a Calendar.
Sidebar: Saving Calendar Information as a Web Page.
Sending Calendar Information in an E-Mail Message.
Sidebar: Creating a OneNote Page Linked to an Appointment, an Event, or a Meeting. Linking to an Internet Calendar.
Working with Multiple Calendars.
Sidebar: Delegating Control of Your Calendar.
Key Points.Microsoft Office Publisher 2007
Creating Colorful Cards and Calendars.
Storing Personal and Company Information.
Creating Folded Cards.
Choosing a Design or Layout.
Changing the Color Scheme.
Sidebar: Color Models.
Using Non-Color-Scheme Colors.
Choosing Text.
Sidebar: The Impact of Color.
Creating Postcards.
Printing Both Sides of Thick Paper.
Sidebar: Online Printing Services.
Using Mail Merge.
Sidebar: Catalog Merge.
Sidebar: Bulk Mail.
Creating Calendars.
Adding Captions, Credits, and Copyrights.
Changing the Background.
Working with the Master Page.
Packaging Publications for Printing.
Sidebar: Binding.
Key Points.Creating Text-Based Publications
Planning Longer Publications.
Sidebar: Non-Standard Sizes.
Creating Newsletters.
Copyfitting Text.
Inserting Pages.
Organizing Content.
Working with a Table of Contents. Contents xi
Creating Sections.
Moving Content.
Sidebar: Graphics Manager.
Solving Organization Problems.
Editing and Proofing Content.
Editing Content in Word.
Correcting Spelling Errors.
Controlling Hyphenation.
Key Points.Microsoft Office OneNote 2007
Collecting Information in a Notebook.
Understanding Notebooks.
Sidebar: Working with Multiple Notebooks.
Understanding Note Containers.
Entering Content Directly onto a Page.
Referencing External Files.
Creating Handwritten Notes.
Sidebar: Inserting Images.
Sidebar: Formatting Notes, Pages, and Sections.
Sending Content to OneNote.
Collecting Screen Clippings.
Collecting Web Notes.
Capturing Audio and Video Notes.
Recording Audio.
Recording Video.
Playing Back a Recording.
Sidebar: Where Is the OneNote Icon?
Quickly Capturing Notes.
Key Points.Organizing and Locating Information
Moving and Removing Information.
Manipulating Objects on a Page.
Moving Pages, Sections, and Notebooks.
Accessing Information from Multiple Locations. Sidebar: Simulating a Table of Contents.
Sidebar: Working with Multiple Instances of a Notebook.
Tagging Notes.
Sidebar: Synchronizing Notes with Outlook Tasks.
Searching for Information.
Key Points.Microsoft Office Groove 2007
Setting Up a Standard Workspace.
Creating a Standard Workspace.
Sending and Accepting Workspace Invitations.
Sidebar: Inviting Someone Who Does Not Have Groove
to Join a Groove Workspace.
Working in the Workspace Members Pane.
Sidebar: Navigating Together.
Changing the Role of a Workspace Member.
Changing Permissions Assigned to a Workspace Role.
Exploring a Groove Workspace.
Sidebar: Viewing General Workspace Properties.
Adding Files to the Files Tool.
Adding a Tool to a Standard Workspace.
Key Points.Managing and Sharing Files
Adding Folders and Files to the Files Tool.
Working with Files in the Files Tool.
Opening, Editing, and Saving a File in the Files Tool.
Specifying Download Settings for a Folder.
Sidebar: Downloading a File Manually.
Setting Permissions in the Files Tool.
Specifying Alert Settings for Folders and Files.
Creating a File Sharing Workspace.
Sidebar: Some Do’s and Don’ts for a File Sharing Workspace.
Creating a File Sharing Workspace in Windows.
Creating a File Sharing Workspace from the Launchbar. Downloading Files in a File Sharing Workspace.
Changing Roles and Permissions for a File Sharing Workspace.
Setting Properties for a File Sharing Workspace.
Key Points.Collaboration
Enabling Collaboration by Using SharePoint.
Sidebar: SharePoint Products and Technologies.
Creating a SharePoint Team Site.
Creating a Document Library.
Managing Files in a Document Library.
Checking Files Into and Out of a Document Library.
Creating a Custom List from an Excel Workbook.
Working with SharePoint List Data in Access.
Sidebar: Customizing Site, Library, and List Views.
Creating a Document Workspace from an Office Document.
Sidebar: Working with a Slide Library.
Creating a Document Workspace from Outlook.
Working Offline with Document Library Contents.
Linking a SharePoint Calendar to Outlook.
Sidebar: Subscribing to a SharePoint Site RSS Feed.
Key Points.