Books are reprinted by the publisher from time to time, giving us the opportunity to remove errors. You can check which printing you have by looking at the page of details very near the front of the book. (The first printing does not explicitly state 'first printing' but all subsequent printings state something like 'Second printing 2004'.)

If you spot any error, please email details to mark@penguinsoft.co.uk



Thanks for reported typos/errata are kindly acknowledged to: Don Allen, Sue Landis, Lei Wood, Mary Whitehorn

Third printing

No known errors.

First and second printing

P. 34. Paragraph below the screen shot:
"If’ you’ve worked through the chapter thus you should have…"

"If’ you’ve worked through the chapter thus far you should have…

P. 53. First two sentences on this page:
"Answer Yes again and the answer table appears. Close the table and look in the Tables tab of the database window."

should read:

"Answer Yes again and look in the Tables tab of the database window."

P. 89. Last line but one on the page:
Replace the word ‘tick’ (both occurrences) with the word ‘check’.

P. 99. Second paragraph. First sentence.
"In fact, input masks can be made more complex that this."

"In fact, input masks can be made more complex than this."

P. 114. First paragraph. First sentence.
"Postal codes in the UK are much more complex that they initially appear."

"Postal codes in the UK are much more complex than they initially appear."

P. 114. First paragraph, fifth line.
"This happened to me (Mark) when I…

Delete text starting from the text above to the end of the paragraph, i.e. delete “This happened…” to “…demonstration purposes.”

Also delete the last sentence of the second paragraph, i.e. delete “Once again there is some information relating to this in the PostCodes folder.”

Also delete the final paragraph.

P. 118. Second paragraph, lines 3-4:
"Prepare to add a criteria to the City field…"

"Prepare to add a criterion to the City field…"

P.121. First paragraph, last line but two:
"Then if something does goes wrong, you can recover painlessly."

"Then if something does go wrong, you can recover painlessly."

P. 174. Last paragraph. First sentence.
"Labels can say anything that you want then to."

"Labels can say anything that you want them to."

P. 53. Top of page:
"Answer Yes again and the answer table appears."

In fact, when you try this the answer table doesn't open. You have to reopen the query to see the results.

P. 195. Second paragraph, lines 3-4:
"As with the images, the values in this worksheet do not have to available for editing."

"As with the images, the values in this worksheet do not have to be available for editing."

P. 198. Second paragraph, line 3:
"…often the best starting point for a creating highly customized report."

"…often the best starting point for creating highly customized report."

P. 201. Last paragraph, first line:
"At this point the meaning of the groupings should became apparent."

"At this point the meaning of the groupings should become apparent."

P. 206. First paragraph, third line:
"…design a report from scratch on a blank design screen but in is far more common…"

"…design a report from scratch on a blank design screen but it is far more common…

P. 210. Second paragraph, first line:
"To sort the widgets by the number of nuts and bolts…"

"To group the widgets by the number of nuts and bolts…"

P. 236. First paragraph, line 2:
"…so pop down the list as select…"

"…so pop down the list and select…"

P. 245. Second paragraph, second line:

"Both of these options are reasonable powerful…"

"Both of these options are reasonably powerful…"

P. 248. Last paragraph but one, lines 1-2:

"…ensures that a single record on one table is always and only joined…"

"…ensures that a single record in one table is always and only joined…

P. 274. Last paragraph but one, line 2:

"Returning with subform theme, we’ll look at…"

"Returning to subform theme, we’ll look at…

P. 291. Last paragraph but one, last line but one:

"Almost all reports in multi-tables databases are based on queries…"

"Almost all reports in multi-table databases are based on queries…"

P. 310. Second paragraph, lines 4-5:

"Access provides uses predefined groups includes Read-Only Users,..."

"Access provides predefined groups including Read-Only Users,..."

P. 312. Third paragraph, line 7:

"...and deliberately restricted this engine..."

"... and deliberately restrict this engine..."