Access Database Design & Programming

Errata for Access Database Design & Programming

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
Printed
Page xvi
changed "ora.com" to "oreilly.com" both times it appears

Anonymous    Sep 01, 1997
Printed
Page xvi

para. 2: the URL for updates now reads: "http://www.oreilly.com/catalog/9781565922976/"

Anonymous    Nov 01, 1998
Printed
Page 6

changed the equation on line 3 to read: (16,000,000 - 10,000) * 50 = 799 million characters plus, in the next para., changed "megabytes" to "gigabytes"

Anonymous    Jan 01, 1998
Printed
Page 6
In the first sentence after the equation, changed "160 gigabytes" to

"1.6 gigabytes"

Anonymous    Apr 01, 1999
Printed
Page 7

In the second para under Deletion Anomalies, the sentence used to read: Such a database is called... It now reads: Because a table describes a "relation", such a database is called...

Anonymous    Apr 01, 1999
Printed
Page 9
last line: changed "related" to "persistent"

Anonymous    Jan 01, 1998
Printed
Page 21
2nd line of "Key" entry changed "no longer a key" to "no

longer a superkey"

Anonymous    Sep 01, 1997
Printed
Page 29
item #5, line 1: changed "OK button" to "Create button"

Anonymous    Jan 01, 1998
Printed
Page 32
figure 3-9 is new.

Anonymous    Sep 01, 1997
Printed
Page 48
in both tables, changed "0-222-22222-2" to "0-111-22222-2"

Anonymous    Apr 01, 1998
Printed
Page 48
Changed the display from

{ISBN, PubPhone} and {PubPhone, PubName} to {ISBN, PageCount} and {PageCount, Price}

Anonymous    Mar 01, 1999
Printed
Page 59-60
The sample tables are not designated S and T as they are

referred to in the text - very minor detail, but labeling the tables would increase reader-friendliness.

Anonymous   
Printed
Page 62
figure 5-7 is also new.

Anonymous    Sep 01, 1997
Printed
Page 66
line between tables, and next-to-last line on page: changed the

greater-than-or-equal-to sign to a regular greater-than sign

Anonymous    Jan 01, 1998
Printed
Page 70
last column's header in first table: changed "S.B 4" to "T.B

4" (the 4's a subscript

Anonymous    Sep 01, 1997
Printed
Page 70
table 2: made column S.A3 white and column S.A4 shaded

Anonymous    Jan 01, 1998
Printed
Page 70
1st and 2nd tables: the "h" in the lower

right-hand cells changed to "j"

Anonymous    Jul 01, 1998
Printed
Page 70
first table, header "S.A1": the subscript "1" is now bold, not italic

Anonymous    Nov 01, 1998
Printed
Page 73
3rd table: the "h" in the lower right-hand

cell changed to "j"

Anonymous    Jul 01, 1998
Printed
Page 76
column B3: made the upper-case "I"s into "i"s

Anonymous    Jan 01, 1998
Printed
Page 81
changed

(sel S.A2 = T.A2, S.A4 = T.A4(SxT)) to: (sel S.A1 = T.A1(SxT))

Anonymous    Jan 01, 1998
Printed
Page 89
para. beginning "(In SQL-92...": changed

"this clauses has" to "these clauses have"

Anonymous    Jul 01, 1998
Printed
Page 90

code sample 3 now reads: CREATE TABLE BOOKS2 (ISBN TEXT(13) CONSTRAINT PrimaryKeyName PRIMARY KEY, TITLE TEXT(100), PRICE MONEY, PubID TEXT(10), CONSTRAINT Test FOREIGN KEY (PubID) REFERENCES Publishers (PubID));

Anonymous    Nov 01, 1998
Printed
Page 97
line 1 of first code example: changed "DISTINCT" to "DISTINCTROW"

Anonymous    Sep 01, 1997
Printed
Page 101
Changed the sentence after Table 6-7 from

"This is, in fact, the semi-join" to "This is, in fact, a projection of the semi-join"

Anonymous    Mar 01, 1999
Printed
Page 104
next-to-last line on page: removed ";" and added it to the end

of the last line; also, changed the first line of that code example to read: SELECT PUBLISHERS.PubName, MIN(Price) AS [Minimum Price]

Anonymous    Jan 01, 1998
Printed
Page 104
para, under "GROUP BY GroupByCriteris",

last sentence: changed "the order of column names in determines" to "the order of column names determines"

Anonymous    Jul 01, 1998
Printed
Page 104
Under the heading for the "Having" option

"The HAVING option in used in conjunction ..." now reads "The HAVING option is used in conjunction ..."

Anonymous    Nov 01, 1998
Printed
Page 107
line 2: changed "form" to "from"

Anonymous    Jan 01, 1998
Printed
Page 108
last line: changed "indicies" to "indices"

Anonymous    Jul 01, 1998
Printed
Page 110
middle para.: deleted extra "than one"

Anonymous    Jan 01, 1998
Printed
Page 116
next-to-last line: changed "Jet DMBS" to "Jet DBMS"

Anonymous    Sep 01, 1997
Printed
Page 122
Example 7-1, removed the line: dbLibrary.Name = "LIBRARY"

Anonymous    Mar 01, 1999
Printed
Page 123
Changed the line

Set dbLibrary = ws.OpenDatabase("d:daolibrary.mdb") to Set dbLibrary = DBEngine.OpenDatabase("d:daolibrary.mdb")

Anonymous    Mar 01, 1999
Printed
Page 125
para. 2 line 4: changed "below" to "above"

Anonymous    Jan 01, 1998
Printed
Page 128
last line: changed "Holliday" to "Holiday"

Anonymous    Jan 01, 1998
Printed
Page 138
Example 8-1: changed the first line from

intGrade = Val(InputBox("Enter student's average _ test score: ")) to intGrade = Val(InputBox("Enter student's average test score: "))

Anonymous    Jul 01, 1998
Printed
Page 142
added a line to the first code example

intvar = 123 It goes after the current second line.

Anonymous    Sep 01, 1997
Printed
Page 147
Figure 9-5: Two boxes in the diagram Containers and Documents should be

connected. And Containers should also be connected to the horizontal line immediately above it (that originates from Databases).

Anonymous   
Printed
Page 147
1st line of text: changed "is the just" to "is just the"

Anonymous    Jan 01, 1998
Printed
Page 147
figure 9-5 is new.

Anonymous    Jan 01, 1998
Printed
Page 149
figure 9-7 is also new.

Anonymous    Jan 01, 1998
Printed
Page 157
Changed the line

"of the previous example, we could have written" to "we can write"

Anonymous    Mar 01, 1999
Printed
Page 158
2nd para., 1st line: changed

Running the code in Exaple 9-6 produces the message box shown in Fiure 9-8, to Running the code in Exaple 9-6 produces two message boxes; the second is shown in Fiure 9-8,

Anonymous    Jul 01, 1998
Printed
Page 161
4th line from bottom: changed "use to this" to "use this"

Anonymous    Jan 01, 1998
Printed
Page 171
example 9-10: in the example title, changed "Container" to

"Containers"

Anonymous    Sep 01, 1997
Printed
Page 176
last line: fixed the weird font problem

Anonymous    Jan 01, 1998
Printed
Page 177
in step 5 in the box, changed "dbOne.Table..." to "dbTwo.Table..."

Anonymous    Sep 01, 1997
Printed
Page 191
line 2 on page: added a comma after "QueryDefName"

Anonymous    Sep 01, 1997
Printed
Page 193
Changed the line

strSQL = "UPDATE BOOKS SET Price = Price*1.1 WHERE Price > 20" to strSQL = "UPDATE BOOKS SET Price = Price*1.1"

Anonymous    Mar 01, 1999
Printed
Page 193
Changed the line

If qdf.RecordsAffected > 15 Then to If qdf.RecordsAffected <= 15 Then

Anonymous    Mar 01, 1999
Printed
Page 193
The following two lines of Example 10-7 were modified so that

they appear as follows: MsgBox qdf.RecordsAffected & _ " records affected by this query. Transaction cancelled."

Anonymous    Apr 01, 1999
Printed
Page 202
Replaced the line

Msgbox rsTable!Title with the two lines If Left$(tsTable!Title,2) = "On" then Msgbox rsTable!Title

Anonymous    Mar 01, 1999
Printed
Page 205
At the second bullet point, inserted the word "valid" between

"there is no" AND "current record". So it now reads "there is no valid current record"

Anonymous    Apr 01, 1999
Printed
Page 230
In line 2, inserted the words "are sufficient to" after the

words "rows of a table that"

Anonymous    Apr 01, 1999
Printed
Page 231
Replaced double arrow symbol with a large X, as on page 62 under the

definition of cartesian product.

Anonymous    Mar 01, 1999
Printed
Page 232
In Table B-4

1. Changed the last cell in the last row to "red oak" 2. Added another row with first cell "Fred's Woods" and second cell "poplar." 3. Added another row with first cell "Fred's Woods" and second cell "mahogany."

Anonymous    Mar 01, 1999
Printed
Page 237
In paragraph numbered 4, in the second to last line, changed "right" to

"left."

Anonymous    Mar 01, 1999
Printed
Page 238
In the table at bottom: changed Meville to Melville.

Anonymous    Mar 01, 1999
Printed
Page 245
Two headings were added at the beginning of the index: "Symbols," and

"Numbers."

Anonymous    Mar 01, 1999
Printed
Page 246
In column 1, line 13

"for specific objects, ??-229, 210-??" was changed to: "for specific objects, 210-229"

Anonymous    Mar 01, 1999
Printed
Page 253
added the following to the end of the next-to-last para.

Whenever possible, our books use RepKover (tm), a durable and flexible lay-flat binding. If the page count exceeds RepKover's limit, perfect binding is used.

Anonymous    Sep 01, 1997
Printed
Page 253
Colphon, 2nd para., line 2: changed "Quark Xpress 3.5" to

"QuarkXpress 3.3"

Anonymous    Jul 01, 1998