MOS 2010 Study Guide for Microsoft® Word Expert, Excel® Expert, Access®, and SharePoint®

MOS 2010 Study Guide for Microsoft® Word Expert, Excel® Expert, Access®, and SharePoint®

Get the Book: http://shop.oreilly.com/product/0790145320490.do

Demonstrate your expertise with Microsoft Office! Designed to help you practice and prepare for four Microsoft Office Specialist (MOS)
exams, this all-in-one study guide features:

  • Full, objective-by-objective exam coverage
  • Easy-to-follow procedures and illustrations to review essential skills
  • Hands-on practice tasks to apply what you’ve learned; files included

Use the in-depth exam prep, practice, and review to help advance your proficiency with Microsoft Office—and earn the credential that proves
it!

Exams covered:

  • 77-887: MOS: Microsoft Office Word 2010 Expert
  • 77-888: MOS: Microsoft Office Excel 2010 Expert
  • 77-885: MOS: Microsoft Office Access 2010
  • 77-886: MOS: Microsoft SharePoint 2010

Companion Content includes:

  • Practice files for each exam
  • Fully searchable eBook
  • Sample chapters from five STEP BY STEP books from Microsoft Press
  • Additional eBooks and resources

Special Offer: Exam discount

  • Get 25% off your MOS exam fee from Certiport
  • See details on the Certiport offer page inside

 

Table of Contents

  1. Exam 77-887 Microsoft Word 2010 Expert

    1. Chapter 1 Sharing and Maintaining Documents

      1. 1.1 Configure Word Options
      2. 1.2 Apply Protection to a Document
      3. 1.3 Apply a Template to a Document
      4. Objective Review

    2. Chapter 2 Formatting Content

      1. 2.1 Apply Advanced Font and Paragraph Attributes
      2. 2.2 Create Tables and Charts
      3. 2.3 Construct Reusable Content in a Document
      4. 2.4 Link Text Boxes and Sections
      5. Objective Review

    3. Chapter 3 Tracking and Referencing Documents

      1. 3.1 Review, Compare, and Combine Documents
      2. 3.2 Create a Reference Page
      3. 3.3 Create a Table of Authorities in a Document
      4. 3.4 Mark and Compile an Index for a Document
      5. Objective Review

    4. Chapter 4 Performing Mail Merge Operations

      1. 4.1 Execute a Mail Merge Operation
      2. 4.2 Create a Mail Merge by Using Other Data Sources
      3. 4.3 Create Labels and Envelopes
      4. Objective Review

    5. Chapter 5 Managing Macros and Forms

      1. 5.1 Apply and Manipulate Macros
      2. 5.2 Apply and Manipulate Macro Options
      3. 5.3 Create Forms
      4. 5.4 Manipulate Forms
      5. Objective Review

  2. Exam 77-888 Microsoft Excel 2010 Expert

    1. Chapter 1 Sharing and Maintaining Workbooks

      1. 1.1 Apply Workbook Settings, Properties, and Data Options
      2. 1.2 Apply Protection and Sharing Properties to Workbooks and Worksheets
      3. 1.3 Maintain Shared Workbooks
      4. Objective Review

    2. Chapter 2 Applying Formulas and Functions

      1. 2.1 Audit Formulas
      2. 2.2 Manipulate Formula Options
      3. 2.3 Perform Data Summary Tasks
      4. 2.4 Apply Functions in Formulas
      5. Objective Review

    3. Chapter 3 Presenting Data Visually

      1. 3.1 Apply Advanced Chart Features
      2. 3.2 Apply Data Analysis
      3. 3.3 Apply and Manipulate PivotTables
      4. 3.4 Apply and Manipulate PivotCharts
      5. 3.5 Use External Data Sources
      6. Objective Review

    4. Chapter 4 Working with Macros and Forms

      1. 4.1 Create and Manipulate Macros
      2. 4.2 Insert and Manipulate Form Controls

  3. Exam 77-885 Microsoft Access 2010 Specialist

    1. Chapter 1 Using the Access Workspace

      1. 1.1 Create and Manage a Database
      2. 1.2 Configure the Navigation Pane
      3. 1.3 Use Application Parts
      4. Objective Review

    2. Chapter 2 Building Tables

      1. 2.1 Create Tables in Design View
      2. 2.2 Create and Modify Fields
      3. 2.3 Sort and Filter Records
      4. 2.4 Set Relationships
      5. 2.5 Import Data from a Single Data File
      6. Objective Review

    3. Chapter 3 Building Forms

      1. 3.1 Create Forms
      2. 3.2 Apply Form Design Options
      3. 3.3 Arrange Fields and Objects on a Form
      4. 3.4 Format Forms
      5. Objective Review

    4. Chapter 4 Creating and Managing Queries

      1. 4.1 Construct Queries
      2. 4.2 Manage Source Tables and Relationships
      3. 4.3 Manipulate Fields
      4. 4.4 Calculate Totals
      5. 4.5 Generate Calculated Fields
      6. Objective Review

    5. Chapter 5 Designing Reports

      1. 5.1 Create Reports
      2. 5.2 Apply Report Design Tab Options
      3. 5.3 Apply Report Arrange Tab Options
      4. 5.4 Apply Report Format Tab Options
      5. 5.5 Apply Report Page Setup Tab Options
      6. 5.6 Sort and Filter Records for Reporting
      7. Objective Review

  4. Exam 77-886 Microsoft SharePoint 2010 Specialist

    1. Chapter 1 Creating and Formatting Content

      1. 1.1 Navigate the SharePoint Hierarchy
      2. 1.2 Manage Lists and Document Libraries
      3. 1.3 Manage List Items
      4. 1.4 Work with Document Sets
      5. Objective Review

    2. Chapter 2 Managing SharePoint Sites

      1. 2.1 Manage Pages
      2. 2.2 Administer Sites
      3. 2.3 Manage Web Parts on a Page
      4. 2.4 Manage Content Types
      5. 2.5 Manage Users and Groups
      6. 2.6 Create SharePoint Workspace Sites
      7. 2.7 Analyze Site Activity
      8. Objective Review

    3. Chapter 3 Participating in User Communities

      1. 3.1 Configure My Site
      2. 3.2 Collaborate Through My Site
      3. 3.3 Tag and Note Content
      4. Objective Review

    4. Chapter 4 Configuring and Consuming Site Search Results

      1. 4.1 Administer Search at the Site Level
      2. 4.2 Search SharePoint for Content
      3. 4.3 View Search Results
      4. 4.4 Perform Advanced Searches
      5. 4.5 Search for People
      6. Objective Review

    5. Chapter 5 Integrating SharePoint 2010 Services and Microsoft Office 2010 Applications

      1. 5.1 Configure SharePoint 2010 Services
      2. 5.2 Run Microsoft Office 2010 Applications with SharePoint 2010 Services
      3. 5.3 Create Dashboards
      4. Objective Review