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 
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 42
4th line from bottom

even attempt do anything vs. even attempt to do anything

Anonymous 
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 79
Second paragraph, last sentence

should be "is more work tha[n] is seems"

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 89
2nd paragraph under heading - Rearranging Columns, 3rd sentence

Sentence begins "From right to left". It should be "From left to right".

John Pursell 
Printed Page 93
3rd paragraph

The sentence states "Frozen columns must always be positioned at the left size of the datasheet." It seems
like it should say "Frozen columns must always be positioned at the left SIDE of the datasheet."

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 98
1st sentence

Missing word (likely "a"): "In order to filter records, you specify a condition that [missing word here]
record must meet ..."

Anonymous 
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 102
Step 1 at bottom of page

Says "Choose Home --> Sort and Filter --> Find". Should be "Choose Home --> Find --> Find."

Anonymous 
Printed Page 109
figure 3-18

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

Anonymous  Apr 2009
Printed Page 109
figure 3-18

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

Anonymous 
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 
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 123
top of page

Paragraph beginning "You can also...":

Insert the word "set" as follows:

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

Anonymous 
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 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 
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 164
figure 5-12

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

Anonymous 
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 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
view of the Dolls table..."

Anonymous 
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 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 
Printed Page 192
Tip

page 119 should be page 229 (?)

Anonymous  Dec 2008
Printed Page 192
In Tip:, 3rd paragraph from bottom

The cited page number should be 229, not 119.

Anonymous 
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."
Also, just prior to that, the word "name" should probably be either "named" or it should be deleted.

Anonymous 
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 206
"Note:" section

It is printed, "... then what do you end up with: a list of classes or a list of instructors?" This should
be, "...then what do you end up with: a list of orders or a list of customers?" You had mixed up the
school example.

Anonymous 
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
the result appears as an error in Access. The formula should be

FirstWordProduct: Left([ProductName],InStr([ProductName]," ")-1)

(Minor point: The "S" should be capitalized in the middle of "InStr" too - it's incorrectly shown as
"Instr" in at least nine places in the POWER USERS' CLINIC block.)

Anonymous 
Printed Page 231
1st paragraph in WORD TO THE WISE

Misspelled word - says "... for you date field," should be "... for your date field."

Anonymous 
Printed Page 233
Bottom of page

The formula should include a space: [FirstName] & " " & [LastName], ...

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 379
under point 2

"top-right corner" might actually be "top-left corner" (that's where it is on my system)

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" (or similar) between "doesn't let set"

Anonymous 
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" (or add text, if something is missing)

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


"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