Errata
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 |
---|---|---|---|---|
The tab names in 2013 are in capital letters. |
Mihai Zamfirescu | Feb 12, 2014 | ||
Printed | Page 17 last line |
reference should be to page 12, not 11 for fig. I-6 |
Anonymous | Jan 10, 2015 |
Printed | Page 24 FAQ |
2 font sizes used in answer. |
Michael G | Jan 24, 2015 |
Printed | Page 60 Figure 2-4 |
Last sentence of the figure description says "Descriptions also appear in the status bar when you're entering information in a table." This appears to be a hold over from a prior version of the book. |
Jack Ulsh | Jun 16, 2014 |
Printed | Page 103 |
Come on Man............. |
Jack Ulsh | Jun 16, 2014 |
Printed | Page 103 Figure 3-6 |
"Top: In this example, the First-Name and LastName field are frozen." |
Michael G | Jan 24, 2015 |
Printed | Page 103 Figure 3-6 |
"Top: In this example, the First-Name and LastName field are frozen." |
Michael G | Jan 24, 2015 |
Printed | Page 104 Figure 3.-7 |
The diagram shows the "record number" in the navigation. It says, "jump to a specific record." This should probably be clarified especially for new users who might not know. This number is only relative to the currently loaded recordset. It should not be relied upon to actually go to a specific record in most cases. Since tables are not stored in any particular order, unless the records do not get added/deleted from the table and a query with a sort order is used for the form's record source, the number 7 record can, and is likely, to not refer to the same record over time. This is a common mistake made by new users. |
Bob Larson | Jul 13, 2013 |
Printed | Page 104 Figure 3-7 |
As reported by Al Rhodes below, "2 or 7" should be "2 of 7". |
Michael G | Jan 24, 2015 |
Printed | Page 106 United States |
The statement "Similarly, any new records that you add stay at the end of the table until the next sort (or the next time the table is opened)..." is misleading and should be clarified. |
Bob Larson | Jul 13, 2013 |
Printed | Page 117 2nd and 3rd bullet points on the page |
Refers to datasheet as spreadsheet. |
Michael G | Jan 24, 2015 |
Printed | Page 132 Figure 4-3 |
"You can keep your changes (even though they conflict with at least one record. ..." |
Michael G | Jan 24, 2015 |
Printed | Page 160 Full page |
As of Access 2013 version 15.0.4667.1002, "Limit to List" function is included in Lookup Wizard. |
Sergei Karacharov | Nov 25, 2014 |
Printed | Page 177 Tip box |
Double period after "datasheet" in the Tip box. |
Sergei Karacharov | Nov 26, 2014 |
Printed | Page 222 3rd paragraph |
The statement "That means you need to retrieve similar columns from each table, in the same order..." is incorrect when it comes to Access. For Access the ONLY thing that is necessary is to have the same NUMBER of columns returned from each Select statement. The data type does NOT have to be the same (unless they actually did change this for Access 2013). If you use disparate data types then Access coerces that column to Text. |
Bob Larson | Jul 13, 2013 |
Printed | Page 242 1/3 down the page |
The Order of Operations known as PEMDAS specifies that Multiplication is performed before Division. |
Anonymous | Mar 16, 2021 |
Printed | Page 244 First sentence in the "Query Functions" section |
The sentence reads, "By now, it may have2 crossed your mind..." |
Anonymous | Jul 25, 2013 |
Printed | Page 270 2nd paragraph |
Under the OrderTotal bullet point, it says "so set the Total box to Sum." This is incorrect as setting to Sum will trigger a "Cannot have aggregate function in expression" error. The Total box must be set to Expression in order for the query to execute properly. |
Greg Fox | Feb 20, 2016 |
Page 369 3rd paragraph |
In the paragraph (on the KEEP TOGETHER property): |
Carlos Oliveira | Nov 06, 2014 | |
Printed | Page 372-380 Sample Reports for Chapter 11 |
All of your sample reports for Chapter 11 have a similar error. They all set the report width to 8 inches. When this is combined with the page margins it always causes a blank page to be printed between every report page. I changed the report width to 7.5 inches on the property sheets and the problems were resolved. |
Jack Ulsh | Jun 22, 2014 |
Printed | Page 418 Para 5. |
In numbered para 5., there is an extra lower-case "w" in the word "Wizard". |
Terry Janzer | Feb 16, 2015 |
Printed | Page 426 12th line of char on that page |
What it says now: |
Nan Barber | Jun 25, 2013 |
Page 547 5th Paragraph |
Titled: |
Mohamed Rashid | Mar 26, 2015 | |
Printed | Page 550-554 United States |
The text describes a Products_Audit table and all the macros that accompany that table. |
Jack Ulsh | Jun 25, 2014 |
Printed | Page 566 3rd paragraph of sidebar |
The URL http://tinyurl.com/access-VBA should be http://tinyurl.com/accessVBA |
Nan Barber | Apr 11, 2013 |
Printed | Page 576 Gem in the rough callout |
The statement reads, "Technically, Me is a programming object that represents the current form." |
Bob Larson | Jul 13, 2013 |
Printed | Page 578 UP TO SPEED callout |
The statement currently reads, "So, if you have a button that's 1.125 twips wide, and it's still too narrow, try a Width of 1.5..." |
Bob Larson | Jul 13, 2013 |
Printed | Page 593 Last paragraph |
Visual Basic edit printed. Surely should be Visual Basic Editor? |
Rod Manson | May 07, 2015 |
Printed | Page 655 2nd bullet point at top of page |
The statement reads, "They can't edit or even look at your VBA code and macros." |
Bob Larson | Jul 13, 2013 |
Printed | Page 838 All pages in Appendix A |
The pages numbers given in the index are not the same as the page numbers where the info actually is - they are consistently out of sync with each other by four or five pages. |
Anonymous | Mar 12, 2016 |
Printed | Page 842 All pages in Ch 23, Import & Export Operations |
The pages numbers given in the index are not the same as the page numbers where the info actually is - they are consistently out of sync with each other by four or five pages. |
Anonymous | Mar 12, 2016 |
Printed | Page 847 Index entry to Run Time Mode |
The index points "runtime engine, Access" to page 658. There is no reference to that term on that page. The appropriate reference should be to page 656 or 657. |
Jack Ulsh | Jun 16, 2014 |
Printed | Page 850 Index entry - TCP/IP protocol |
Current - TCP/IP protocol, 743 |
Dennis Clinefelter | Aug 04, 2015 |
Other Digital Version | 2175 Figure 3-7 |
Kindle version |
Al Rhodes | Jul 16, 2013 |