Errata

Print Print Icon

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. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "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



Version Location Description Submitted By Corrected
Printed Page 000
missing CD web page

the URL link for "VBA (Visual Basic for Applications) reference" is broken

 Anonymous 
Other Digital Version 1
Actually, it's in the Errata

The errata page says "Access 2007: The Mssing Manual"--the word "Missing" is misspelled!

Actually, it's kind of funny that this should appear in the errata!

 Anonymous 
Printed Page 16
Figure 1 - 10

Reads; When you're designing a form.....

Should be: When you're designing a table...

Note from the Author or Editor:
"When you're designing a form" should be "When you're designing a table"

 Anonymous  Apr 2009
Printed Page 59

Under the "word to the wise" section, the last sentence
"if you suspect trouble, switch to Design View,..." should be "switch to Datasheet View"

 Anonymous 
Printed Page 82

"All you'll see in this book, you can easily filter out the information you don't need from the
datasheet..."
should read
"As you'll see in this book,..."

 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:
1. blank (empty) values
2. space
3. special characters
4. numbers
5. letters

Note from the Author or Editor:
The correct list has the last two items reversed. It should be:
1. Blank (empty) values
2. Space
3. Special characters (like punctuation)
4. Numbers
5. Letters

Type of error

 Anonymous  Apr 2009
Printed Page 102
penultimate line

Should be:
1. Choose Home --> Find --> Find

(not Choose Home --> Sort & Filter --> Find)

[at least that's how it is on my system)

 Anonymous  Dec 2008
Printed Page 109
figure 3-18

In the Replace box, "PEDS" should be "PESDS," to agree with the caption.

 Anonymous  Apr 2009
Printed Page 123
figure 3-18

Paragraph beginning "You can also...":

Insert the word "set" as follows:

"In this case, you should set Ignore Nulls to Yes."

 Anonymous  Dec 2008
Printed Page 127
figure 4-12

Change "chosen" to "stored" as follows (?):

The final step lets you choose how the data in your field is stored--with or without the mask symbols.

 Anonymous  Dec 2008
Printed Page 153
last paragraph:

p.153 last paragraph: 8. To define your relation ship ... (parent and
child should be switched, you drag the field from the child table to
parent table, not the other way round)

Note from the Author or Editor:
(153) step number 8,
"find the field you're using in the parent table" shoud be "find the field you're using in the child table"
and "to link it to in the child table" should be "to link it to in the parent table"

 Anonymous  Apr 2009
Printed Page 164
figure 5-12

Delete the last sentence ("One links students...") from the figure legend.

 Anonymous  Dec 2008
Printed Page 165
middle

Change "design" to "datasheet" (?) in:

"Now, if you switch to the design view..."-->

"Now, if you switch to the datasheet view..."

 Anonymous  Dec 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 
Printed Page 187
figure 6-3

Add phrase before "drag the gray bar" as follows:

"To reorder your columns, select the column and then drag the gray bar..."

 Anonymous  Dec 2008
Printed Page 192
Tip

page 119 should be page 229 (?)

 Anonymous  Dec 2008
Printed Page 206
Note

Change "classes" and "instructors" to "orders" and "customers," as in:

"you end up with: a list of orders or a list of customers"

 Anonymous  Dec 2008
Printed Page 302
note

cross-ref to page 206 should be to page 306

 Anonymous 
Printed Page 302
note

cross-ref to page 206 should be to page 306

 Anonymous  Dec 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  Dec 2008
Printed Page 396
bottom of table

opposite "Page Break," change "usfe" to "use"

 Anonymous 
Printed Page 396
bottom of table

opposite "Page Break," change "usfe" to "use"

 Anonymous  Dec 2008
PDF Page 396
within table under 'Bound Object Frame'

Erroneous repeat of 'with an attachment control':

"using an attachment field with an attachment control (page 72), with an attachment control,"

Note from the Author or Editor:
"using an attachment field with an attachment control (page 72), with an attachment control, which is designed"
should be
"using an attachment field with an attachment control (page 72), which is designed"

 Anonymous  Apr 2009
Printed Page 487
penultimate paragraph

In the sentence that begins "The only drawback's...": Insert "you" between "doesn't let set"

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

OR

the less-than signs in the next line should be greater-than signs.

 Anonymous  Dec 2008
Printed Page 492
last paragraph, 2nd sentence

"The number 4 tells Access TO THAT the Message box..."

delete "to"

Anonymous 
PDF Page 575
'Troubleshooting moment'

"WITH the .laccdb file, Access has no way to coordinate multiple
users." should read "WITHOUT..."

Note from the Author or Editor:
"with the .laccdb file, Access has no way to coordinate multiple users" should be
"without the .laccdb file, Access has no way to coordinate multiple users"

 Anonymous  Apr 2009
Printed Page 593
last sentence before Note

"That means that as long as..." (not "as along as...")

 Anonymous 
Printed Page 597

The heading “Case for Importing and Exporting” should read “The Case for Importing and Exporting”.

 Anonymous 

See larger cover

"One of the beauties of the Missing Manuals is that there is always something new to discover and the research is quite thorough...I kept finding snippets of information, in the way of Tips or Notes, that would give just that bit extra."
--Graham K. Rogers, Bangkok Post