Errata

Access 2007: The Missing Manual

Errata for Access 2007: The Missing Manual

Submit your own errata for this product.

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).
should say:
Tip: You can drag the other way, too (from the parent to the child).

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.

If you are considering the universe of life forms then the set of values is something like { None, Male, Female, Both, Unknown, Null } since single celled organisms have no sex while some simple organisms like earthworms are both male and female.

If you are surveying a group of people then the set is more likely to be { Male, Female, Inter-sex, Withheld, Null }.


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.

Either change the header or the data in the table.

Patti Laird  Nov 16, 2011 
Printed Page 114
first paragraph

"... you might assume that there's not much you can do customize ..."

is missing the word "to," which should be inserted as follows:

"... you might assume that there's not much you can do to customize ..."

 Anonymous  Dec 29, 2015 
Printed Page 123
1st

Hi,

I'm working my way through this book, and I'm trying to set up a Multi-field Index as shown in the book. But in Figure 4-7 you show a Yes/No drop down next to the Primary/Unique and Ignore Nulls fields. But I don't have them showing on my screen.

(I'd include a screen print if I could)

I'm running Win 7 Pro and Office 2007 Pro.

 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.

Text on line 28: "If you use the number 0, then Access stores the full text with literals."

Example given: "(000) 000-0000;1;# Here, the second section's 1, and the third section's #. This mask's for phone numbers, and it stores literals ( in this case two parentheses, a space, and a dash ) and uses the number sign for a place holder instead of the underscore."

 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:
"If you leave it blank, then Access accepts [it] without any checks."

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.

For instance I have two tables, an Invoice table (child) and a Vendor table (parent). One of my the fields in my Invoice table is "Vendor_Name." I know want to create a Lookup as defined on the pages noted above.

1. I open the Invoice table in Design View.
2. I select the Vendor_Name field in the Data Type column
3. From the Design tab --> Tools --> the Lookup Column is selected
4. Access inserts another row for another column.
5. Cannot use the same name as suggested in step 8 on page 165

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

1) design's only problem ...... is correct

2) it's more difficult....... is correct

3) design's only problem's that it's .......is gramatically incorrect. It should read "design's only problem is that it's more difficult"


The author repeatedly uses 's after a noun (problem's) to mean "is". It appears so often that it
is hugely distracting. I have counted at least 10 times and I am only on page 203.


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.

I am VERY new to learning about databases and am heavily relying on your book at work to learn Access 2007. So, far, your book has taught me TONS more than the class book I received from taking a class. And while this error cost me a lot of time, I figured it out!!! And, I learned in the process which was/is my goal. However, please post this change to save others the time I lost. Thanks!

 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.

I have followed the instructions on the download page for the TransferNames query. I have followed the directions and examples in the book. My query design looks exactly like the sample in the book.

What am I doing wrong?

Thank you for your prompt attention to this inquiry.

 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.
The sub DoUpdate (into Missing CD) for example is called UpdateStock in the book.

Besides this, I think the sub DoUpdate must be the first row code into Sub Ship_Clik to work properly, but, on Missing CD, this sub is into Sub ProcessOrder_Click.

Best regards.

Ronan.

 Anonymous  Jul 17, 2011