You are previewing The Microsoft® Office Specialist Study Guide.
O'Reilly logo
The Microsoft® Office Specialist Study Guide

Book Description

Get in-depth, all-in-one prep for the Microsoft® Office Specialist Study Guide exams. Work through the tutorials and practice questions—demonstrating your expertise in Microsoft Word 2007, Excel® 2007, Outlook® 2007, PowerPoint® 2007, and Access® 2007.

Table of Contents

  1. The Microsoft® Office Specialist Study Guide
  2. A Note Regarding Supplemental Files
  3. Your All-in-One Resource
  4. Taking a Microsoft Certified Application Specialist Exam
    1. The Microsoft Business Certification Program
    2. Selecting a Certification Path
    3. Test-Taking Tips
    4. Certification Benefits
    5. For More Information
  5. Using This Book to Study for a Certification Exam
    1. Features and Conventions of This Book
    2. Additional Resources
  6. Working in the Microsoft Office Fluent User Interface
  7. Using the Companion CD
    1. CD Contents
      1. Exam 77-601: Using Microsoft Office Word 2007
      2. Exam 77-602: Using Microsoft Office Excel 2007
      3. Exam 77-603: Using Microsoft Office PowerPoint 2007
      4. Exam 77-604: Using Microsoft Office Outlook 2007
      5. Exam 77-605: Using Microsoft Office Access 2007
    2. Minimum System Requirements
    3. Installing the Practice Files
    4. Using the Practice Files
    5. Removing and Uninstalling the Practice Files
  8. Getting Help
    1. Getting Help with This Book and Its Companion CD
    2. Getting Help with an Office Program
    3. More Information
  9. 1. Exam 77-601 Using Microsoft Office Word 2007
    1. 1. Creating and Customizing Documents
      1. 1.1 Create and format documents
        1. Templates
        2. Borders and Backgrounds
        3. Themes
      2. 1.2 Lay out documents
        1. Page Settings
        2. Headers and Footers
        3. Columns
      3. 1.3 Make documents and content easier to find
        1. Properties
        2. Tables of Contents
        3. Indexes
        4. Bookmarks
        5. Cross-References
        6. Hyperlinks
      4. 1.4 Personalize Word 2007
        1. Common Settings
        2. More Specialized Settings
        3. Research Settings
      5. Objective Review
    2. 2. Formatting Content
      1. 2.1 Format text and paragraphs
        1. Character Formatting
        2. Paragraph Formatting
        3. Styles
        4. Quick Styles
        5. Style Sets
        6. Line Breaks and Hyphenation
        7. Tab Stops
        8. Copying, Finding, and Clearing
      2. 2.2 Manipulate text
        1. Copying and Moving
        2. Paste Special
        3. Finding and Replacing
      3. 2.3 Control pagination
        1. Page Breaks
        2. Sections
      4. Objective Review
    3. 3. Working with Visual Content
      1. 3.1 Insert illustrations
        1. Pictures
        2. Shapes
        3. SmartArt Diagrams
        4. Charts
        5. Sizing and Positioning
      2. 3.2 Format illustrations
        1. Text Wrapping
        2. Cropping
        3. Rotating
        4. Stacking Order
        5. Grouping
        6. Aligning and Distributing
        7. Styles
        8. Color
      3. 3.3 Format text graphically
        1. WordArt
        2. Drop Caps
      4. 3.4 Insert and modify text boxes
      5. Objective Review
    4. 4. Organizing Content
      1. 4.1 Structure content by using Quick Parts
        1. Building Blocks Organizer
        2. Custom Quick Parts
        3. Fields
      2. 4.2 Use tables and lists to organize content
        1. Tables
        2. Tabular Lists
        3. Bulleted and Numbered Lists
      3. 4.3 Modify tables
        1. Table Structure
        2. Table Formatting
        3. Text Alignment
        4. Calculations
      4. 4.4 Insert and format references and captions
        1. Bibliographies
        2. Reference Tables
        3. Footnotes and Endnotes
      5. 4.5 Merge documents and data sources
        1. Documents
        2. Labels
        3. Envelopes
      6. Objective Review
    5. 5. Reviewing Documents
      1. 5.1 Navigate documents
        1. Navigation Tricks
        2. Multiple Views
      2. 5.2 Compare and merge document versions
      3. 5.3 Manage tracked changes
        1. Tracking
        2. Reviewing
      4. 5.4 Insert, modify, and delete comments
      5. Objective Review
    6. 6. Sharing and Securing Content
      1. 6.1 Prepare documents for sharing
        1. File Formats
        2. Compatibility Checker
        3. Document Inspector
      2. 6.2 Control document access
        1. Editing and Formatting Restrictions
        2. Passwords
        3. Rights Management
        4. Finalizing
      3. 6.3 Attach digital signatures
      4. Objective Review
  10. 2. Exam 77-602 Using Microsoft Office Excel 2007
    1. 1. Creating and Manipulating Data
      1. 1.1 Insert data by using Auto Fill
        1. Filling Series
        2. Copying Data
      2. 1.2 Ensure data integrity
        1. Data Entry Restrictions
        2. Input and Error Messages
        3. Duplicate Rows
      3. 1.3 Modify cell contents and formats
      4. 1.4 Change worksheet views
        1. Views
        2. Zoom Level
        3. Program Window Area
        4. Freezing and Splitting
        5. Multiple Windows
      5. 1.5 Manage worksheets
        1. Hiding and Displaying
        2. Moving and Copying
      6. Objective Review
    2. 2. Formatting Data and Content
      1. 2.1 Format worksheets
        1. Themes
        2. Gridlines and Headings
        3. Worksheet Tabs
        4. Worksheet Background
      2. 2.2 Insert and modify rows and columns
        1. Inserting and Deleting
        2. Formatting
        3. Hiding
        4. Height and Width
      3. 2.3 Format cells and cell content
        1. Built-In Number Formats
        2. Custom Formats
        3. Hyperlinks
        4. Merged Cells
        5. Formatting
        6. Cell Styles
      4. 2.4 Format data as a table
        1. Tables
        2. Table Styles
        3. Total Row
      5. Objective Review
    3. 3. Creating and Modifying Formulas
      1. 3.1 Reference data in formulas
        1. Cell References
        2. Cell Ranges
        3. Worksheet References
        4. Workbook References
        5. Named Ranges
      2. 3.2 Summarize data by using a formula
      3. 3.3 Summarize data by using subtotals
      4. 3.4 Conditionally summarize data by using a formula
      5. 3.5 Look up data by using a formula
      6. 3.6 Use conditional logic in a formula
      7. 3.7 Format or modify text by using formulas
      8. 3.8 Display and print formulas
      9. Objective Review
    4. 4. Presenting Data Visually
      1. 4.1 Create and format charts
        1. Plotting Charts
        2. Layouts and Styles
      2. 4.2 Modify charts
        1. Moving and Sizing
        2. Editing Data
        3. Chart Elements
      3. 4.3 Apply conditional formatting
      4. 4.4 Insert and modify illustrations
        1. Pictures
        2. SmartArt Diagrams
        3. Shapes
      5. 4.5 Outline data
      6. 4.6 Sort and filter data
        1. Sorting
        2. Filtering
      7. Objective Review
    5. 5. Collaborating and Securing Data
      1. 5.1 Manage changes to workbooks
        1. Change Tracking
        2. Comments
      2. 5.2 Protect and share workbooks
        1. Passwords
        2. Workbook Protection
        3. Worksheet Protection
        4. Workbook Sharing
      3. 5.3 Prepare workbooks for distribution
        1. Properties
        2. Document Inspector
        3. Permissions
        4. Digital Signatures
        5. Finalizing
      4. 5.4 Save workbooks
        1. File Formats
        2. Compatibility Checker
      5. 5.5 Set print options for printing data, worksheets, and workbooks
        1. Print Area
        2. Page Breaks
        3. Worksheet Layout
        4. Headers and Footers
      6. Objective Review
  11. 3. Exam 77-603 Using Microsoft Office PowerPoint 2007
    1. 1. Creating and Formatting Presentations
      1. 1.1 Create new presentations
        1. Blank Presentations
        2. Templates
        3. Outlines
      2. 1.2 Customize slide masters
        1. Slide Masters
        2. Themes
        3. Background
      3. 1.3 Add elements to slide masters
        1. Layouts
        2. Content Placeholders
        3. Custom Elements
      4. 1.4 Create and change presentation elements
        1. Slide Orientation and Size
        2. Transitions
      5. 1.5 Arrange slides
        1. Adding and Deleting
        2. Slide Order
      6. Objective Review
    2. 2. Creating and Formatting Slide Content
      1. 2.1 Insert and format text boxes
        1. Text Boxes
        2. Size and Position
        3. Shape Formatting
        4. Text Layout
      2. 2.2 Manipulate text
        1. Basic Editing
        2. Bulleted and Numbered Lists
        3. Basic Formatting
        4. WordArt
      3. 2.3 Add and link existing content to presentations
        1. Ready-Made Slides
        2. Sounds
        3. Movies
        4. Other Types of Files
        5. Links
      4. 2.4 Apply, customize, modify, and remove animations
        1. Built-In Animations
        2. Custom Animations
      5. Objective Review
    3. 3. Working with Visual Content
      1. 3.1 Create SmartArt diagrams
        1. Independent Diagrams
        2. Diagrams from Bulleted Lists
      2. 3.2 Modify SmartArt diagrams
        1. Design Changes
        2. Shape Changes
      3. 3.3 Insert illustrations and shapes
        1. Pictures
        2. Clip Art
        3. Shapes
      4. 3.4 Modify illustrations
        1. Picture and Clip Art Formatting
        2. Shape Formatting
      5. 3.5 Arrange illustrations and other content
        1. Size and Position
        2. Stacking Order
        3. Grouping
        4. Alignment
      6. 3.6 Insert and modify charts
        1. Basic Charts
        2. Chart Elements
        3. Chart Formatting
      7. 3.7 Insert and modify tables
        1. Basic Tables
        2. Table Editing and Formatting
      8. Objective Review
    4. 4. Collaborating On and Delivering Presentations
      1. 4.1 Review presentations
        1. Comments
        2. Comment Review
        3. Comment Management
      2. 4.2 Protect presentations
        1. Digital Signatures
        2. Passwords
      3. 4.3 Secure and share presentations
        1. Document Inspector
        2. Permissions
        3. Compression
        4. Finalizing
        5. File Formats
      4. 4.4 Prepare printed materials
        1. Handouts and Notes
        2. Printing
      5. 4.5 Prepare for and rehearse presentation delivery
        1. Slide Subsets
        2. Rehearsals
        3. Delivery Preparation
      6. Objective Review
  12. 4. Exam 77-604 Using Microsoft Office Outlook 2007
    1. 1. Managing Messages
      1. 1.1 Create and send an e-mail message
        1. Sending
        2. Replying and Forwarding
        3. Recalling
      2. 1.2 Create and manage your signature and automated messages
        1. Signatures
        2. Automated Messages
      3. 1.3 Manage e-mail message attachments
        1. Attachments
        2. Opening and Previewing
        3. Saving
      4. 1.4 Configure e-mail message sensitivity and importance settings
        1. Sensitivity
        2. Importance
      5. 1.5 Configure e-mail message security settings
        1. Permissions
        2. Digital Signatures
        3. Encryption
      6. 1.6 Configure e-mail message delivery options
        1. Flags
        2. Scheduled Deliveries and Expirations
        3. Receipts
        4. Reply Rerouting
        5. E-Mail Polls
      7. 1.7 View e-mail messages
        1. Reading Pane
        2. Message Preview
        3. Header Fields
      8. Objective Review
    2. 2. Managing Scheduling
      1. 2.1 Create appointments, meetings, and events
        1. Appointments
        2. Events
        3. Recurring Appointments and Events
        4. Private Appointments and Events
      2. 2.2 Send meeting requests
        1. Meeting Requests
        2. Scheduling
        3. Response Tracking
      3. 2.3 Update, cancel, and respond to meeting requests
        1. Rescheduling and Canceling
        2. Additional Attendees
        3. Responding
      4. 2.4 Customize calendar settings
        1. Work Week
        2. Time Zones
        3. Holidays
      5. 2.5 Share your calendar with other people
        1. Free/Busy Information
        2. Sharing
        3. E-Mailing
        4. Delegating
        5. Publishing
      6. 2.6 View other calendars
        1. Multiple Calendars
        2. Other People’s Calendars
        3. Internet Calendars
      7. Objective Review
    3. 3. Managing Tasks
      1. 3.1 Create and modify tasks, and mark tasks as complete
        1. Tasks
        2. Task Management
      2. 3.2 Accept, decline, assign, update, and respond to tasks
        1. Task Assignments
        2. Assignment Responses
      3. Objective Review
    4. 4. Managing Contacts and Personal Contact Information
      1. 4.1 Create and modify contacts
        1. Contact Address Lists
        2. Contact Records
      2. 4.2 Edit and use an electronic business card
      3. 4.3 Create and modify distribution lists
      4. 4.4 Create a secondary address book
      5. Objective Review
    5. 5. Organizing Information
      1. 5.1 Categorize Outlook 2007 items by color
        1. Color Categories
        2. Custom Categories
        3. Automatic Color Display
        4. Sorting
      2. 5.2 Create and manage Outlook 2007 data files
      3. 5.3 Organize mail folders
        1. Folder Structure
        2. Archiving
        3. Sent Messages
        4. Deleted Items
        5. Junk Mail
      4. 5.4 Locate Outlook 2007 items by using the search feature
        1. Instant Search
        2. Query Builder
        3. Search Folders
      5. 5.5 Create, modify, and remove rules to manage e-mail messages
      6. 5.6 Customize your Outlook 2007 experience
        1. To-Do Bar
        2. Default Message Format
        3. Default Message Look
        4. Outlook Anywhere
      7. Objective Review
  13. 5. Exam 77-605 Using Microsoft Office Access 2007
    1. 1. Structuring a Database
      1. 1.1 Define data needs and types
        1. Normal Forms
        2. Data Types
        3. Table Analyzer
      2. 1.2 Define and print table relationships
        1. Relationships
        2. Referential Integrity
        3. Join Types
        4. Relationship Report
      3. 1.3 Add, set, change, or remove primary keys
      4. 1.4 Split databases
      5. Objective Review
    2. 2. Creating and Formatting Database Elements
      1. 2.1 Create databases
      2. 2.2 Create tables
      3. 2.3 Modify tables
      4. 2.4 Create fields and modify field properties
        1. New Fields
        2. Properties
        3. Input Masks
        4. Validation Rules
        5. Lookup Lists and Multivalued Fields
      5. 2.5 Create forms
        1. Form Tools
        2. Form Wizard
        3. Manual Forms
        4. PivotCharts and PivotTables
      6. 2.6 Create reports
        1. Report Tool
        2. Report Wizard
        3. Manual Reports
        4. Printing
        5. Label Wizard
      7. 2.7 Modify the design of reports and forms
        1. Controls
        2. Layout
        3. Formatting
        4. AutoFormats
      8. Objective Review
    3. 3. Entering and Modifying Data
      1. 3.1 Enter, edit, and delete records
        1. Entering and Editing
        2. Deleting
      2. 3.2 Navigate among records
      3. 3.3 Find and replace data
        1. Finding
        2. Wildcards
        3. Replacing
      4. 3.4 Attach documents to and detach from records
      5. 3.5 Import data
        1. Importing
        2. Linking
        3. Import Specifications
      6. Objective Review
    4. 4. Creating and Modifying Queries
      1. 4.1 Create queries
        1. Select Queries
        2. Criteria
        3. Action Queries
        4. Subqueries
      2. 4.2 Modify queries
        1. Table Changes
        2. Parameters
        3. Joins
        4. Calculations
      3. Objective Review
    5. 5. Presenting and Sharing Data
      1. 5.1 Sort data
        1. Text vs. Numbers
        2. Tables and Forms
        3. Queries
      2. 5.2 Filter data
        1. Simple Filters
        2. Common Filters
        3. Filter by Selection
        4. Filter by Form
      3. 5.3 Create and modify charts
      4. 5.4 Export data
      5. 5.5 Save database objects as other file types
        1. Earlier Access Formats
        2. XPS Format
        3. Database Objects
      6. 5.6 Print database objects
      7. Objective Review
    6. 6. Managing and Maintaining Databases
      1. 6.1 Perform routine database operations
        1. Exclusive Use
        2. Backing Up
        3. Problem Prevention
        4. Link Repair
      2. 6.2 Manage databases
        1. Passwords and Encryption
        2. Database Options
        3. Database Information
      3. Objective Review
    7. A. About the Authors
      1. Joyce Cox
      2. Joan Preppernau
      3. The Team
      4. Online Training Solutions, Inc. (OTSI)
  14. Index
  15. About the Authors
  16. Copyright