MOS 2010 Study Guide for Microsoft® Word Expert, Excel® Expert, Access®, and SharePoint® Exams by Pierce, John -- Read -- Imperial Library of Trantor

Index

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

A Note Regarding Supplemental Files 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

1. Exam 77-887 Microsoft Word 2010 Expert

1. Sharing and Maintaining Documents

1.1 Configure Word Options

Setting Default Program Options

General Display Proofing Save Language Advanced Customize Ribbon and Quick Access Toolbar Add-Ins Trust Center

Changing Options for Checking Spelling and Grammar

1.2 Apply Protection to a Document

Controlling the Editing of a Document Managing Access to a Document Adding a Password to a Document

1.3 Apply a Template to a Document

Using a Document Template Working with a Global Template Modifying a Template Designing Your Own Template

Adding Content Controls Working with Content Control Properties Changing the Text in a Content Control Protecting a Template You Design

Managing Templates by Using the Organizer

Objective Review

2. Formatting Content

2.1 Apply Advanced Font and Paragraph Attributes

Formatting Characters

Using the Font Tab Applying Text Effects Applying Text Effects from the Home Tab Making Use of the Advanced Tab Adding a Drop Cap

Creating and Modifying Styles Defining and Applying Character Styles

2.2 Create Tables and Charts

Inserting and Formatting a Table Inserting Table Data by Using Microsoft Excel Using Formulas and Calculations in a Table Charting Data in Microsoft Word

2.3 Construct Reusable Content in a Document

Customizing Building Blocks Saving and Inserting Quick Parts Working with Headers and Footers

2.4 Link Text Boxes and Sections

Linking and Unlinking Text Boxes Linking Document Sections

Objective Review

3. Tracking and Referencing Documents

3.1 Review, Compare, and Combine Documents

Adding Comments to a Document Using Track Changes and Setting Track Changes Options Merging Documents Reviewing a Combined Document

3.2 Create a Reference Page

Adding Citations to a Document Managing Sources Creating a Bibliography Using Cross-References in a Document

Creating a Caption Inserting a Cross-Reference

3.3 Create a Table of Authorities in a Document

Marking Citations Formatting and Aligning a Table of Authorities

3.4 Mark and Compile an Index for a Document

Marking Index Entries Setting Index Options Editing and Updating an Index

Objective Review

4. Performing Mail Merge Operations

4.1 Execute a Mail Merge Operation

Building a Recipient List in Word Adding Merge Fields Using Merge Rules Sending a Personal E-Mail Message to a Group of Recipients

4.2 Create a Mail Merge by Using Other Data Sources

Selecting an External Data Source Using the Outlook Contacts List Modifying the Recipient List

4.3 Create Labels and Envelopes

Setting Up Labels or Envelopes for a Mail Merge Preparing and Printing Envelopes and Labels

Objective Review

5. Managing Macros and Forms

5.1 Apply and Manipulate Macros

Using the Macro Recorder Running a Macro Applying Macro Security

5.2 Apply and Manipulate Macro Options

Running a Macro When You Open a Document Running a Macro from a Command Button Adding a Custom Macro Button to the Quick Access Toolbar

5.3 Create Forms

Designing a Form Working with Control Properties

Locking Controls Formatting a Control Building a List

Adding Help to a Form Assigning XML Elements to Form Controls

5.4 Manipulate Forms

Locking and Unlocking a Form Adding and Removing Form Fields

Objective Review

2. Exam 77-888 Microsoft Excel 2010 Expert

1. Sharing and Maintaining Workbooks

1.1 Apply Workbook Settings, Properties, and Data Options

Saving a Workbook as a Template Setting Workbook Properties Exchanging Data with XML

1.2 Apply Protection and Sharing Properties to Workbooks and Worksheets

Protecting Worksheets and Workbooks Restricting User Access Adding a Password to a Workbook

1.3 Maintain Shared Workbooks

Preparing to Share a Workbook Sharing a Workbook and Tracking Changes Reviewing Changes Merging Workbooks

Objective Review

2. Applying Formulas and Functions

2.1 Audit Formulas

Using Auditing Tools to Trace Formulas Identifying Invalid Data and Formulas Correcting Formula Errors

Error Checking Options The Error Checking and Trace Error Commands

Using the Watch Window

2.2 Manipulate Formula Options

Using Automatic Workbook Calculation Setting Options for Iterative Calculations

2.3 Perform Data Summary Tasks

Summing Data with the SUMIF and SUMIFS Functions Understanding and Defining Array Formulas

Working with Array Formulas Defining Array Constants Examples of Array Functions and Formulas

2.4 Apply Functions in Formulas

Using Built-in Functions Correcting Function Errors

Objective Review

3. Presenting Data Visually

3.1 Apply Advanced Chart Features

Adding Trendlines to Data Using a Chart Template Visualizing the Data in a Cell by Using Sparklines

Sparkline Group Type Group Show Group Style Group Group Group

Creating Dual-Axes Charts

3.2 Apply Data Analysis

Performing a What-If Analysis

Using Goal Seek Using Data Tables Building What-If Scenarios Using Solver

Using Automated Analysis Tools

Generating Descriptive Statistics Displaying a Histogram Using Rank And Percentile Generating Random Numbers Sampling Data

3.3 Apply and Manipulate PivotTables

Building a PivotTable Working with Data in a PivotTable

Using Field Headers Managing the Data Changing Your View of the Data Using the Calculations Group Using a Report Filter

Slicing the Data in a PivotTable

3.4 Apply and Manipulate PivotCharts

Creating a PivotChart Changing the View for a PivotChart

3.5 Use External Data Sources

Creating a Data Connection

From Access From Web From Text From Other Sources

Using Existing Connections Editing Links

Objective Review

4. Working with Macros and Forms

4.1 Create and Manipulate Macros

Recording and Storing a Macro Modifying a Macro Run a Macro from the Macro Dialog Box Assigning a Keystroke to a Macro Running a Macro When You Open a Workbook Adding a Macro Button to the Ribbon Adding a Macro Button to the Quick Access Toolbar Creating an Action Macro

4.2 Insert and Manipulate Form Controls

Inserting Form Controls

Inserting a Command Button Setting Up a Combo Box or a List Box Inserting Check Boxes and Option Buttons Using Spin Buttons and Scroll Bars Adding a Label

Defining Form Control Properties Making Use of ActiveX Controls A Simple Order Form Objective Review

3. Exam 77-885 Microsoft Access 2010 Specialist

1. Using the Access Workspace

1.1 Create and Manage a Database

Creating a Database by Using a Template Using the Save Object As Command Using Open Dialog Box Options Working on the Save & Publish Page

Using the Save Database As Option Using the Save Object As Option Publishing a Database to Access Services

Compacting and Repairing a Database Encrypting a Database File Setting Access Options

General Current Database Datasheet Object Designers Proofing Language Client Settings Add-Ins Trust Center

1.2 Configure the Navigation Pane

Renaming Objects Deleting Objects Setting Options for the Navigation Pane

1.3 Use Application Parts

Insert a Blank Form Using Quick Start Elements Applying a User Template

Objective Review

2. Building Tables

2.1 Create Tables in Design View

Getting Started Creating a Lookup Field Setting Table Properties

Creating a Table Validation Rule Inserting a Subdatasheet

Defining Indexes Creating a Data Macro

2.2 Create and Modify Fields

Inserting, Deleting, and Renaming Fields

Working with Fields in Datasheet View Working with Fields in Design View

Hiding and Freezing Fields Setting and Updating Field Properties

Setting Field Properties in Design View Setting Field Properties in Datasheet View

2.3 Sort and Filter Records

Finding Records Sorting Records Filtering Records

2.4 Set Relationships

Specifying a Primary Key Setting Relationships

2.5 Import Data from a Single Data File

Importing Data into a New Table

Importing Data from Excel Importing Data from Another Access Database Importing a Text File

Appending Records Using Linked Tables

Linking to a Table in Another Access Database Linking to an Excel Worksheet or a Text File

Managing Linked Tables

Objective Review

3. Building Forms

3.1 Create Forms

Building a Form with the Form Wizard Creating a Blank Form Creating and Modifying a Form with Form Design Tools Building a Navigation Form

3.2 Apply Form Design Options

Applying Themes to a Form Adding Form Controls

Working with Control Properties Using Control Wizards Adding a Subform

Using a Form Header and Footer Updating Forms from the Tools Group

Setting Form Properties Setting the Tab Order for a Form

3.3 Arrange Fields and Objects on a Form

Sizing and Ordering Controls in Design View Working with Control Layouts in Layout View

3.4 Format Forms

Modifying a Form’s Background Formatting Form Controls Applying Conditional Formatting

Checking Values in the Current Record or Using an Expression Using Data Bars

Objective Review

4. Creating and Managing Queries

4.1 Construct Queries

Selecting Records with a Query

Using the Simple Query Wizard Using the Query Designer

Using a Make-Table Query Appending Records with a Query Updating and Deleting Records with a Query Viewing Data in a Crosstab Query

Using the Crosstab Query Wizard Creating a Crosstab Query in Design View

4.2 Manage Source Tables and Relationships

Adding and Removing Data Sources for a Query Working with Joins and Relationships in a Query

4.3 Manipulate Fields

Changing the Fields in a Query Showing and Hiding Query Fields Specifying the Sort Order for a Query

4.4 Calculate Totals

Grouping Query Records Summarizing Data in a Query

4.5 Generate Calculated Fields

Adding an Expression to a Query Entering an Expression in the Zoom Dialog Box Getting Help with the Expression Builder

Objective Review

5. Designing Reports

5.1 Create Reports

Running the Report Wizard Building a Report in Layout View Using Report Design Tools

5.2 Apply Report Design Tab Options

Applying a Theme to a Report Grouping Report Fields and Calculating Totals Working with Controls on a Report Using a Subreport Adding Information to a Report’s Header and Footer Managing Report Fields and Properties

5.3 Apply Report Arrange Tab Options

Arranging Reports in Design View Working with Report Layouts

5.4 Apply Report Format Tab Options

Adding a Background Image to a Report Formatting Report Controls Highlighting Report Data with Conditional Formatting

5.5 Apply Report Page Setup Tab Options

Specifying the Page Size for a Report Changing the Page Layout for a Report

5.6 Sort and Filter Records for Reporting

Using Report View Types Filtering Records in Report View

Objective Review

4. Exam 77-886 Microsoft SharePoint 2010 Specialist

1. Creating and Formatting Content

1.1 Navigate the SharePoint Hierarchy

Using the Quick Launch Bar Adding Content to the Quick Launch Bar Using All Site Content Using the SharePoint Breadcrumb Trails Feature

1.2 Manage Lists and Document Libraries

Creating Lists and Libraries Editing List and Document Library Properties

Viewing Formats Using the Standard and Datasheet View Creating, Modifying, and Deleting Views Creating Columns

1.3 Manage List Items

Creating Items Editing Item Properties Using the Inline Editing Feature Deleting Items

Delete a Single File or List Item Using the Delete Button Delete a Single File or List Item by Using the Drop-Down Menu Delete Several Files or Items by Using the Delete Button Delete Several Files or List Items by Using Datasheet View Delete Files in a Document Library by Using the Open With Explorer Option

Enabling Version Control Managing Workflows Uploading Documents Creating and Saving Documents

1.4 Work with Document Sets

Defining the Document Set Content Type and Creating a Document Set Adding Documents to a Document Set

About Setting Document Set Versioning

Objective Review

2. Managing SharePoint Sites

2.1 Manage Pages

Creating a SharePoint Page Editing Pages Deleting Pages

2.2 Administer Sites

Creating and Configuring a SharePoint Site Organizing Site Content Using the Content Organizer Viewing User Alerts Modifying Site Appearance

Using a SharePoint Tree View Applying a SharePoint Site Theme

Recovering Data

2.3 Manage Web Parts on a Page

Creating a Web Part Page Adding and Configuring a Web Part Hiding and Removing a Web Part Export and Import a Web Part

2.4 Manage Content Types

Assigning Content Type Management Assigning a Content Type to a Document Library or List Adding a Column to a Content Type

2.5 Manage Users and Groups

Defining User and Group Accounts Setting User and Group Permissions

2.6 Create SharePoint Workspace Sites

Setting Up and Using a Document Workspace Setting Up and Using a Meeting Workspace

2.7 Analyze Site Activity Objective Review

3. Participating in User Communities

3.1 Configure My Site

Setting Up My Site Setting Up RSS Feeds Configuring Profiles

3.2 Collaborate Through My Site

Updating the Profile Status Sharing Pictures and Documents in My Site Managing Personal Documents Browsing the Organization Hierarchy Adding Web Parts to My Site

3.3 Tag and Note Content

Adding Notes on the Note Board for a List or Library Adding Tags for a List or Library Rating an Item Using and Reviewing Tags and Tag Clouds

Objective Review

4. Configuring and Consuming Site Search Results

4.1 Administer Search at the Site Level

Setting Up Columns to Be Searched Searching in a List Configuring Site Search Visibility

4.2 Search SharePoint for Content

Searching SharePoint Content with Windows Searching SharePoint Content from Office 2010

4.3 View Search Results

Browsing Search Results Using Best Bet Results Using the Refinement Panel Using Alerts and RSS Feeds Viewing Document Previews

4.4 Perform Advanced Searches

Setting Up and Running an Advanced Search

4.5 Search for People

Searching for People Using Advanced Search Features for People

Objective Review

5. Integrating SharePoint 2010 Services and Microsoft Office 2010 Applications

5.1 Configure SharePoint 2010 Services

Understanding SharePoint Services

Visio Services Access Services Excel Services

Configuring SharePoint 2010 Services for Excel, Access, and Visio

Publishing a Workbook to Excel Services Adding an Access Database to a SharePoint Site Publishing a Visio Diagram to SharePoint Configuring Form Services

5.2 Run Microsoft Office 2010 Applications with SharePoint 2010 Services

Using Microsoft Outlook with SharePoint

Document Libraries Contact Lists Task Lists

Working with SharePoint Workspace 2010

Understanding Navigation and Layout of a SharePoint 2010 Workspace Go Offline, Go Online, and Synchronize the SharePoint 2010 Workspace with SharePoint

Using Office Web Apps

5.3 Create Dashboards

Creating a Dashboard Page Adding and Configuring Web Parts for Your Dashboard

Objective Review

Index

About the Authors

← Prev
Back
Next →

← Prev
Back
Next →