Errata for Access Database Design & Programming

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"

"1.6 gigabytes"

longer a superkey"

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

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

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

right-hand cells changed to "j"

cell changed to "j"

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

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));

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

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

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

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

intvar = 123 It goes after the current second line.

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

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

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,

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

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

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

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

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."