Access 2007 for Starters: The Missing Manual Unconfirmed Errata

Errata

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.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question

Version	Location	Description	Submitted By
PDF	Page chapter 9 9.2. Creating Crosstab Queries	Where is AdventureWorks database? I couldn't downloaded from the missing CD on your page in chapter 9. It's not on the page! Please check it out. Thank you! The AdventureWorks database uses a query named OrderedItems, which forms the basis for all the crosstab queries that you've seen so far. The OrderedItems query gets all the individual items that have been purchased in every order that's ever been made (from the SalesOrder- Details table), and then uses joins to get additional information from the SalesOrderHeader table (which represents the entire order), the Customers table, the Products table, the Store table, and the ShipMethod table. You need to make several jumps to get to the customer address information, which lets you profile how sales stack up in different cities, states, and countries. (You can study this query by downloading the AdventureWorks database from the "Missing CD" page at www.missingmanuals.com.) Kind regards Sam	Anonymous
PDF	Page 189 #2	First the DB file for chapter 5 named http://examples.oreilly.com/9780596527600/ChapterSamples/Chapter05/Bobblehead.accdb has the final result of the chapter, not the beginning stage (relationship and lookup already there). If one starts clean (no relationship) ie. deleted manufactureresID and recreates it, and then creates the relationship as stated in page 174, it cannot execute page 189 #2 as it gets msg. the the effect that a relationship exists and must be first deleted. If the lookup is created first and then the relationship edited later, it will have result as shown in chapter 5. I really like this manual, its great, but I am stuck on this chapter...	Anonymous
Printed	Page 190 Caption for fig. 5-12.	Second sentence of caption, "One links students to classes, and the other links teachers to classes," does not belong here. Figure 5-12 illustrates the procedure for setting sort order of lookup list, using the "Manufacturer" field of the example bobble-head doll database.	David Scheu
Printed	Page 221 Bamker's Roundig, 2nd column, 3rd line	"that" s/b "than"	Leo J.Carling, III
Printed	Page 471 Setting Up a Trusted Location, 1st paragraph, last line	"trust" s/b "trusts"	Leo J.Carling, III
Printed	Page 593 The highlighted note	The book says "In order to successfully use a password with a back end database, you must apply the password before you split the database. Otherwise, access won't store the password in the front end and the linked tables won't work." This is not true. When you create a database, add a password, then split the database. The password is attached to the front end file, not the back end file. Users can still update the tables by opening the back end without a password.	Anonymous