Errata
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 xv 4th paragraph |
Under the heading 'About the Creative Team' in the 3rd paragraph after the name 'James Turner' the text '(technical reviewer)' is repeated i.e. '(technical reviewer)(technical reviewer)'. Easy to miss if you have been staring at the same words for months. I wouldn't normally bother worrying too much about such minor errors but it is a bit in your face as it is in a place that a lot of people will read first. Given I like the book I thought I'd point this one out. Cheers Neil |
Neil Bensley | Aug 30, 2010 | Aug 12, 2011 |
Printed, Safari Books Online | Page xv 1st paragraph, 2nd sentence |
"word of Excel" should be "world of Excel" |
Nan Barber |
Sep 16, 2010 | Aug 12, 2011 |
Printed | Page 36 Table 1-1 Tiltle / description |
Table Tile / description reads as "Keys for Moving Around Datash", should be "Keys for Moving Around Datasheet" Note from the Author or Editor: |
ZedBee | Mar 26, 2012 | |
Printed | Page 37 Last row in table 1-2 |
Ctrl+Alt+Space is only of use if you have changed the default value and want to go back to it. You don't want to give the impression that you have to use Ctrl+Alt+Space to get the default value in the first place. So how about "Reinstates" rather than "Inserts"? Note from the Author or Editor: |
Mayo Marriott | Nov 10, 2011 | Dec 02, 2011 |
Printed | Page 72 Figure 2-14 |
The Field Name is ForResale, not ForSale. Note from the Author or Editor: |
Mayo Marriott | Nov 10, 2011 | Dec 02, 2011 |
Printed | Page 80 Last paragraph in the box "Gem in the rough" |
8th line of paragraph - text says: " ... and Country ReAccess fans ... " I think should read: " ... and Country Region. Access fans ... " Note from the Author or Editor: |
Nick Barlow | Dec 28, 2011 | |
Printed | Page 100 1st paragraph |
"order: MiddleInitial,FirstName,LastName" should read "order: LastName,FirstName,MiddleInitial" Note from the Author or Editor: |
Tom Spence | Sep 04, 2011 | Dec 02, 2011 |
Printed | Page 100 First Paragraph |
I am suspecting that the original text was actually correct. When I try to do a multiple sort, in order to get the proper sort, I have to first sort by the last field of the desired sort (i.e. MiddleInitial in this example), then the second-to-last, then the first. For example, the original text read "MiddleInitial, FirstName, LastName" and was subsequently changed to "LastName, First Name, MiddleInitial". If I sort the second way (the way the printed book now suggests) I get the wrong sort. But if I sort in the way the original text read, the sort works as I want it to. I think the text needs to be changed back to the original. Note from the Author or Editor: |
Anonymous | Jun 27, 2012 | |
Printed | Page 108 Add a bullet, bottom half of page |
There is one more way to change a word, if the correction is not listed in the suggestions, besides these three, or "Cancel" at the bottom of the next set of bullets. The way is to type what you want in the "Not in Dictionary" field, then press 'Enter' or the 'Change' button. Confirm that you want to do this and it is changed. ------ Another topic, from an article I read. There are times when a person should remove a word from the main dictionary. The example given was someone who persistently misspells "manager" as "manger". That person wants the spell-checker to catch it. Manuals should mention this and how to do it. Note from the Author or Editor: |
David W. Olson | Oct 07, 2011 | |
Printed | Page 112 Figure 3-18 |
In the errata, the author/editor hasn't got this quite right. There is no Character Map Window figure in my edition and as the text on page 112 says "Figure 3-18 explains the "Replace text as you type" option". Note from the Author or Editor: |
Mayo Marriott | Nov 10, 2011 | Dec 02, 2011 |
Printed | Page 113, 114 Mid page, end of 1. step |
First i should say this is a great book for starter. Page 113, last line of the "1." step reads "Either way, you'll see the same Character Map window (Figure 3-19)". (Figure 3-19) is not a charater map window. Page 114 on the bottom left of the "GEM in the rough" section reads "A drop-down list appears with different types of calculations (Figure 3-20)". (Figure 3-20) is not a drop-down list with different types of calculations. I think (Figure 3-19) is missing and (Figure 3-20)on page 114 should read (Figure 3-19). Note from the Author or Editor: |
Anonymous | Mar 05, 2011 | Aug 12, 2011 |
Printed, Safari Books Online | Page 131 Figure 4-11 |
"The phone number mask is !(999) 000-000." should be "The phone number mas is !(999) 000-0000." (Missing zero.) |
Crimson Meerkat | Aug 23, 2010 | Aug 12, 2011 |
Printed | Page 134 4th sample bullet 99:00:00 >LL |
The sample mask includes seconds while the text mentions only hours and minutes. It seems to me that 0's and 9's work in a rather special way on times. A segment of a mask with value '99' allows you to enter an hour/minute/second less than 10 as space followed by hour/minute/second or as hour/minute/second followed by space, while a segment of a mask with value '00' makes you enter 0 followed by hour/minute/second. So '99' does not make the segment of the time truly optional and work in the same way as the phone number and zip code masks. Note from the Author or Editor: |
Mayo Marriott | Nov 10, 2011 | Dec 02, 2011 |
Printed | Page 134 Third bulleted sample mask |
The mask L0L 0L0 does not work for UK postcodes. There are six valid formats which result in a postcode of from 6 to 8 characters. Maybe on page 133 in Table 4-1 you should explain what optional means, namely that the placeholder has a blank value if nothing is entered. And maybe you should bring forward the description of the limitation of input masks which is on the second line of page 136 to the Input Masks section. Returning to UK postcodes, you can write a field validation rule to cover the six format as follows Like "[A-Z]# #[A-Z][A-Z]" Or Like "[A-Z][A-Z]# #[A-Z][A-Z]" Or Like "[A-Z]#[A-Z] #[A-Z][A-Z]" Or Like "[A-Z]## #[A-Z][A-Z]" Or Like "[A-Z][A-Z]#[A-Z] #[A-Z][A-Z]" Or Like "[A-Z][A-Z]## #[A-Z][A-Z]" In fact you can go further than this and replace [A-Z] by the letters which are actually valid. Note from the Author or Editor: |
Mayo Marriott | Nov 17, 2011 | Dec 02, 2011 |
Printed | Page 140 table at top of page |
The table at the top of page 140 contains a few errors. The following Sample Expressions are incorrect(or the descriptions are wrong): >Date(), <Date(), >Now(), and <Now(). The Sample Expressions as explained by the description should be as follows: >=Date(), <=Date(), >=Now(), and <=Now(). Note from the Author or Editor: |
John Cellini | Dec 12, 2010 | Aug 12, 2011 |
Printed | Page 200 5th paragraph |
Find unmatched query wizard...You'll fins how this works on page 195. It's not on page 195 Note from the Author or Editor: |
Anonymous | Nov 07, 2010 | Aug 12, 2011 |
Printed | Page 236 Table 7-6 |
The example for "DateDiff" function uses "w" as an argument. Table 7-5 indicates that "w" returns 1-7 only meaning day of the week. This does not make intuitive sense. Perhaps Table 7-5 does not apply for DateDiff? Note from the Author or Editor: |
Tom Spence | Dec 01, 2010 | Aug 12, 2011 |
Page 261 Figure 8-8 |
The DeleteVeryOldOrders delete query shown (as packaged in Chapter08 of Access2010TMM_missingCD) is blocked by referential integrity. Order ID 4 has a related record in the OrderDetails table (OrderDetails ID 16), and the relationship between the two tables is not configured with Cascade Delete Related Records. Note from the Author or Editor: |
jeffstraw | Mar 06, 2012 | ||
Printed | Page 309 1st paragraph |
port should be report Note from the Author or Editor: |
Len Pacer | Jan 05, 2013 | |
Printed | Page 320 Scientific format paragraph |
When it explains 4.80E+01, it is 4.8 multiplied by 10, not by 101 as it says. Note from the Author or Editor: |
Diego Pi | Aug 19, 2010 | Aug 12, 2011 |
Printed | Page 404 1st paragraph, 2nd row |
is: "you created advanced reports in Chapter 12" should be: "you created advanced reports in Chapter 11" Note from the Author or Editor: |
Anonymous | Aug 15, 2012 | |
Printed | Page 431 5th paragraph |
Omitted reference to material appearing later in book. "(tasks you'll tackle in )". Note from the Author or Editor: |
Anonymous | Aug 16, 2010 | Aug 12, 2011 |
Printed | Page 435 United States |
Last line on the page reads: "..... and the child field's ProductID (in the..." --> next page "ProductID" should be "ProductCategoryID" Note from the Author or Editor: |
John Cellini | Feb 07, 2012 | |
Printed | Page 468 1st paragraph, line 3 |
replace last word, 'to', by 'from' Note from the Author or Editor: |
Mayo Marriott | Nov 11, 2011 | Dec 02, 2011 |
Printed | Page 469 last paragraph |
When you 'try this example for yourself', it is not quite right. Specifically, it is fine for the first customer. But if you go back to the TotalsByCustomer report and click on another Customer Id, then nothing changes in the CustomerPurchases report. Note from the Author or Editor: |
Mayo Marriott | Nov 11, 2011 | Dec 02, 2011 |
Printed | Page 515 Bottom line of page |
IsNull([Email]) should be IsNull([EmailAddress]) Note from the Author or Editor: |
Crimson Meerkat | Aug 18, 2010 | Aug 12, 2011 |
Printed | Page 571 Power Users Clinic |
Book reads: "Or, you could build a table validation rule like this: Area(LengthOfRoom * WidthOfRoom) < 1000" Shouldn't it read: Area(LengthOfRoom,WidthOfRoom < 1000? Note from the Author or Editor: |
Dave Hoder | Apr 28, 2011 | Aug 12, 2011 |
Printed | Page 580 Note: |
Last word of the 'Note:' should be 'chapter.' Note from the Author or Editor: |
Mayo Marriott | Dec 11, 2011 | |
Printed | Page 626 United States |
In the Power User Clinic, the one-to-one relationship has not been given the page number (XX). Note from the Author or Editor: |
Christopher Ried | Mar 17, 2012 | |
Printed | Page 642 "Some types of information....." para. Second sentence |
"Of," should read "Of course," PS Great book Note from the Author or Editor: |
David Price | Dec 02, 2012 | |
Page 717 Last paragraph in the Sidebar |
The hyperlink for this URL (http://tinyurl.com/34sy7hc) does not function correctly when clicking on it from within the PDF. Note from the Author or Editor: |
karenshaner | Jun 24, 2010 | ||
Page 722 1st bullet point in Sidebar |
The link mentioned in this graph (http://tinyurl.com/2pegsc) is not working when you try to click it from within the PDF. Note from the Author or Editor: |
karenshaner | Jun 24, 2010 |