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

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




The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update



Version Location Description Submitted By Date Submitted Date Corrected
Printed
Page vi
First paragraph

There are a number error review. The number of the Excel 2010 expert review is 77-888, not 77-887(exam Word 2010 Expert)

Note from the Author or Editor:
I don't have access to this page, but the errata is correct. If the Excel exam on page vi is listed as 77-887, it should be changed to 77-888.

Anonymous  Aug 12, 2011  Oct 14, 2011
Printed
Page 13
1st paragraph, 1st line

"... to a workbook, ..."; probably should be "... to a document, ..."

Note from the Author or Editor:
On page 13, under the heading 1.2 Apply Protection to a Document, the reference to "workbook" should be "document." The text should read as follows: "To apply permissions and protection to a document, ..."

Anonymous  Oct 21, 2011  Aug 02, 2013
Printed, PDF
Page 23
Line 10 (step 4)

Change "4...Modify Styles..." to "4...Modify Style"

Note from the Author or Editor:
In the procedure To change a template while working on a document, in steps 2 and 4, Modify Styles dialog box should be Modify Style dialog box.

Paul Hamel  Feb 18, 2013  Aug 02, 2013
Printed, PDF
Page 25
Para following Tip

Change "Here's a quick rundown on some of the control controls you might use." to "Here's a quick rundown on some of the content controls you might use."

Note from the Author or Editor:
On page 25, in the paragraph before the bulleted list, "control controls" should be "content controls"

Paul Hamel  Jul 01, 2012  Aug 02, 2013
Printed, PDF
Page 30
Step 3

Change "...Projects..." to "...Project..."

Note from the Author or Editor:
In step 3 in the procedure To use the Organizer, Macro Projects Items tab should be Macro Project Items tab.

Paul Hamel  Feb 18, 2013  Aug 02, 2013
Printed, PDF
Page 36
Bottom of page, text box, para 2, lines 4-7 (sentences 2-4 of text box)

Current text states that WordArt text is not searchable and is not included in spell checks. This is incorrect. With Word 2010 in 2010 format (not saved to be compatible with earlier versions), WordArt text is fully searchable and WordArt text is included and recognized when a spell check is run.

Note from the Author or Editor:
In the sidebar Inserting a WordArt Object, the text implies that WordArt objects are not searchable. This is incorrect. WordArt is searchable.

Paul Hamel  Jul 01, 2012  Aug 02, 2013
Printed, PDF
Page 50
2nd para, line 3

Change "Select the Active As option in the Convert dialog box..." to "Select the Activate As option in the Convert dialog box..."

Note from the Author or Editor:
On page 50, in the second paragraph, the reference to Active As is incorrect. The correct reference should be Activate As.

Paul Hamel  Jul 01, 2012  Aug 02, 2013
Printed, PDF
Page 52
Bullet on ROUND()

Suggest deleting the word "down" on lines 5, 6 and 7 of the description for ROUND(). This function states that the argument is rounded down. When I tried all three variations (digit/integer/decimal), it rounded as it should, but not necessarily down.

Note from the Author or Editor:
On page 52, in the description of the Round() function, remove "down" from the phrase "rounded down."

Paul Hamel  Feb 18, 2013  Aug 02, 2013
Printed, PDF
Page 56
4th para, last line

Change "...click Rematch To Set Style." to "...click Reset to Match Style."

Note from the Author or Editor:
On page 56, Rematch To Set Style should be changed to Reset To Change Style.

Paul Hamel  Jul 01, 2012  Aug 02, 2013
Printed, PDF
Page 59
3rd bullet of text box, line 3

Change "...use the columnar chart in that document..." to "...use the bar chart in that document...."

Note from the Author or Editor:
In the third practice task on page 59, "columnar chart" should be "bar chart"

Paul Hamel  Jul 01, 2012  Aug 02, 2013
Printed, PDF
Page 60
last 5 lines on page (after image)

Multiple errors in this para. 1) Line 2: Change "...revise it, and then click Save..." to "...revise it, select the quick part, and then click Save..." Remarks: You must first select the revised quick part, or the the "Save..." menu options remain inactive. 2) Line 4: Change "...Save Selection To Gallery ..." Change to "...Save Selection To Quick Part Gallery..." Remarks: The submenu command under Quick Parts always reads "Save selection to Quick Part Gallery...". Only the contextual menu buttons such as Cover Page, Header and Footer offer contextual text for their respective save options. 3) Lines 4 & 5: Delete "or press F3 to open the dialog box." Remarks: Pressing F3 results in the MS Word Status bar displaying, "The specified text is not a vaild building block name"

Note from the Author or Editor:
The last paragraph on page 60 should read as follows: To make changes to a built-in building block--adding a cover page, for example, add it to your document, revise it, select the quick part, and then click Save Selection To Gallery (for a cover page, the command is Save Selection to Cover Page Gallery). Word displays the Create New Building Block dialog box. (You can also click Quick Parts, Save Selection to Quick Part Gallery on the Insert tab.)

Paul Hamel  Jul 01, 2012  Aug 02, 2013
Printed, PDF
Page 61
5th bullet, line 1

Change "Options pecify how..." to "Options specify how..."

Note from the Author or Editor:
On page 61, in the last bullet in the list, the text should read Options Specify how you want ...

Paul Hamel  Jul 01, 2012  Aug 02, 2013
Printed, PDF
Page 68
Practive Task text box, bullet/task 2, last sentence

Change "Save the header as a new building block in the Header gallery." to "Save the footer as a new building block in the Footer gallery." Remarks: This task begins by instructing to insert a footer, but then ends by stating to save header ...in the header gallery. Note: The referenced document, ContentReuse.docx, already has a header, so changing all references in this task to footer is the best correction.

Note from the Author or Editor:
Change the last sentence of the second practice task on page 68 to read: Save the footer as a new building block in the Footer gallery.

Paul Hamel  Jul 01, 2012  Aug 02, 2013
Printed, PDF
Page 83
1st para, line 6

Change "...guide (APS Fifth Edition),..." to "...guide (APA Fifth Edition),..."

Note from the Author or Editor:
On page 83, in the sixth line of the first paragraph, change (APS Fifth Edition) to (APA Fifth Edition).

Paul Hamel  Jul 01, 2012  Aug 02, 2013
Printed, PDF
Page 86
2nd para, last sentence

Change "But be warned that if you have sources defined on this computer (or if another user does), that source list is replaced by those defined in the copy of Sources.xml you open." Change to: "Bub be warned that this will replace any existing definitions of the currently logged on user." Remarks: The Sources.xml file is saved to a user profile path, not to a shared windows path. On Windows 7, the path is C:\Users\username\AppData\Roaming\Microsoft\Bibliography\. This allows each user to have their own unique Sources.xml file. So the updates by this set of instruction doesn't overwrite the source list for all users on a PC or those of another user; only the currently logged on user.

Note from the Author or Editor:
In the last sentence of paragraph 2 on page 86, the warning about copying sources to Sources.xml would be better stated as "But be warned that this will replace any existing definitions of the currently logged on user."

Paul Hamel  Jul 01, 2012  Aug 02, 2013
Printed, PDF
Page 93
1st para, line 1

Change "When you are ready to build your table of authorities, click Insert Table Of Authorities on the References tab." to "When you are ready to build your table of authorities, position the cursor where you want the Table of Authorities to appear, then click Insert Table Of Authorities on the References tab."

Note from the Author or Editor:
In the first paragraph on page 93, change the text to read: When you are ready to build your table of authorities, position the cursor where you want the table of authorities to appear, then click Insert Table Of Authorities on the References tab.

Paul Hamel  Jul 01, 2012  Aug 02, 2013
Printed, PDF
Page 94
Line 21 (Step 3, 3rd bullet)

Change "Select or clear the Use original formatting..." to "Select or clear the Keep original formatting..."

Note from the Author or Editor:
In the procedure To format and generate a table of authorities, in the third bullet in step 3, change "Select and clear the Use original formatting option ..." to "Select and clear the Keep original formatting option ..."

Paul Hamel  Jul 01, 2012  Aug 02, 2013
Printed, PDF
Page 94
Step 4. Click OK

After "Click OK." add "(If the field code appears, right-click and select Toggle field codes).

Note from the Author or Editor:
In the procedure To format and generate a table of authorities, change step 4 to read 4. Click OK. (If the field code appears, right-click and select Toggle field codes.)

Paul Hamel  Jul 01, 2012  Aug 02, 2013
Printed, PDF
Page 100
3rd arrow steps, "To specify index..."

Steps are shown in incorrect order. The cursor must be placed first, not last. - Add: above current step 1: "1. In the document, place the cursor where you want the index to appear." (Note: this now appears as part of step 3). - Renumber current 1. On the References tab..." to 2. - Renumber current 2. In the Index dialog box..." to 3. - Renumber and reword current "3. In the document..." to "4. Click OK in the Index dialog box." (this deletes from step 3, "In the document, place your cursor where you want the index to appear, and then", This text was moved above the current step 1).

Note from the Author or Editor:
It is correct that you must insert your cursor in the document before you open the Index dialog box. Step 1 should be In the document, insert your cursor where you want the index to appear.

Paul Hamel  Jul 01, 2012  Aug 02, 2013
Printed, PDF
Page 122
Bullet 2 under "To set up envelopes for mail merge"

Change "2. On the Start Mail Merge menu, click Envelopes." to "2. On the Mailings tab, in the Start Mail Merge group, click Start Mail Merge, then click Envelopes..."

Note from the Author or Editor:
In step 2 of the procedure To set up envelopes for mail merge, change the text to read as follows: "2. On the Mailings tab, in the Start Mail Merge group, click Start Mail Merge, and then click Envelopes."

Paul Hamel  Jul 02, 2012  Aug 02, 2013
Printed, PDF
Page 122-123
Bullets 2-7 under "To set up labels for mail merge"

The changes below are intended to clarify actions taken and should improve readability of both set of steps under "To set up labels for mail merge" Change "2. On the Start Mail Merge menu, click Labels." to "2. On the Mailings tab, in the Start Mail Merge group, click Start Mail Merge, then click Labels..." Change "3. In the Label Options dialog box, select the type of printer you are using." to "3. In the Label Options dialog box, in the Printer information area, select the type of printer you are using." Change "5. Click OK." to "5. Click OK. Confirm the cursor defaults to the first line of the first label." Change "6. Click Select Recipients, and then choose an option for the recipient list you want to use." to "6. Click Select Recipients, choose an option for the recipient list you want to use, then click OK. All except the first label will populate with <<Next Record>> field." Change "7. Add merge fields to the document to create an address block." to "7. Add merge fields to label one of the document to create an address block. Then replicate the field(s) added to label one to all other fields/labels by clicking Update Labels."

Note from the Author or Editor:
In step 7 of the procedure To set up labels for mail merge, the text should read as follows: Add merge fields to the first label to create an address block. In the Write & Insert Fields group, click Update Labels. The other corrections noted are helpful but aren't required.

Paul Hamel  Jul 02, 2012  Aug 02, 2013
Printed, PDF
Page 140
Step 4

Change "4. Close the Visual Basic editor, and then test the button." to "4. Close the Visual Basic editor." Add 5. On the Developer tab, in the Controls group, click Design Mode to disable it, and then test the button." Note: The button can't be tested unless design mode is first deactivated.

Note from the Author or Editor:
On page 140, in step 4 of the procedure To assign a macro to a command button (which starts on the previous page) Change "4. Close the Visual Basic editor, and then test the button." to "4. Close the Visual Basic editor. On the Developer tab, in the Controls group, click Design Mode to disable it, and then test the button."

Paul Hamel  Jul 02, 2012  Aug 02, 2013
Printed, PDF
Page 143
3rd bullet of text box at top of page

Change "As the last steps, click the command button to run its macros, and then run CleanUp from the Quick Access Toolbar." to "As the last steps, toggle off Design mode, click the command button to run its macros, and then run CleanUp from the Quick Access Toolbar."

Note from the Author or Editor:
On page 143, in the last practice task for the preceding section, change "As the last steps, click the command button to run its macros, and then run CleanUp from the Quick Access Toolbar." to "As the last steps, turn off Design mode, click the command button to run its macros, and then run CleanUp from the Quick Access Toolbar."

Paul Hamel  Jul 02, 2012  Aug 02, 2013
Printed, PDF
Page 168-169
Bottom of page 168 and top of 169

The order of steps don't appear to be correct for the last bullet on page 168, and continuing thru 2nd bullet and steps on page 169. The Map Properties option (top of page 169) is inactive and can't be clicked where indicated. I believe the following will correct: Page 168: Add step "6. In the XML Source pane, drag the XML elements to the area on the worksheet where you want the data to appear." (this is currently on page 169, 2nd bullet entitled "To import XML data", 1st step). Page 169, Under "To import XML data": - Remove step 1, which has been added as step 6 on page 168. - Renumber steps 2 and 3 to steps 1 and 2 - On the last step, change the last word from "Open" to "Import" so that it reads, "...locate the XML data file and then click Import."

Note from the Author or Editor:
At the end of the procedure on page 168, add step 6: "In the XML Source pane, drag the XML elements to the area on the worksheet where you want the data to appear."

Paul Hamel  Feb 18, 2013  Aug 02, 2013
Printed, PDF
Page 172
Last bullet, step 1

At end of step 1, "On the Changes tab, click Allow Users to Edit Ranges", add "(Sheet must first be unprotected)."

Note from the Author or Editor:
On page 172, in the procedure To allow users to edit cell ranges in a protect sheet, step 1 should read 1. On the Review tab, in the Changes group, click Allow Users To Edit Ranges. (You must unprotect the worksheet first if necessary.)

Paul Hamel  Feb 18, 2013  Aug 02, 2013
Printed, PDF
Page 196
Line 6 from top

Change "...except for table tables." to "...except for data tables."

Note from the Author or Editor:
The sentence on page 196 should read: That's why Excel gives you an option to retain automatic calculations except for data tables.

Paul Hamel  Feb 18, 2013  Aug 02, 2013
Printed
Page 201
Paragraph titled "To use the SUMIFS function"

example should say SUMIFS (instead of SUMIF)

Note from the Author or Editor:
In the procedure, To use the SUMIFS function, the formula provided as an example should refer to the SUMIFS function instead of SUMIF.

harvey akerman  Mar 09, 2012  Aug 02, 2013
Printed, PDF
Page 244-257
3.3 Apply and Manipulate PivotTables

The majority of images and related text on pages 244-257 refer to a file called 'Population.xlsx' (according to the titlebar shown in most images). These examples/images are actually from a Chapter 2 Practice File called 'Function_examples.xlsx', on the worksheet/tab called 'PopulationData'. I would recommend noting this at the beginning of section 3.3 so users wanting to practice with the file and matching data can do so as they read thru this section.

Note from the Author or Editor:
You can find the sample data shown in the section Apply and Manipulate PivotTables in the Chapter 2 practice file named Function_examples.xlsx.

Paul Hamel  Feb 20, 2013  Aug 02, 2013
Printed, PDF
Page 272
Practice Tasks box, bullet 1, line 3

Suggest changing 'text file' to 'Access file'. I didn't find the PivotTable option when trying to connect to a text file, but did when connecting to an Access file.

Note from the Author or Editor:
In the first bullet in the practice tasks on page 272, use the Access file instead of the text file to create a PivotTable.

Paul Hamel  Feb 20, 2013  Aug 02, 2013
Printed, PDF
Page 274
Line 2

I believe the file extension in parens should be .xlsm, not .xlsb. This is defined on the preceeding page in the last para. (The xlsb is a valid extension, but is typically associated with a binary Personal Macro workbook, not a Macro-Enabled workbook as shown here).

Note from the Author or Editor:
The file name extension referenced at the top of page 274 should be .xslm instead of .xslb.

Paul Hamel  Feb 20, 2013  Aug 02, 2013
Printed
Page 276
first paragraph

Page states that relative cell references are displayed using $$ dollar signs, while absolute references are displayed without dollar signs. This is reversed.

Note from the Author or Editor:
The first paragraph on the page should be changed as follows: Before you record a macro, you should also determine whether to use absolute or relative cell references . (You can use a combination of the two as necessary) . If you keep absolute references, the macro operates only in the specific cells you use when you record the macro . For example, with absolute references, if you insert a series of dates or names in the cell range A1:G1 as a step in recording a macro, that macro works only in that cell range when you run it . If you use relative references (by clicking Use Relative References in the Code group), the macro will insert the data in any comparable range of cells.

Michael Styles  Oct 05, 2011  Oct 14, 2011
Printed
Page 283
2nd Paragraph after 'See Also' Box

At the end of the second line, 'This Worksheet' should read 'This Workbook'.

Note from the Author or Editor:
The reference to This Worksheet at the end of the second line of the second paragraph after the See Also reference on page 283 should be ThisWorkbook. Change the second sentence in this paragraph to read as follows: In the Project Explorer (the pane at the left), right-click This Workbook and choose View Code.

Anonymous  Oct 14, 2011  Aug 02, 2013
Printed, PDF
Page 305
Step 6, line 2

Change the formula's value if true from I13*.1 to I13*-.1 Adding the minus symbol changes the result to match the negative number as shown in the sample image on the preceeding page.

Note from the Author or Editor:
In step 6 on page 305, the formula for cell I16 should be =IF(I13>=100,I13*-.1,0) to procedure the negative number for the discount.

Paul Hamel  Feb 21, 2013  Aug 02, 2013
Printed, PDF
Page 305
Step 6, line 4

The end of this step says the formula enters 0. Suggest adding: and is displayed as '-'.

Note from the Author or Editor:
At the end of step 6 on page 305, the last sentence should read If the order is less than 100, the formula enters 0 and the value is displayed as '-'.

Paul Hamel  Feb 21, 2013  Aug 02, 2013
Printed
Page 308
last line

"... enter a custom record ..."; should be "... enter a customer record ..."

Note from the Author or Editor:
In the last line on page 308, the text refers to a "custom" record, but the text should refer to a "customer" record. Change the last sentence on this page to read as follows: "This prevents you from having to enter a customer record for each separate order."

Anonymous  Oct 21, 2011  Aug 02, 2013
Printed, PDF
Page 328
Under Object Designers, line 2

Change "Option Designers category..." to "Object Designers catetory..."

Note from the Author or Editor:
On page 328, in the section Object Designers, the reference to Option Designers category should be to the Object Designers category.

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed
Page 331
1st paragraph, 2nd sentence

1st paragraph, 2nd sentence refers to the arrow button in the top-right corner of the Navigation Pane. This section mentions the possibility that the Navigation Pane is closed. The arrow button that opens it is located to the far LEFT in this situation, and there is no visible navigation pane for the button to be in the "top-right corner of". Also, I believe I saw that button referred to as a "double-arrow" elsewhere -- probably need more consistent terminology.

Note from the Author or Editor:
On page 331, the second sentence on the page (in the first paragraph after the heading 1.2 Configure the Navigation Pane) should read as follows: "To show or hide the navigation pane, click the arrow button that appears at the top of the pane."

Anonymous  Oct 21, 2011  Aug 02, 2013
Printed
Page 349
last line

Page 349; last line mentions storing "a 1 for true..." -- I'm pretty sure Access stores a -1 for true in a Boolean field (yes, I know, SQL-Server uses a 1)

Note from the Author or Editor:
On page 349, in the description of the Yes/No field, the second sentence should read that Access stores -1 for true and 0 for false.

Anonymous  Oct 21, 2011  Aug 02, 2013
Printed
Page 358
econd line, 1st paragraph

Page 358; second line, 1st paragraph; "...then select After Update. Access Opens the macro..." I suspect that "Opens" should be "opens".

Note from the Author or Editor:
In the second line of the first paragraph on page 358, the word Opens should be lowercase. Please change as follows: "...then selects After Update. Access opens the macro designer...

Anonymous  Oct 21, 2011  Aug 02, 2013
Printed, PDF
Page 374
1st para, line 2

The button in the Sort & Filter group is called "Selection". Change "...click Filter By Selection..." to "...click Selection..."

Note from the Author or Editor:
In the first paragraph on page 374, in the second sentence, the reference "click Filter by Selection" should be "click Selection"

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed, PDF
Page 376
Step 3 under To filter by selection

The button in the Sort & Filter group is called "Selection". Change "...click the Filter By Selection button." to "...click the Selection button."

Note from the Author or Editor:
On page 376, in step 3 on the first procedure, the instruction should be to "click the Selection button" rather than "click the Filter by Selection button."

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed, PDF
Page 408
Para 3, line 3

Change "If the Live Preview featured is enabled..." to "If the Live Preview feature is enabled..."

Note from the Author or Editor:
In the third paragraph on page 408, the second sentence should read "If the Live Preview feature is enabled .....

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed, PDF
Page 420
Step 1 under To set the tab order for a form

Delete "or Layout View" The tab order button/option is not available in the Tools group of Layout view.

Note from the Author or Editor:
The procedure To set the tab order for a form should refer only to Design view. The command is not available in Layout view.

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed, PDF
Page 420
Step 2 under To set the tab order for a form

Delete "(or Layout)" The tab order button/option is not available in the Tools group of Layout view.

Note from the Author or Editor:
On page 420, the procedure To set the tab order for a form should refer only to Design view. The Tab Order command is not available in Layout view.

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed, PDF
Page 423
last line

Change "...text boxes controls..." to "...text box controls..."

Note from the Author or Editor:
In the last line of page 423, "text boxes" should read "text box"

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed, PDF
Page 427
Para 3, line 1

Change "...the Form at Layout..." to "...the Form Layout..."

Note from the Author or Editor:
On page 427, in the first sentence in the third paragraph under Modifying a Form's Background, the reference to the Format Layout Tools Design tab should be to the Form Layout Tools Design tab.

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed, PDF
Page 427
3rd, 4th and 5th bullets

Change "Picture Size Mode" to "Size Mode" in these 3 bullets. The property is called Size Mode, not Picture Size Mode.

Note from the Author or Editor:
On page 427, the text refers to the Picture Size Mode property. In the property sheet, the formal name of the property is Size Mode.

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed, PDF
Page 428
Step 3 under To set properties for a background image

Change "...select Form from the Select type list." to "...select Form from the Selection type list."

Note from the Author or Editor:
In step 3 in the second procedure on page 428, the reference to the Select Type list should be to the Selection Type list.

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed, PDF
Page 428
Step 4 under To set properties for a background image

Change "Picture Size Mode" to "Size Mode". The property is called Size Mode, not Picture Size Mode.

Note from the Author or Editor:
The reference to the Picture Size Mode property refers to the Size Mode property. The property relates to how pictures are sized.

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed, PDF
Page 430
Step 6, bullet 1

Change "Quick Style" to "Quick Styles"

Note from the Author or Editor:
On page 430, in step 6, the first bullet should refer to Quick Styles instead of Quick Style.

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed, PDF
Page 433
Step 1 near top of page

Add to end of stop 1, "or Datasheet view" 1. Open the form in Layout view, Design view, or Datasheet view.

Note from the Author or Editor:
Step 1 should read Open the form in Layout view, Design view, or Datasheet view.

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed, PDF
Page 433
Step 3 near top of page

Change "On the Form Design Tools Format tab..." to "On the Form Design or Layout Tools Format tab..."

Note from the Author or Editor:
Step 3 on page 433 should refer to the Form Design or Form Layout Tools Format tab.

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed
Page 437
2nd paragraph, first sentence

The sentence claims that including numeric fields (or fields from more than one table) will cause the wizard to prompt for detail and/or summary query. I suspect that this is NOT true when the field is either an Autonumber/ID field, or is a lookup field that stores a numeric value, but displays the corresponding looked-up value.

Note from the Author or Editor:
In referring to "numeric" fields at the start of the second paragraph, the reference is to fields using the Number data type, not lookup fields or ID fields.

Anonymous  Oct 21, 2011  Aug 02, 2013
Printed, PDF
Page 442
last line on page

Delete "double click the make table query in the navigation pane or". The sentence should read, To create the table, click Run in the Results group on the Query Tools Design tab. The query has been setup but not saved, so it doesn't exist in the navigation pane. Also see step 7 on page 443, which confirms the above deleted text is not applicable.

Note from the Author or Editor:
The sentence should read "To create the table, click Run in the Results group on the Query Tools Design tab."

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed, PDF
Page 444
Step 5

It appears this step was copied from the Make Table query on page 443, but not modified for the Append Query instructions being addressed here. When following this step as written, a dialog box appears that says "Query must have at least one destination field." Suggest rewording step 5 text to something similar to: In the append dialog box, select a table from the current database by using the list picker, or select Another Database and type the file name or use the Browse button to locate the file.

Note from the Author or Editor:
In step 5, the wording would be better as In the Append dialog box, select a table from the current database by using the list picker, or select Another Database and type the file name or use the Browse button to locate the file."

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed, PDF
Page 444
Step 6

Suggest adding text at end of this step: Access adds the Append To: row to the design grid, and displays the field names that the data will be appended to.

Note from the Author or Editor:
After you perform step 6, Access adds the Append To: row to the design grid, and displays the field names that the data will be appended to.

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed, PDF
Page 444
After step 8

Suggest adding to step 8, or adding new step 9: Close the query, then open the table to confirm the records appended.

Note from the Author or Editor:
It is a good idea to open the table to confirm that the operation was successful.

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed
Page 454
Second sentence un "Changing the Fields in a Query"

"...and drag the field to a blank row in the query designer." You aren't inserting a new row, but a new COLUMN.

Note from the Author or Editor:
The reference to dragging a field to a blank row is unclear. It would be clearer to refer to a blank column--or to a blank Field row.

Anonymous  Nov 10, 2011  Aug 02, 2013
Printed, PDF
Page 458
Para 2, last word

Correct spelling of "summariz" to "summarize".

Note from the Author or Editor:
the spelling is incorrect. It should be "summarize"

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed, PDF
Page 483
Para 1, line 3

Change "...when have the report..." to "...when you have the report..."

Note from the Author or Editor:
The phrase should read "...when you have the report open in Design view."

Paul Hamel  May 09, 2013  Aug 02, 2013
Printed, PDF
Page 497
2nd "Important" box; bottom of page

Add to 2nd boxed note: However, the MySite page typically has few restrictions which allows most of the tasks in this chapter to be completed. For example, open SharePoint, open your MySite page, and then use the Team Site template to create a Team Site as a subsite of your MySite. From this sub-site, almost all tasks in this chapter can be completed.

Note from the Author or Editor:
On page 479 add to the 2nd Important box: However, the MySite page typically has few restrictions which allows most of the tasks in this chapter to be completed. For example, open SharePoint, open your MySite page, and then use the Team Site template to create a Team Site as a subsite of your MySite. From this sub-site, almost all tasks in this chapter can be completed.

Paul Hamel  Dec 12, 2012  Aug 02, 2013
Printed, PDF
Page 501
2nd bullet, item 2, line 2

Change "Contents" to "Content" .

Note from the Author or Editor:
On page 501, 2nd bullet, item 2, line 2 change "Contents" to "Content"

Paul Hamel  Dec 12, 2012  Aug 02, 2013
Printed, PDF
Page 502
2nd para, lines 3 and 4

Change wording of last sentence from "The option you need in this case is quick Launch, which you can find in the Look And Feel section." to "The option you need in this case is Enable Quick Launch, which you can find by clicking Tree view within the Look and Feel section. The link Navigation provides similar options with slightly different naming conventions."

Note from the Author or Editor:
On page 502, in the 2nd para lines 3 and 4 alter The option you need in this case is quick Launch, which you can find in the Look And Feel section. to The option you need in this case is Enable Quick Launch, which you can find by clicking Tree view within the Look and Feel section. The link Navigation provides similar options with slightly different naming conventions.

Paul Hamel  Dec 12, 2012  Aug 02, 2013
Printed, PDF
Page 503
Step 1 under "To edit a link..."

Under task named "To edit a link or heading from the Quick Launch bar", change last word in step 1 from "delete" to "edit".

Note from the Author or Editor:
On page 503 in step 1, under "to edit a link", under task named "To edit a link or heading from the Quick Launch bar", change last word in step 1 from "delete" to "edit".

Paul Hamel  Dec 12, 2012  Aug 02, 2013
Printed, PDF
Page 505
1st line

Change "This is what a default All Site Content page looks like:" to "This is what a default All Site Content page looks like on a SharePoint Team site:"

Note from the Author or Editor:
On page 505, 1st line, change "This is what a default All Site Content page looks like:" to "This is what a default All Site Content page looks like on a SharePoint Team site:"

Paul Hamel  Dec 12, 2012  Aug 02, 2013
Printed, PDF
Page 506
2nd bullet

Change "Contents" to "Content". The bullet should read, "To display all the document libraries while on the All Site Content page.

Note from the Author or Editor:
On page 506, 2nd bullet, change "Contents" to "Content". The bullet should read, "To display all the document libraries while on the All Site Content page

Paul Hamel  Dec 12, 2012  Aug 02, 2013
Printed, PDF
Page 514
1st sub bullet mid page, below Tip

Change "(Icon Linked To Document)" to "(Linked To Document)".

Note from the Author or Editor:
On page 514, 1st sub bullet mid page, below Tip, change "(Icon Linked To Document)" to "(Linked To Document)".

Paul Hamel  Dec 12, 2012  Aug 02, 2013
Printed, PDF
Page 514
1st bullet mid page, below Tip

Change "brackets" to "parenthesis" to correct bullet to read, In the columns section, some columns have additional options, which are displayed to the right of the column in parenthesis."

Note from the Author or Editor:
On page 514, in the 1st bullet mid page, below Tip, change "brackets" to "parenthesis" to correct bullet to read, In the columns section, some columns have additional options, which are displayed to the right of the column in parenthesis."

Paul Hamel  Dec 12, 2012  Aug 02, 2013
Printed, PDF
Page 515
Tip mid page, lines 2 and 3

Change wording in 1st sentence beginning after 1st comma on line 2 to "point to Modify View, select the down arrow, and then click Modify In SharePoint Designer (Advanced)."

Note from the Author or Editor:
On page 515, Tip mid page, lines 2 and 3, change wording in 1st sentence beginning after 1st comma on line 2 to "point to Modify View, select the down arrow, and then click Modify In SharePoint Designer (Advanced)."

Paul Hamel  Dec 12, 2012  Aug 02, 2013
Printed, PDF
Page 519
Practice Tasks, bullet 2, line 2

The column names shown in line 2 are reversed. Change bullet to read, "Include the ID column on the view, and change the Sort option from sorting by the Modified By column to sorting by the Title column." Note: The prior task set the sort order to Modified By, so this step needs to change it to something other than what it already is.

Note from the Author or Editor:
On page 519, Practice Tasks, bullet 2, line 2, change bullet to read, "Include the ID column on the view, and change the Sort option from sorting by the Modified By column to sorting by the Title column."

Paul Hamel  Dec 12, 2012  Aug 02, 2013
Printed, PDF
Page 520
Item 4

Change wording from "... or click Close to cancel the action." to "...or click Cancel to cancel the action."

Note from the Author or Editor:
On page 520, item 4, change wording from "... or click Close to cancel the action." to "...or click Cancel to cancel the action."

Paul Hamel  Dec 12, 2012  Aug 02, 2013
Printed, PDF
Page 522
Line 4 of 1st para

Suggest deleting 'file or' . As noted by first three words on this page, this is discussing something different than files not both file and list items.

Note from the Author or Editor:
On page 522, line 4 of 1st para delete 'file or'

Paul Hamel  Feb 22, 2013  Aug 02, 2013
Printed, PDF
Page 524
Step 1 under To edit item properties

Suggest deleting 'add a column to' at end of step and replace with 'edit'. These steps are to edit item properties (per steps 3-5), not to add columns. Adding columns is covered on pages 516-529.

Note from the Author or Editor:
On page 524, Step 1 under To edit item properties, delete 'add a column to' at end of step and replace with 'edit'

Paul Hamel  Feb 22, 2013  Aug 02, 2013
Printed, PDF
Page 534
Step 5, line 1

Suggest changing 'workflow settings page' to 'Add a Workflow page'.

Note from the Author or Editor:
On page 534, step 3, line 1 change 'workflow settings page' to 'Add a Workflow page'.

Paul Hamel  Feb 22, 2013  Aug 02, 2013
Printed, PDF
Page 534
Step 6

Suggest deleting step 6. The Content Type list and Document never appeared when I did this process. After completing step 5, the options in step 7 were visible.

Note from the Author or Editor:
On page delete step 6

Paul Hamel  Feb 22, 2013  Aug 02, 2013
Printed, PDF
Page 534
Step 7

Unbold the 4th word, area

Note from the Author or Editor:
On page 534, step 7, unbold the 4th word, area

Paul Hamel  Feb 22, 2013  Aug 02, 2013
Printed, PDF
Page 534
Step 8

Suggest changing 'Name prompt' to 'Name area'

Note from the Author or Editor:
On page 534, step 8, change 'Name prompt' to 'Name area'

Paul Hamel  Feb 22, 2013  Aug 02, 2013
Printed, PDF
Page 534
Step 9

Unbold the 5th word, 'area'. Reword end of step 9 from 'Select a task list list' to 'Select a task list drop-down list'.

Note from the Author or Editor:
On page 534, step 9, unbold the 5th word, 'area' and reword end of step 9 from 'Select a task list list' to 'Select a task list drop-down list'.

Paul Hamel  Feb 22, 2013  Aug 02, 2013
Printed, PDF
Page 534
After step 17

Suggest adding step 18 Click Save to save the workflow.

Note from the Author or Editor:
On page 534, after step 17, add step 18 Click Save to save the workflow

Paul Hamel  Feb 22, 2013  Aug 02, 2013
Printed, PDF
Page 534-535
Steps 1-4 under To access workflow settings in a repository

Suggest rewording this procedure and the 4 steps to improve accuracy. It appears to mix steps and descriptions for both creating a new workflow and accessing an existing workflow, but the steps are different enough that I'd suggest they not be mixed. The resulting descriptions, screens and displayed breadcrumb are different for each. Steps 1 and 2 are fine as they are for both creating new and accessing an existing workflow. Steps 3 and 4 are mostly correct to access a blank workflow page. Only suggested change would be in Step 4, change 'Library Settings' to 'Document Library Settings'. To access existing workflow settings, I'd suggest using the current steps 1 and 2, and then add the following: 3. In the Settings section, click the drop-down list under Workflow Settings, and select Workflow Settings from the menu. 4. On the Workflow Setting screen, select the desired type from the 'These workflows are configured to run on items of this type:' list. The name of the workflow displays under 'Workflow Name (click to change settings)', along with the number of workflows in progress. 5. Click on the desired workflow name to access the 'Change a Workflow' screen and view/edit the existing workflow settings.

Note from the Author or Editor:
On page 534 - 535, replace steps 3 and 4 with: 3. In the Settings section, click the drop-down list under Workflow Settings, and select Workflow Settings from the menu. 4. On the Workflow Setting screen, select the desired type from the 'These workflows are configured to run on items of this type:' list. The name of the workflow displays under 'Workflow Name (click to change settings)', along with the number of workflows in progress. 5. Click on the desired workflow name to access the 'Change a Workflow' screen and view/edit the existing workflow settings.

Paul Hamel  Feb 22, 2013  Aug 02, 2013
Printed, PDF
Page 538
Step 3, line 2

Change 'template.docx' to 'template.dotx.'

Note from the Author or Editor:
On page 538, step 3, line 2, change 'template.docx' to 'template.dotx.'

Paul Hamel  Feb 22, 2013  Aug 02, 2013
Printed, PDF
Page 542
Step 5, mid page

Suggest rewording first line to: In the Group section, in the Existing group: drop-down list, select Document Set Content Types to make...

Note from the Author or Editor:
On page 542, Step 5, mid page reword first line to: In the Group section, in the Existing group: drop-down list, select Document Set Content Types to make...

Paul Hamel  Feb 22, 2013  Aug 02, 2013
Printed, PDF
Page 552
Step 3, last line on page

Add 'Site' to beginning of last line on page. Should read: ...to display the Site Content and Structure page.

Note from the Author or Editor:
On page 552, Step 3, last line on page, Add 'Site' to beginning of last line on page. Should read: ...to display the Site Content and Structure page.

Paul Hamel  Feb 22, 2013  Aug 02, 2013
Printed, PDF
Page 555
Step 2 at top of page

Change sentence Step 2 sentence 2 to read: This displays the Features page.

Note from the Author or Editor:
On page 555, Step 2 at top of page, change sentence Step 2 sentence 2 to read: This displays the Features page.

Paul Hamel  Feb 22, 2013  Aug 02, 2013
Printed, PDF
Page 557
Step 3 under To enable the SharePoint tree view in a SharePoint site

Suggest replacing the 2nd line of step 3 with: In the Enable Tree view section of the Tree view page, check to Enable Tree View, then click OK. The Tree View is displayed in the lower portion of the Quick Launch bar under Site Content.

Note from the Author or Editor:
On page 557, Step 3 under To enable the SharePoint tree view in a SharePoint site, replace the 2nd line of step 3 with: In the Enable Tree view section of the Tree view page, check to Enable Tree View, then click OK. The Tree View is displayed in the lower portion of the Quick Launch bar under Site Content.

Paul Hamel  Feb 22, 2013  Aug 02, 2013
Printed, PDF
Page 565
Step 2 under To hide a Web Part

Reword end of step from 'click Edit Page' to 'clic Title Bar Properties'

Note from the Author or Editor:
On page 565, Step 2 under To hide a Web Part, reword end of step from 'click Edit Page' to 'clic Title Bar Properties'

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 565
Step 3 under To hide a Web Part

Delete step 3. After clicking on Title Bar Properties in step 2 (per above correction), the next step is step 4. Step 3 doesn't apply.

Note from the Author or Editor:
On page 565, Step 3 under To hide a Web Part, delete step 3.

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 567
1st procedure, To export a Web Part

Suggest clarifying that only certain web parts can be exported.

Note from the Author or Editor:
Before the 1st procedure on page 567 add a Readeraid stating as follows: Note that not all Web Parts can be exported. If the option to Export is not available when the drop down arrow next to the Web Part that you want to export is clicked, that Web Part cannot be exported.

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 586
Step 7, line 3

Change 'Ask Me About section' to 'Skills section'. The 'Ask Me About' section provides links that allow others to post questions. The Skills section just lists the skills.

Note from the Author or Editor:
On page 586 step 7, line 3 change 'Ask Me About section' to 'Skills section'

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 586
Step 3 under To add colleagues (near bottom of page)

Suggest deleting step 3. After completing step 2, the next process is correctly noted in step 4. Step 3 doesn't apply here.

Note from the Author or Editor:
Delete step 3, change step 4 to step 3 on page 586

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 587
Step 2 near bottom of page

Change both occurrences of the word 'Profile' to 'Content'. ...click the My Content link to display your content page.

Note from the Author or Editor:
On page 587 in step 2 near bottom of page change both occurrences of the word 'Profile' to 'Content'

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 588
Step 2

Change both occurrences of the word 'Profile' to 'Content'. ...click the My Content link to display your content page.

Note from the Author or Editor:
On page 588 in step 2 change both occurrences of the word 'Profile' to 'Content'

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 590
Step 2

Change both occurrences of the word 'Profile' to 'Content'. ...click the My Content link to display your content page.

Note from the Author or Editor:
On page 590 in step 2 change both occurrences of the word 'Profile' to 'Content'

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 590
Step 9

See suggestion above (pages 589-590) regarding to move an image. If the image isn't moved, suggest adding to end of Step 9, '(see image on page 589)'

Note from the Author or Editor:
Add to end of Step 9 (see image on page 589)

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 590
Step 11

Change 'seconds' to 'minutes'

Note from the Author or Editor:
On page 590 in step 11 change 'seconds' to 'minutes'

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 594
2nd para below Sharing Pictures and Documents in My Site

Suggest checking word descriptors used in this para to improve clarity. Suggest: - line 3: change 'private' to 'personal' - line 3: change 'a pictures list library' to 'a Shared Pictures list library' - line 5: change 'your public home page in the Content section' to 'your public home page (My Profile/Content tab) in the Content section'

Note from the Author or Editor:
On page 594, in the second para below Sharing Pictures in line 3 change 'private' to 'personal'

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 597
Step 5 under the Note box, mid page

Suggest rewording. 'Personal Documents' is listed under Recent Locations, not under Locations. Under Locations, the listing is for My Site, which includes a URL to http://mysite.xxx/personal/myname. The wording of #5 should be changed to reference one or the other if these values. Either: - 5. Under Recent Locations, select Personal documents and then click Save As. or - 5. Under Locations, select MySite, which links to your personal documents folder, and then click Save As.

Note from the Author or Editor:
On page 597 replace step 5 with: 5. Under Recent Locations, select Personal documents and then click Save As

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 597
Step 1 near bottom of page, under Delete a document...

Clicking the file opens the file. To delete a document, either add a check to the box to the left of the file and then continue with existing steps 2 and 3, or, click the pull-down arrow to the right of the filename and select Delete from the context menu, then OK to confirm (this method already includes step 2 and 3).

Note from the Author or Editor:
Replace steps 1 in the Delete a Document section with the following: From your personal or shared document library, add a check to the box to the left of the file.

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 598
Step 2

Change both occurrences of the word 'Profile' to 'Content'. ...click My Content to display the My Content area.

Note from the Author or Editor:
Replace all occurences of My Profile with My Content on page 598

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 598
Steps 3 and 4

Suggest replacing steps 3 and 4 with: 3. Click the Page tab, click Edit Page, then click Add a Web Part to the desired part of the page. 4. Under Categories, click Social Collaboration, and then add the Organization Browser Web Part.

Note from the Author or Editor:
On page 598 replace step 3 and 4 as follows: 3. Click the relevant Page tab, click Edit Page, then click Add a Web Part to the desired part of the page. 4. Under Categories, click Social Collaboration, and then add the Organization Browser Web Part.

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 599
Step 6

Delete the word 'Options'. The section is called Default Values.

Note from the Author or Editor:
Alter Default Options Values to Default Values on page 599

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 611
Step 8

Suggest rewording end of step to display the Indexed Columns > Edit index page

Note from the Author or Editor:
Alter display the Indexed Columns Edit page to display the Indexed Columns Edit index page on page 611

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 613
Step 3 (all three Step 3's)

All three Step 3's on this page reference 'Search and Offline Client Availability'. Suggest deleting the word 'Client' from all three of these. The link is called Search and Offline Availability

Note from the Author or Editor:
Replace all occurences of Search and Offline Client Availability to Search and Offline Availability on page 613

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 617
Step 6, line 5

Within the fabrikam URL, change vin to bin

Note from the Author or Editor:
Alter _vti_vin to _vti_bin

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 634
See Also box

the URL shown fails.

Note from the Author or Editor:
Alter www.sharepointgeoff.com/sharepoint/sps2010sertvapps.aspx to http://sps2010servapps.geoffevelyn.com

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 638
Step 3

Suggest deleting the word double

Note from the Author or Editor:
Change 3. In the list of available templates, double-click Sample templates to 3. In the list of available templates, click Sample templates on page 638

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 638
Step 6

Suggest rewording for clarity: 6. Click the File tab, then the Info group in the left column.

Note from the Author or Editor:
Change 6. Click the File tab to 6. Click the File tab, then the Info group in the left column. on page 638

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 648
Step 4

Suggest changing 'contacts list' to 'task list'. Note the procedure title for these 4 steps is: To synchronize a SharePoint 2010 task list with Outlook

Note from the Author or Editor:
Change 4. When prompted to connect the SharePoint contacts list to 4. When prompted to connect the SharePoint task list on page 648

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 657
1st para, line 2

Change 'featured' to 'feature'

Note from the Author or Editor:
Change: 2010 Enterprise featured to 2010 Enterprise feature on line 2 of second para on page 657

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 658
Step 3 under To enable site collection features

Change 'Active' to 'Activate'

Note from the Author or Editor:
Change 3. Active the following features to 3. Activate the following features on Page 658

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed, PDF
Page 660
2nd Step 2

Change 'SharePoint List Status Indicator' to 'SharePoint List based Status Indicator'

Note from the Author or Editor:
Change: 2. Select SharePoint List Status Indicator to 2. Select SharePoint List based Status Indicator

Paul Hamel  Feb 23, 2013  Aug 02, 2013
Printed
Page 695, back cover
Offer page and back cover page

We apologize, but early printings of this book included information about a free Learning Plan Assessment which is not available.

None  Jan 12, 2012