Microsoft® Access® 2010 Step by Step

Errata for Microsoft® Access® 2010 Step by Step




The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

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



Version Location Description Submitted By Date Submitted Date Corrected
Printed
Page xxi
First bulleted line

The line reads: Detailed table of contents Scane the listing ... I believe the word Scane should be "Scan" the listing...

Note from the Author or Editor:
Location: Page xxi 1st bullet Change: Scane the listing To: Scan the listing

Gerald Cates  Dec 22, 2011  Jul 27, 2012
Printed
Page xxv
2nd paragraph

The URL given for the book's errata page is easy to misread. The capital letter 'I' which appears after the 'k' in the word 'LinkId' is easy to mistake for a lowercase 'L'. Change: "go.microsoft.com/fwlink/?LinkId=192153" To: "http://go.microsoft.com/fwlink/?Linkid=192153"

None  Oct 17, 2010  Feb 01, 2011
Printed
Page xxiii
1st paragraph

The URL given for the practice files is easy to misread. The capital letter 'I' which appears after the 'k' in the word 'LinkId' is easy to mistake for a lowercase 'L'. Change: "go.microsoft.com/fwlink/?LinkId=192153" To: "http://go.microsoft.com/fwlink/?Linkid=192153"

None  Oct 17, 2010  Feb 01, 2011
Printed
Page 71
last sentence

The last sentence reads: "The Show Table dialog box opens so that ...." I believe that it should read " Click on the Show Table button to bring up the Show Table dialog box so that...." I see that this is explained under the Troubleshooting on the next page, but I only got to that next page when I figured out how to bring the dialog box up, so it was too late.

Note from the Author or Editor:
This behavior was somewhat erratic when Access 2010 was first released. To respond to the reader's concern, please do the following: Move the Troubleshooting paragraph from page 72 to the bottom of page 71.

John Reindl  Dec 15, 2012  Jul 19, 2013
Printed
Page 110
step 12

In the last sentence, it reads that 20 records are displayed, but my system only shows 19.

Note from the Author or Editor:
Please change the paragraph below step 12 on page 110 to the following: Nineteen records are displayed in the filtered table.

John Reindl  Dec 15, 2012  Jul 19, 2013
Printed
Page 110
Step 12.

Step 12 on page 110 says, "in the employeeID field, right-click 7, and then click Equals7." This cannot be since the fields in the employeeID are Text with Employee names and not numerals. Therefore the filter doesn not work.

Note from the Author or Editor:
This issue was caused by an update made to the practice file. Please change step 12 to read as follows: 12. In the EmployeeID field, right-click Emanuel, Michael, and then click Equals "Emanuel, Michael". Please apply the Interface Object character style to the following elements of the corrected step 12: - EmployeeID - Emanuel, Michael - Equals "Emanuel, Michael"

Henry Julicher  Sep 24, 2010  Feb 01, 2011
Printed
Page 119
Saving Filters as Queries

Save As Query function is inactive unless view is changed from Datasheet to Layout. Therefore to save a filter as a query: 1. On the Home tab, in the Sort & Filter group, click the Advanced Filter Options button and then click Advanced Filter/Sort... (This opens Layout view). 2. Again on the Home tab, in the Sort & Filter group, click the Advanced Filter Options button and then click Save As Query. (Save As Query is now available.

Note from the Author or Editor:
The reader's description of the problem and proposed solution are correct. Thanks!

Anonymous  Oct 13, 2011  Nov 14, 2011
Safari Books Online
133
No 15. of the exercise.

No.15 states Inside the shaded area of the report header, but away from the title.... If you click in this area (Outside of the Report Header), by default, a row color is not applied to alternate group headers... you have to click in the Group Header area and then do what No. 15 says and then and only then you would get alternate group coloring. PLEASE ADVISE!!. Maybe, i am misinterpreting the command to follow. Would appreciate a quick response. Warm Regards, Susan

Note from the Author or Editor:
The alternate group header coloring does not result from step 15. It exists by default. Please change the paragraph following step 15 to the following: When you created this report, alternate group headers were shaded with the same color as alternate data rows. This coloring confuses rather than clarifies the report structure. Let's turn off this alternate group header color.

Susan Mayhrai  May 26, 2011  Jan 04, 2013
Printed
Page 151
Step 7, near top of page.

When I typed 2.5, the value changed to 2.00 - should this be the whole number, 2 instead? (When I removed the "Standard" format in design view, entering 2.5 did change to 2; the same is true when the format was changed to "General Number").

Note from the Author or Editor:
Please add the following sentence to the end of the paragraph following step 7 on page 151: Because you chose Standard when setting the data type for this field in the previous exercise, the whole number is displayed as 2.00. Error corrected. Will be fixed in next printing.

Anonymous  Feb 10, 2011  Nov 14, 2011
Safari Books Online
171
Multicolumn Lookup Lists

In the Multicolumn Lookup Lists area (surronded by a border), there is an option that should have been included. After No.3 and before clicking Finish, you should have added to tick the box labeled Allow Multilevel Lists. If this was not emphasized here, yu should have said to select Yes under the Loopup area in the Field Properties.

Note from the Author or Editor:
On the last page of the Lookup wizard, I see Allow Multiple Values, not Allow Multilevel lists, and that is the name of the property in the Field Properties area of the table designer. However, I did skip over a fairly intuitive wizard page in the steps. Please make the following change: 3. On the third page, indicate which column contains the data to be stored in the database. (new step) 4. Assign a name to the field, select the Limit To List check box, and click Finish. (edited step to gain a line) Also to make room for the addition, run "Save the table" back to the end of step 2 in the last set of steps.

Susan Mayhrai  May 26, 2011  Jan 04, 2013
PDF
Page 224
Clean Up (next to blue X)

When I closed the query, Access asked if I wanted to save the changes in the layout (made in Step 14). Clean Up should specify whether to save or not.

Note from the Author or Editor:
Change the first sentence of the Clean Up on page 224 to the following: Close the query, saving your changes if you want to.

D.J. Wilsey  Nov 01, 2012  Jul 19, 2013
PDF
Page 232
Exercise

On the previous page (page 231), there was an Important note saying that you need to create a backup copy of the table before running an update query, but the exercise doesn't practice this advice.

Note from the Author or Editor:
Please change the last sentence of the SET UP paragraph to read: Open the GardenCompany08 database, create a copy of the Products table as described in the Important note on the previous page, and then follow the steps.

D.J. Wilsey  Nov 02, 2012  Jan 04, 2013
Printed
Page 245
step 12

Step 12 reads "Drag the CategoryName text box control into the CategoryName Header Section." I tried to do this by clicking on the small square in the upper left hand corner of the text box. But, I could never get past the border between the Detail section and the CategoryName Header section. By accident, however, I had the mouse pointer over the outline of the Category Name text box and it changed into a set of what looked like arrows to move the box and this type of move was able to cross the border. Is this normal, or was I doing something wrong when I tried to use the small square in the upper left hand corner of the text box? Thanks, John

Note from the Author or Editor:
Change step 12 on page 245 to the following, ensuring that interface elements are styled as IO: Point to the border of the CategoryName text box control (not the gray handle), and drag the control into the CategoryName Header section.

John Reindl  Dec 21, 2012  Jul 19, 2013
PDF
Page 248
United States

In Step 7, under the diagram, it says "for both data and time controls" -- It should read "for both date and time controls".

D.J. Wilsey  Nov 14, 2012  Jan 04, 2013
Printed
Page 254
step 3

Step 3 describes a process to add a subreport and says that the SubReport wizard will start. This wizard will only start if, in the Controls gallery, the Use Controls Wizard is enabled. (When I followed the steps in the book, the Wizard did not appear, but the solution was found from the help system.)

Note from the Author or Editor:
Change step 3 at the bottom on page 254 to the following, ensuring that interface objects are styled as IO: On the Design contextual tab, in the menu containing the Controls gallery, ensure that Use Control Wizards is active. Then click the Subform/Subreport button, and click in the CategoryName Header section about two grid points below the lower-left corner of the Product label control.

John Reindl  Dec 21, 2012  Jul 19, 2013