Errata for Access 2007: The Missing Manual

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

W should be Q: (for example, W moves your data to SQL Server) should be: (for example, Q moves your data to SQL Server)

even attempt do anything vs. even attempt to do anything

The date is listed as year-day-month (2008-23-2) but it is called "the international year-month-day standard"

Note from the Author or Editor:
2008-23-2 should be 2008-2-23 in first bullet point on page 67; may already be corrected in current printings.

Says "Every table must have a primary key." Access doesn't require that a table have a primary key, so "must" is a bit strong. Certainly every Access table should have a primary key by the time a database designer is done, but the lack of a primary key requirement is helpful at times early in the design process.

Note from the Author or Editor:
change "must have" to "should have", although this change may have been made already

The described procedure (using "drag the mouse to select more than one field") implies that only adjacent fields can be joined to create a composite primary key. Using the Ctrl key to multi-select fields (and keeping it pressed while right-clicking), you can also select non-adjacent fields.

Note from the Author or Editor:
replace "First, click the margin next to the field name, and then drag the mouse to select more than one field. Then, hold down Shift, and then right-click your selection." with "Hold down the Ctrl key, and click each field you want to include, one after the other. Then, while holding down Ctrl, right-click your selection."

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

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

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

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

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

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

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

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

Says "a field," should say "an index.": "... which means Access doesn't create [an index]."

Paragraph beginning "You can also...": Insert the word "set" as follows: "In this case, you should set Ignore Nulls to Yes."

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"

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

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

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

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:
p. 185 "which is a piece text" should be "which is a piece of text"

The second line of the bulleted text begins "which is a piece text". This should this read "which is a piece of text..."

page 119 should be page 229 (?)

The cited page number should be 229, not 119.

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.

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.

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

Might specify that [CustomerState] would go in the Criteria Box

Note from the Author or Editor:
p. 241, "add the following filter condition to the State field" should be "add the following filter condition to the Criteria box for the State field"

"In (14,15,18)" This filter expression matches any records that have ID values 14,15, or 16. it should read "14,15,18"

Note from the Author or Editor:
p. 261, second paragraph, "values of 14, 15, or 16" should be "values of 14, 15, or 18"

cross-ref to page 206 should be to page 306

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

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"

It references Figure 13-9 here. In fact, it's supposed to be Figure 13-8.

Note from the Author or Editor:
p. 404, paragraph under step 2, reference to Figure 13-9 should be 13-10

The line beneath bold line in step 2, says: "...choose the Format Operations category" "Format" should be change to just "Form"

Note from the Author or Editor:
p. 444, step 2, "choose the Format Operations" should be "choose the Form Operations"

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

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

"The number 4 tells Access TO THAT the Message box..." delete "to" (or add text, if something is missing)

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

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

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

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