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

Taking a Microsoft Office Specialist Exam; Microsoft Office Specialist Certification; Selecting a Certification Path; Test-Taking Tips; Certification Benefits; For More Information; Using This Book to Study for a Certification Exam; Features and Conventions of This Book; Using the Book’s Companion Content; Your Companion eBook; Modifying the Display of the Ribbon; How to Get Support and Provide Feedback; Errata & Book Support; We Want to Hear from You; Stay in Touch; Part 1: Exam 77-887 Microsoft Word 2010 Expert; Chapter 1: Sharing and Maintaining Documents; 1.1 1.1 Configure Word Options; 1.2 1.2 Apply Protection to a Document; 1.3 1.3 Apply a Template to a Document; 1.4 Objective Review; Chapter 2: Formatting Content; 2.1 2.1 Apply Advanced Font and Paragraph Attributes; 2.2 2.2 Create Tables and Charts; 2.3 2.3 Construct Reusable Content in a Document; 2.4 2.4 Link Text Boxes and Sections; 2.5 Objective Review; Chapter 3: Tracking and Referencing Documents; 3.1 3.1 Review, Compare, and Combine Documents; 3.2 3.2 Create a Reference Page; 3.3 3.3 Create a Table of Authorities in a Document; 3.4 3.4 Mark and Compile an Index for a Document; 3.5 Objective Review; Chapter 4: Performing Mail Merge Operations; 4.1 4.1 Execute a Mail Merge Operation; 4.2 4.2 Create a Mail Merge by Using Other Data Sources; 4.3 4.3 Create Labels and Envelopes; 4.4 Objective Review; Chapter 5: Managing Macros and Forms; 5.1 5.1 Apply and Manipulate Macros; 5.2 5.2 Apply and Manipulate Macro Options; 5.3 5.3 Create Forms; 5.4 5.4 Manipulate Forms; 5.5 Objective Review; Part 2: Exam 77-888 Microsoft Excel 2010 Expert; Chapter 1: Sharing and Maintaining Workbooks; 6.1 1.1 Apply Workbook Settings, Properties, and Data Options; 6.2 1.2 Apply Protection and Sharing Properties to Workbooks and Worksheets; 6.3 1.3 Maintain Shared Workbooks; 6.4 Objective Review; Chapter 2: Applying Formulas and Functions; 7.1 2.1 Audit Formulas; 7.2 2.2 Manipulate Formula Options; 7.3 2.3 Perform Data Summary Tasks; 7.4 2.4 Apply Functions in Formulas; 7.5 Objective Review; Chapter 3: Presenting Data Visually; 8.1 3.1 Apply Advanced Chart Features; 8.2 3.2 Apply Data Analysis; 8.3 3.3 Apply and Manipulate PivotTables; 8.4 3.4 Apply and Manipulate PivotCharts; 8.5 3.5 Use External Data Sources; 8.6 Objective Review; Chapter 4: Working with Macros and Forms; 9.1 4.1 Create and Manipulate Macros; 9.2 4.2 Insert and Manipulate Form Controls; Part 3: Exam 77-885 Microsoft Access 2010 Specialist; Chapter 1: Using the Access Workspace; 10.1 1.1 Create and Manage a Database; 10.2 1.2 Configure the Navigation Pane; 10.3 1.3 Use Application Parts; 10.4 Objective Review; Chapter 2: Building Tables; 11.1 2.1 Create Tables in Design View; 11.2 2.2 Create and Modify Fields; 11.3 2.3 Sort and Filter Records; 11.4 2.4 Set Relationships; 11.5 2.5 Import Data from a Single Data File; 11.6 Objective Review; Chapter 3: Building Forms; 12.1 3.1 Create Forms; 12.2 3.2 Apply Form Design Options; 12.3 3.3 Arrange Fields and Objects on a Form; 12.4 3.4 Format Forms; 12.5 Objective Review; Chapter 4: Creating and Managing Queries; 13.1 4.1 Construct Queries; 13.2 4.2 Manage Source Tables and Relationships; 13.3 4.3 Manipulate Fields; 13.4 4.4 Calculate Totals; 13.5 4.5 Generate Calculated Fields; 13.6 Objective Review; Chapter 5: Designing Reports; 14.1 5.1 Create Reports; 14.2 5.2 Apply Report Design Tab Options; 14.3 5.3 Apply Report Arrange Tab Options; 14.4 5.4 Apply Report Format Tab Options; 14.5 5.5 Apply Report Page Setup Tab Options; 14.6 5.6 Sort and Filter Records for Reporting; 14.7 Objective Review; Part 4: Exam 77-886 Microsoft SharePoint 2010 Specialist; Chapter 1: Creating and Formatting Content; 15.1 1.1 Navigate the SharePoint Hierarchy; 15.2 1.2 Manage Lists and Document Libraries; 15.3 1.3 Manage List Items; 15.4 1.4 Work with Document Sets; 15.5 Objective Review; Chapter 2: Managing SharePoint Sites; 16.1 2.1 Manage Pages; 16.2 2.2 Administer Sites; 16.3 2.3 Manage Web Parts on a Page; 16.4 2.4 Manage Content Types; 16.5 2.5 Manage Users and Groups; 16.6 2.6 Create SharePoint Workspace Sites; 16.7 2.7 Analyze Site Activity; 16.8 Objective Review; Chapter 3: Participating in User Communities; 17.1 3.1 Configure My Site; 17.2 3.2 Collaborate Through My Site; 17.3 3.3 Tag and Note Content; 17.4 Objective Review; Chapter 4: Configuring and Consuming Site Search Results; 18.1 4.1 Administer Search at the Site Level; 18.2 4.2 Search SharePoint for Content; 18.3 4.3 View Search Results; 18.4 4.4 Perform Advanced Searches; 18.5 4.5 Search for People; 18.6 OOOOOObjective Review; Chapter 5: Integrating SharePoint 2010 Services and Microsoft Office 2010 Applications; 19.1 5.1 Configure SharePoint 2010 Services; 19.2 5.2 Run Microsoft Office 2010 Applications with SharePoint 2010 Services; 19.3 5.3 Create Dashboards; 19.4 Objective Review;