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 000 missing CD web page |
the URL link for "VBA (Visual Basic for Applications) reference" is broken |
Anonymous | ||
Printed | Page 9 figure 1-4, in figure and text 2nd half |
W should be Q: |
Heer Henk | Jan 11, 2009 | |
Printed | Page 16 Figure 1 - 10 |
Reads; When you're designing a form..... Note from the Author or Editor: |
Anonymous | Feb 26, 2009 | Apr 01, 2009 |
Printed | Page 42 4th line from bottom |
even attempt do anything vs. even attempt to do anything |
Anonymous | Apr 01, 2009 | |
Printed | Page 59 |
Under the "word to the wise" section, the last sentence |
Anonymous | Apr 01, 2009 | |
Printed | Page 67 Bottom of the page, first bullet |
The date is listed as year-day-month (2008-23-2) but it is called "the international year-month-day Note from the Author or Editor: |
Anonymous | ||
Printed | Page 77 Next-to-last paragraph |
Says "Every table must have a primary key." Access doesn't require that a table have a primary key, so Note from the Author or Editor: |
Anonymous | ||
Printed | Page 79 Note in middle of page |
The described procedure (using "drag the mouse to select more than one field") implies that only adjacent Note from the Author or Editor: |
Anonymous | ||
Printed | Page 79 Second paragraph, last sentence |
should be "is more work tha[n] is seems" |
Anonymous | Apr 01, 2009 | |
Printed | Page 82 |
"All you'll see in this book, you can easily filter out the information you don't need from the |
Anonymous | Apr 01, 2009 | |
Printed | Page 89 2nd paragraph under heading - Rearranging Columns, 3rd sentence |
Sentence begins "From right to left". It should be "From left to right". |
John Pursell | Jun 09, 2009 | Sep 01, 2009 |
Printed | Page 93 3rd paragraph |
The sentence states "Frozen columns must always be positioned at the left size of the datasheet." It seems |
Anonymous | Apr 01, 2009 | |
Printed | Page 96 1st paragraph |
Says "In an unsorted table, records are ordered according to when they were created, so that the oldest Note from the Author or Editor: |
Anonymous | ||
Printed | Page 96 end of "Up to Speed" |
I tried the sorting mentioned in the "Up to Speed" and #'s always sorted before letters in my attempts. If I am correct, the list should read: Note from the Author or Editor: |
Anonymous | Nov 28, 2008 | Apr 01, 2009 |
Printed | Page 98 1st sentence |
Missing word (likely "a"): "In order to filter records, you specify a condition that [missing word here] |
Anonymous | Apr 01, 2009 | |
Printed | Page 102 penultimate line |
Should be: |
Anonymous | Jun 02, 2008 | Dec 01, 2008 |
Printed | Page 102 Step 1 at bottom of page |
Says "Choose Home --> Sort and Filter --> Find". Should be "Choose Home --> Find --> Find." |
Anonymous | Apr 01, 2009 | |
Printed | Page 109 figure 3-18 |
In the Replace box, "PEDS" should be "PESDS," to agree with the caption. |
Anonymous | Jun 02, 2008 | Apr 01, 2009 |
Printed | Page 109 figure 3-18 |
In the Replace box, "PEDS" should be "PESDS," to agree with the caption. |
Anonymous | Apr 01, 2009 | |
Printed | Page 121 First sentence, continuing from p. 120 |
Says "a field," should say "an index.": "... which means Access doesn't create [an index]." |
Anonymous | Apr 01, 2009 | |
Printed | Page 123 figure 3-18 |
Paragraph beginning "You can also...": |
Anonymous | Jun 02, 2008 | Dec 01, 2008 |
Printed | Page 123 top of page |
Paragraph beginning "You can also...": |
Anonymous | Apr 01, 2009 | |
Printed | Page 127 figure 4-12 |
Change "chosen" to "stored" as follows (?): |
Anonymous | Jun 02, 2008 | Dec 01, 2008 |
Printed | Page 127 figure 4-12 |
Change "chosen" to "stored" as follows (?): |
Anonymous | Apr 01, 2009 | |
Printed | Page 153 last paragraph: |
p.153 last paragraph: 8. To define your relation ship ... (parent and Note from the Author or Editor: |
Anonymous | Mar 30, 2009 | Apr 01, 2009 |
Printed | Page 164 figure 5-12 |
Delete the last sentence ("One links students...") from the figure legend. |
Anonymous | Jun 02, 2008 | Dec 01, 2008 |
Printed | Page 164 figure 5-12 |
Delete the last sentence ("One links students...") from the figure legend. |
Anonymous | Apr 01, 2009 | |
Printed | Page 165 middle |
Change "design" to "datasheet" (?) in: |
Anonymous | Jun 02, 2008 | Dec 01, 2008 |
Printed | Page 165 Sentence above Figure 5-14 |
Says "if you switch to the design view of the Dolls table..." Should say "if you switch to the datasheet |
Anonymous | Apr 01, 2009 | |
Printed | Page 185 Top third of page, second bullet |
The second line of the bulleted text begins "which is a piece text". Should this read "which is a piece of text..."? Note from the Author or Editor: |
Anonymous | May 23, 2008 | |
Printed | Page 185 Top third of page, second bullet |
The second line of the bulleted text begins "which is a piece text". This should this read "which is a piece of text..." |
Anonymous | Apr 01, 2009 | |
Printed | Page 187 figure 6-3 |
Add phrase before "drag the gray bar" as follows: |
Anonymous | Jun 02, 2008 | Dec 01, 2008 |
Printed | Page 187 figure 6-3 |
Add phrase before "drag the gray bar" as follows: |
Anonymous | Apr 01, 2009 | |
Printed | Page 192 Tip |
page 119 should be page 229 (?) |
Anonymous | Jun 02, 2008 | Dec 01, 2008 |
Printed | Page 192 In Tip:, 3rd paragraph from bottom |
The cited page number should be 229, not 119. |
Anonymous | Apr 01, 2009 | |
Printed | Page 198 In Note:, 3rd paragraph from bottom |
Misspelled word(s): in the second set of parentheses, "SQL Server" is incorrectly spelled "SQL Sever." |
Anonymous | Apr 01, 2009 | |
Printed | Page 206 Note |
Change "classes" and "instructors" to "orders" and "customers," as in: |
Anonymous | Jun 02, 2008 | Dec 01, 2008 |
Printed | Page 206 "Note:" section |
It is printed, "... then what do you end up with: a list of classes or a list of instructors?" This should |
Anonymous | Apr 01, 2009 | |
Printed | Page 230 In POWER USERS' CLINIC |
The first right parenthesis in the example formula is in the wrong place - it's too far to the right, and |
Anonymous | Apr 01, 2009 | |
Printed | Page 231 1st paragraph in WORD TO THE WISE |
Misspelled word - says "... for you date field," should be "... for your date field." |
Anonymous | Apr 01, 2009 | |
Printed | Page 233 Bottom of page |
The formula should include a space: [FirstName] & " " & [LastName], ... |
Anonymous | Apr 01, 2009 | |
Printed | Page 241 point 5, first paragraph |
Might specify that [CustomerState] would go in the Criteria Box Note from the Author or Editor: |
Anonymous | Jun 02, 2008 | |
Printed | Page 261 2nd paragraph |
"In (14,15,18)" Note from the Author or Editor: |
George Kanakis | Sep 12, 2009 | |
Printed | Page 266 In the Summary Smackdown Box |
In the first bullet, it states that one should use a totals query if grouping with one field. It then points to the top of Figure 9-1 as an example. Figure 9-1 in fact shows 2 levels of grouping, not one. Note from the Author or Editor: |
Anonymous | Aug 16, 2009 | |
Printed | Page 272 Last Paragraph |
The sentence: "Although the Crosstab wizard limits you to three fields for row grouping, you can actually add a virtually unlimited number of fields for COLUMN grouping." Note from the Author or Editor: |
GoodyKags | Apr 01, 2009 | |
Printed | Page 302 note |
cross-ref to page 206 should be to page 306 |
Anonymous | Jun 02, 2008 | Dec 01, 2008 |
Printed | Page 310-318 throughout the pages |
When indicating the ribbon commands for formatting reports, the book consistently identifies "Report Layout Tools | Format" incorrectly as "Report Layout Tools | Formatting." The correct ribbon section name is Format not Formatting. Note from the Author or Editor: |
Anonymous | Dec 29, 2009 | |
Printed | Page 355 United States Figuse 11-27 |
It would appear that what is titled "Order Total:" is in acuality the total of the unit prices of the items ordered, a relatively meaningless number. The total of the extended prices ($398.99) does not appear. Note from the Author or Editor: |
Anonymous | Jan 17, 2010 | |
Printed | Page 379 under point 2 |
"top-right corner" might actually be "top-left corner" (that's where it is on my system) |
Anonymous | Jun 02, 2008 | Dec 01, 2008 |
Printed | Page 379 under point 2 |
"top-right corner" might actually be "top-left corner" (that's where it is on my system) |
Anonymous | Apr 01, 2009 | |
Printed | Page 396 bottom of table |
opposite "Page Break," change "usfe" to "use" |
Anonymous | Jun 02, 2008 | Dec 01, 2008 |
Page 396 within table under 'Bound Object Frame' |
Erroneous repeat of 'with an attachment control': Note from the Author or Editor: |
Anonymous | Nov 06, 2008 | Apr 01, 2009 | |
Printed | Page 404 In the second step paragraph |
It references Figure 13-9 here. In fact, it's supposed to be Figure 13-8. Note from the Author or Editor: |
Anonymous | Aug 03, 2009 | |
Printed | Page 444 Step 2 |
The line beneath bold line in step 2, says: Note from the Author or Editor: |
Michael Duplantier | Aug 21, 2009 | |
Printed | Page 487 penultimate paragraph |
In the sentence that begins "The only drawback's...": Insert "you" (or similar) between "doesn't let set" |
Anonymous | Jun 03, 2008 | Apr 01, 2009 |
Printed | Page 487 penultimate paragraph |
In the sentence that begins "The only drawback's...": Insert "you" between "doesn't let set" |
Anonymous | Apr 01, 2009 | |
Printed | Page 489 paragarph that starts "_And_ enforces two conditions" |
Unless I'm completely mixed up, either the last line of that paragraph should read "...the FirstName and the LastName fields are SHORTER than three characters a piece" |
Anonymous | Jun 03, 2008 | Dec 01, 2008 |
Printed | Page 492 last paragraph, 2nd sentence |
"The number 4 tells Access TO THAT the Message box..." |
Anonymous | Jun 03, 2008 | Apr 01, 2009 |
Printed | Page 492 last paragraph, 2nd sentence |
"The number 4 tells Access TO THAT the Message box..." |
Anonymous | Apr 01, 2009 | |
Printed | Page 518 After 1st paragraph |
In the example that shows how to write a code in the case of 'Esc' being pressed, the following event is missing "Cancel As Integer" in the parenthesis. (Although it is included in the download-able examples.) Note from the Author or Editor: |
Anonymous | Jan 05, 2010 | |
Page 575 'Troubleshooting moment' |
"WITH the .laccdb file, Access has no way to coordinate multiple Note from the Author or Editor: |
Anonymous | Nov 13, 2008 | Apr 01, 2009 | |
Printed | Page 593 Note near middle of page, the paragraph above it, and the next-to-last bullet on the page |
The Note says, in part, "In order to successfully use a password with a back-end database, you must apply Note from the Author or Editor: |
Anonymous | ||
Printed | Page 593 last sentence before Note |
"That means that as long as..." (not "as along as...") |
Anonymous | Jun 08, 2008 | Apr 01, 2009 |
Printed | Page 593 last sentence before Note |
"That means that as long as..." (not "as along as...") |
Anonymous | Apr 01, 2009 | |
Printed | Page 597 |
The heading ?Case for Importing and Exporting? should read ?The Case for Importing and Exporting?. |
Anonymous | Apr 01, 2009 |