Access 2007 For Starters: The Missing Manual by Matthew MacDonald This errata page lists errors outstanding in the most recent printing. If you have technical questions or error reports, you can send them to booktech@oreilly.com. Please specify the printing date of your copy. This page was updated April 26, 2007. Here's a key to the markup: [page-number]: serious technical mistake {page-number}: minor technical mistake : important language/formatting problem (page-number): language change or minor formatting problem ?page-number?: reader question or request for clarification Confirmed errors: (3) last paragraph, first sentence; "...you're reading to move on ..." should be "...you're ready to move on ..." (17) Figure 1-10 caption; "When you're designing a form, ..." change to: "When you're designing a table,..." (25) 1st paragraph, 3rd line; "...Ed's Roadside Dinner..." "Dinner"-->"Diner" (30) Section # 3, last sentence; "... 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. (32) Figure 1-4 caption, second sentence; "... 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 ?" (42) Table 1-2, Key = Esc, second sentence; "...Once you move to the next cell, change is applied." qualify "change" with "your change" . (66) Note (at top); Replace "you probably need two" with "you probably need two or three" (94) Section 2, first paragraph; Replace "a single Name field" with "a single ContactName field" [97] Last paragraph; Replace "It's relatively uncommon for two customers to share the same address" with "Most customers have separate addresses" (98) Tip (at top); At end of second sentence in Tip box, add "on a scrap piece of paper." (123) First sentence in "Find and Replace" section; In first sentence of sidebar, change "The search feature" to "The Find feature" (177) #8; 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. (181) second bullet point; "Once this record's removed, you're left with ..." change to: "If this record were removed, you'd be left with ..." (196) second sentence; "... 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" (199) Note section, first line; "... 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). (214) first sentence in first paragraph under Creating a Query in Design View; "The best starting point for query creation..." Change to "The best starting point for creating most queries is Design View." (229) 2nd paragraph under Queries and Related Tables; "... that pulls columns from two tables ..." change to: "... that pulls columns from two or more tables ..." (232) Note section; 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." (236) first full paragraph, second sentence; 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 ?" (243) Figure 6-22 caption; 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 ?" (246) last sentence; Change "the new date becomes" to "the ExtendedDeadline date becomes" (248) next to last line on page; Change "However, you can join text together " to "However, you can join text together using a process called concatenation." {255} #2; Change "Adding multiple tables" to "adding more than one related table" (260) #10; Change "UpdateProductPrices" to "RaiseProductPrices" {262} Note; Change note text to "You shouldn't try to copy AutoNumber values in an append query, because you have no way of knowing if these numbers are already in use. Instead, leave the AutoNumber field out so Access will assign new numbers." (268) #6; "If you used the asterisk (*), you'll see the full information for each record." Replace "the full information" with "all the fields" (273) Figure 8-1 caption; "Ordinary printouts are ..." change to: "Ordinary datasheet printouts..." (277) Up to Speed; 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." (281) Layout View bullet; "... and rear- range..." change to: "... and re- arrange..." (283) Last paragraph, first sentence; "After you've closed your report..." change to: "If you've closed your report..." (303) Last paragraph; 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" (311) Figure 9-4 caption; In Figure 9-4 caption, change "form" to "report" (326) The Form Wizard, #2; "... choose the table you want to use." change to: "... choose the table (or query) you want to use." (328) Figure 9-12 caption; "...then click the > button..." change to: "... then click the > button (or double-click the field)..." (334) The heading “Case for Importing and Exporting” should read “The Case for Importing and Exporting”. (334) last sentence; Change "because it involves" to "because it often involves" (335) Note, 2nd sentence; "The original copy always remains..." change to: "The original always remains..." (340) Timesaving Tip; Remove sentence "However, it works only if you're copying a complete table (or other object), not a selection of rows." (341) 1st sentence under #5; "...to create random field names..." change to: "... to create arbitrary field names..."