Errata for Access 2007 for Starters: The Missing Manual

"...you're reading to move on ..." should be "...you're ready to move on ..."

"When you're designing a form, ..." change to: "When you're designing a table,..."

"...Ed's Roadside Dinner..." "Dinner"-->"Diner"

"... then click OK." Figure 1-3 doesn't show an "OK" choice to click. Might be clearer to move figure reference to the point above, so step #3 reads "Choose a folder (Figure 1-3)" and remove it from section below.

"... jump from a list of products to a list of customers..." Figure 1-4 doesn't show either Products or Customers. Might be clearer to reword second sentence from "You can use the ?" to "For example, you can use the ?"

"...Once you move to the next cell, change is applied." qualify "change" with "your change" .

Replace "you probably need two" with "you probably need two or three"

Replace "a single Name field" with "a single ContactName field"

At end of second sentence in Tip box, add "on a scrap piece of paper."

In first sentence of sidebar, change "The search feature" to "The Find feature"

The description of how to connect the two tables is the opposite of the header for this item. The header says drag from parent to child ... the example drags from child to parent. RESPONSE: This is technically true, but the steps cited are still correct and it doesn't warrant replacing the figure. Consider updating the figure next edition.

"Once this record's removed, you're left with ..." change to: "If this record were removed, you'd be left with ..."

"... Access gives you two ways ..." It appears that multivalue fields are not included in the For Starters edition. If this is the case, change "and Access gives you two ways to deal with them" to "and you can use junction tables to deal with them"

"... using a multi-value lookup field ..." A multi-value lookup field hides the one-to-many relationship that exists. While this might make working in a table easier, it makes working with the data more difficult. Remove the Note box. I don't think this is discussed in the example (and multivalue fields aren't described in the book anyway).

"The best starting point for query creation..." Change to "The best starting point for creating most queries is Design View."

"that" s/b "than"

Note from the Author or Editor:
p. 221 "more often that you round down" should be "more often than you round down"

"... that pulls columns from two tables ..." change to: "... that pulls columns from two or more tables ..."

In note box, change "many tables share a common ID field" to "many tables have a field named ID, but these fields aren't related in any way." Change "just remove it before adding the join you really want" to "just click to select it and press the Delete key to remove it."

Change "Any orders that aren't linked to a customer record appear at the bottom of the list, and have ?" to "Any orders that aren't linked to a customer record have ?"

In figure caption, change "This query shows two fields straight from the database (ID and Name), and adds ?" to "This query shows the ProductName field straight from the database and adds ?"

Change "the new date becomes" to "the ExtendedDeadline date becomes"

Change "However, you can join text together " to "However, you can join text together using a process called concatenation."

Change "UpdateProductPrices" to "RaiseProductPrices"

"If you used the asterisk (*), you'll see the full information for each record." Replace "the full information" with "all the fields"

"Ordinary printouts are ..." change to: "Ordinary datasheet printouts..."

Change "heavy-duty filtering or sorting" to "heavy-duty filtering" and at the end of the first paragraph add "However, the sort order you use in the query won't affect the order of records in your report."

"... and rear- range..." change to: "... and re- arrange..."

"After you've closed your report..." change to: "If you've closed your report..."

Replace the bottom paragraph on page 303 with this corrected text "Initially, the records in a report have the same order as the underlying table. Typically, this means the records appear in the order you added them. Reports ignore any sorting that you've applied to the table in Datasheet View." On the next page, change "Either way, you can apply formatting" to "You can apply sorting"

In Figure 9-4 caption, change "form" to "report"

"... choose the table you want to use." change to: "... choose the table (or query) you want to use."

"...then click the > button..." change to: "... then click the > button (or double-click the field)..."

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

Change "because it involves" to "because it often involves"

"The original copy always remains..." change to: "The original always remains..."

Remove sentence "However, it works only if you're copying a complete table (or other object), not a selection of rows."

"...to create random field names..." change to: "... to create arbitrary field names..."