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 Note Update
| Version |
Location |
Description |
Submitted by |
Date submitted |
| 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 |
Sep 04, 2008 |
| Printed |
Page 79
last paragraph, list of date formats |
The first bullet point reads:
2008-23-2 (the international year-month-day standard always works)
should be:
2008-02-23 (the ISO 8601 international standard YYYY-MM-DD always works)
Explanation of error:
There is no month 23.
|
Bob Burg |
Mar 01, 2013 |
| Printed |
Page 125
last sentence |
"button appears on LEFT edge" should read button appears on RIGHT edge."
|
Marko Slusarczuk |
Aug 06, 2010 |
| Printed |
Page 153
Table 4-2, fifth line entry |
current text:
comparison sample expression description
Greater than >Date() The date occurs today or after
the current date
The description should be:
"The date occurs after today." or
"The date occurs tomorrow or after."
For the line entries to be consistent, either change the description or change the other two entries to 'greater than or equal to' and '>='.
|
Bob Burg |
Mar 01, 2013 |
| 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 |
Sep 12, 2008 |
| Printed |
Page 307
5th paragraph |
missing word: "take care all of your day-to-day" should be, "take care of all of your day-to-day."
|
Anonymous |
Nov 19, 2010 |