Errata for Microsoft Access 2013 Step By Step
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. 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 |
| PDF |
Page xiii
whole page |
In your download of
Microsoft® Access® 2013 Step By Step Practice Files
it is missing Chapters: 11, 12 and 13.
Pls. correct!
Note from the Author or Editor:
All practice files are now available at http://examples.oreilly.com/9780735669086-files/
Thanks for letting us know these were missing. |
lammetje |
Mar 09, 2013 |
Mar 18, 2013 |
| Printed |
Page 234
#15 |
Because the word "Category" shows up in many places, consider clarifying as follows:
"Click the Category Name label control, double-click the word "Category", then delete it and the following space."
Note from the Author or Editor:
Please change step 15 on page 234 as follows, retaining the bold for Category Name and Category:
15 Click the Category Name label control, double-click the word Category, and then delete the selected word and the following space. |
Anonymous |
Mar 07, 2013 |
|
| Printed |
Page 281
Last section |
The section describes making a copy of table(s) in another database. It could be a 'teaching moment' to use this section to point out that having the same data in more than one table, and/or in more than one database leads to issues of data integrity. Which copy is correct?
Discuss analyzing the situation to determine if you are migrating ALL data into a (single) new db, or if there are business reasons to have some data in one database (e.g., used by Dept. X) and other data in another (used by Dept. Y), but some 'sharing'. In that case, leave the data where it is and LINK to the other table(s).
Note from the Author or Editor:
On page 281, at the end of the first paragraph of the "importing from other Access databases" section, please add the following sentence:
After importing the information, remember to delete it from the source database so that it exists in only one place. |
Anonymous |
Mar 07, 2013 |
|
| Printed |
Page 306
TIP @ center |
?! " ...open both databases, copy the table ..."
What about importing the object from one to another?
Also, at least in previous versions of Access/Excel, copying too many rows from Access and attempting to paste them into Excel resulted in loss of rows. Instead, Export from Access to Excel to get ALL rows copied.
Note from the Author or Editor:
Insert the following tip between the first and second paragraphs on page 306:
Tip Always proof the results of a copy and paste operation carefully. In the past, some people experienced loss of data when copying many rows of Access data to Excel. When a lot of data is involved, you might want to export the data instead. |
Anonymous |
Mar 07, 2013 |
|
| Printed |
Page 342
2nd TIP |
In earlier version of Access, the Access support community STRONGLY recommended making a backup copy of the file before running C&R, as it ocassionally failed, corrupting the db.
If you elect to have Access automatically run C&R, where's the backup?!
Note from the Author or Editor:
Please change the 2nd tip on page 342 to the following:
Tip It’s a good idea to compact and repair a database often. You can even have Access run this utility automatically each time the database is closed, by displaying the Current Database page of the Access Options dialog box, selecting the Compact On Close check box in the Application Options area, and then clicking OK. However, to avoid any chance of corruption, always be sure to back up the database before compacting and repairing it. |
Anonymous |
Mar 07, 2013 |
|
| Printed |
Page 361
#17 |
"In the right pane..."
(it's the left pane...)
Note from the Author or Editor:
In Chapter 13, on page 361, at the beginning of step 17, please change "In the right pane" to "In the left pane." |
Anonymous |
Mar 07, 2013 |
|
|
| |
