Errata

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

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"

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

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

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"

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

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"

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

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

delete "to" (or add text, if something is missing)

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

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

cross-ref to page 206 should be to page 306

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"

page 119 should be page 229 (?)

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

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

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 URL link for "VBA (Visual Basic for Applications) reference" is broken

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

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

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

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

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.

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

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". This should this read "which is a piece of text..."

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

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"

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