Errata
The errata list is a list of errors and their corrections that were found after the product was released.
The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.
Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update
Version | Location | Description | Submitted by | Date submitted |
---|---|---|---|---|
Printed | Page 47 first paragraph, line 4 |
home should be hone |
alan schuster | Feb 27, 2012 |
Printed | Page 54 Tip at top of page |
Tip: You can drag the other way, too (from the child to the parent). |
Anonymous | Aug 10, 2010 |
Printed | Page 56 pp 56-77 |
In discussion of data types, Lookup Wizard (multi-value fields) not discussed, although it shows in the screen grab from the table design form. |
Anonymous | Aug 03, 2010 |
Printed | Page 58 Table 2.1 Data Type Yes/No |
The example of male/female is a serious failure in the partitioning the universe of genders. |
Anonymous | Jul 31, 2010 |
Printed | Page 70 Table 2-4, third column header |
"(for the Date January 1, 2008)" does not match what's in the table. In the table, the d and dd codes show the day of the month as 7, not 1. |
Patti Laird | Nov 16, 2011 |
Printed | Page 114 first paragraph |
"... you might assume that there's not much you can do customize ..." |
Anonymous | Dec 29, 2015 |
Printed | Page 123 1st |
Hi, |
Kelvin Clements | Jun 28, 2012 |
Printed | Page 127, 129 Figure 4-11(pg 127) and 1st sentence of 1st paragraph of pg 129 |
The phone number mask is !(999) 000-000 and should be !(999) 000-0000. |
Brian Malcom | Mar 17, 2011 |
Printed | Page 130 Last sentence |
I think you need to add a sentence about what the "1" means in the given mask; e.g., "and 1 means the data is stored without the literals." |
Patti Laird | Nov 17, 2011 |
Printed | Page 130 3,5 & 6 |
There seems to be contradiction in whether to use the 1 or the 0 to to store the literals. |
jw.prof.cntrng@gmail.com | Feb 20, 2012 |
Printed | Page 130 3rd |
You state that this is a British or Canadian postal code, Being British I can say its wrong, post code here are either xx9 9xx or xx99 9xx so the mask should be LL09 0LL. |
Kelvin Clements | Jun 28, 2012 |
Printed | Page 133 Note at bottom of page |
"if" should be "it" in second sentence: |
Patti Laird | Nov 17, 2011 |
Printed | Page 147 3rd bulleted paragraph |
"Your family may not see you for several few weeks." should read "Your family may not see you for several weeks." |
Anonymous | Dec 21, 2010 |
Printed | Page 163-165 |
When following the text in your Access 2007 manual from page 163 to 165, Access wants to insert a new data column. |
Stanley Pearse | Jan 03, 2011 |
Printed | Page 195 1st sentense in the box "How Indexes Speed Up Searches" |
"In Chapter 2 (page 121)..." should read "In Chapter 4 (page 121)..." |
Sam Lin | Dec 27, 2011 |
Printed | Page 202 text paragraph |
Cross-ref ("See page 568...") might also include pages 166-7. |
Anonymous | Jun 02, 2008 |
Printed | Page 203 1st paragraph |
"This sort of design's only problem's that it's more difficult...." |
Anonymous | Nov 11, 2010 |
Printed | Page 209 Top of page. First full paragraph, first word of second sentence. |
Sentence reads: "Your start with an inner join..." Should read: "You start with an inner join..." |
Anonymous | Aug 17, 2011 |
Printed | Page 227 Gem in the Rough |
Using the Rnd() function per the text does not create a random sort. Instead the random values will all be the same since Access calls Rnd() only once and uses the same result for all the examples when Rnd() is called for every record. To get a different random number for every record use another field such as the ID autonumber field as an argument to Rnd(). You can use the field expression Random: Rnd(ID) |
ponchy | Aug 09, 2010 |
Printed | Page 233 Bottom of page |
The syntax is incorrect for the example. Since the new field includes a concatenation while trying to propagate null values, the & sign will not work, it needs to the + sign. |
Barbara Pape | Jun 03, 2010 |
Printed | Page 252 Creating An Append (or Make-Table) Query |
The append query beginning on page 252 through page 254 does not give me any results. I downloaded both the Marketing and the Sales databases to my computer. When I check these, neither of them contain any information. I have downloaded them 3 different times to be sure I have the files. No data present in either database on any of the downloads. |
Howard M. Williams | Sep 30, 2011 |
Printed | Page 318 7th line from the bottom |
The 4th sentence under step five reads "Excel will display..." when it should read "Access will display..." |
Anonymous | Jul 20, 2010 |
Printed | Page 335 Step 6 |
The layout options listed in the book do not correspond to what I see in Access 2007. On my computer, the options are Stepped, Block, and Outline. The book lists Columnar, Tabular, and Justified. |
ABM | Mar 16, 2012 |
Printed | Page 364 3rd Paragraph - TIP |
In this tip You write that to select more than one part of a form at once, hold down Ctrl while you click.... which is what I would call the Microsoft standard. Curiously on my computer ... Ctrl does not work for this function but Shift is .... I checked in Excel and Ctrl works for discontinued selection and Shift for continuous ones. |
Anonymous | Feb 02, 2011 |
Printed | Page 458 2nd to last paragraph |
"or" should be "of" in the sentence "Every macro's made up or a sequence of one or more steps, or actions." |
Anonymous | Mar 27, 2013 |
Printed | Page 557 Sub ProcessOrder_Click and Sub Ship_Click |
The codes of Sub ProcessOrder_Click presented into Missing CD are diferent from the codes presented in the book. |
Anonymous | Jul 17, 2011 |