Errata

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."

Correct spelling of "summariz" to "summarize".

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

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.

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.

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.

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.

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"

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 .....

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.

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

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

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

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

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

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

the URL shown fails.

Note from the Author or Editor:
Alter

www.sharepointgeoff.com/sharepoint/sps2010sertvapps.aspx

to

http://sps2010servapps.geoffevelyn.com

Within the fabrikam URL, change vin to bin

Note from the Author or Editor:
Alter

_vti_vin

to

_vti_bin

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

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

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

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'

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)

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'

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.

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.

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'

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.

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.

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.

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...

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

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'.

Suggest changing 'Name prompt' to 'Name area'

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

Unbold the 4th word, area

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

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

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'.

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'

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'

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 '-'.

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.

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.

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.

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.)

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.

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.

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)."

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)".

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."

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

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:"

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.

Change "Contents" to "Content" .

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

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."

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."

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.

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."

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.)

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 ..."

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.

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).

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.

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 ...

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"

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.

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.

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"

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.

"...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.

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.

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...

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."

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.