CDN$ 30.23
  • List Price: CDN$ 47.99
  • You Save: CDN$ 17.76 (37%)
Usually ships within 3 to 6 weeks.
Ships from and sold by Amazon.ca.
Gift-wrap available.
Quantity:1
Add to Cart
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Expert One-on-One Microsoft Access Application Development Paperback – May 7 2004


Amazon Price New from Used from
Paperback
"Please retry"
CDN$ 30.23
CDN$ 27.03 CDN$ 0.99

Join Amazon Student in Canada



Customers Who Bought This Item Also Bought

NO_CONTENT_IN_FEATURE

Product Details

  • Paperback: 624 pages
  • Publisher: Wrox; 1 edition (May 7 2004)
  • Language: English
  • ISBN-10: 0764559044
  • ISBN-13: 978-0764559044
  • Product Dimensions: 23 x 19 x 3 cm
  • Shipping Weight: 921 g
  • Average Customer Review: 3.5 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: #687,701 in Books (See Top 100 in Books)
  • See Complete Table of Contents


Inside This Book (Learn More)
First Sentence
An application is more than just a database. Read the first page
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

3.5 out of 5 stars
5 star
0
4 star
1
3 star
1
2 star
0
1 star
0
See both customer reviews
Share your thoughts with other customers

Most helpful customer reviews

Format: Paperback
I bought this book hoping, as the author stated in her introduction, to make the transition from an experienced and competent Access user to an Access developer who can make a living developing applications for clients. I had hoped that the book would be chocked full of tips, tricks and wisdom from an Access expert. But I was disappointed. The author stated that she wrote this book for experienced Access users, who knew how to create tables, queries, forms and other Access objects, and had some familiarity writing VBA code. It has always been my opinion that the creation of a good Access database application requires a solid knowledge of VBA, the available control events and how to effectively program those control events. Unfortunately the chapter on VBA was rather weak and the chapter on controls had little discussion of the numerous control events.
On the other hand, the author presented 13 full pages of VBA code to demonstrate using the ItemsSelected collection of a MultiSelect listbox, a concept that could have been demonstrated in about 10 lines of code. I found it interesting that the author never mentioned the Control Wizard, which can automatically generate VBA code for many control events. Also the author never mentioned that a callback function could be used as the record source for a combobox (or listbox).
In the first half of the book the author uses the Toy Workshop database example to illustrate how to create/modify tables, relationships, forms, controls and reports. The reader very quickly must become familiar with the structure of this database. A complete summary of the tables (listing the fields), forms (listing the controls), queries, and reports in an appendix would have been very helpful.
Read more ›
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
Helen has been around since Access was introduced. She knows how to solve problems. This book is better than her previous book (Microsoft Press) for Access 2002. Great examples, plenty of code. Helen gives the reader insight into every day solutions. I especially like her Menu Manager Add-in. It is a good help for using her solutions. And, she even has code for sending a fax from Access with WinFax. I wrote my own procedure (it took a great deal of time) and it works fine, but Helen's code is very efficient (over 20 pages devoted to this in her book). It checks for all the folders and sends the fax. Much more information included - from a sample interview with a client, to using Access with Word, Outlook, and Excel.
My only complaint concerns the sample files. Wrox used to include a CD, but now they seem to be leaining toward web downloads. Not a bad idea but, in this case, the files are over 100 MB. If you don't have broadband, you may be working in Access 2004 before you're finished downloading these samples.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 4 reviews
45 of 45 people found the following review helpful
It's OK, but there are better books July 17 2004
By T. L Waltz - Published on Amazon.com
Format: Paperback Verified Purchase
I bought this book hoping, as the author stated in her introduction, to make the transition from an experienced and competent Access user to an Access developer who can make a living developing applications for clients. I had hoped that the book would be chocked full of tips, tricks and wisdom from an Access expert. But I was disappointed. The author stated that she wrote this book for experienced Access users, who knew how to create tables, queries, forms and other Access objects, and had some familiarity writing VBA code. It has always been my opinion that the creation of a good Access database application requires a solid knowledge of VBA, the available control events and how to effectively program those control events. Unfortunately the chapter on VBA was rather weak and the chapter on controls had little discussion of the numerous control events.
On the other hand, the author presented 13 full pages of VBA code to demonstrate using the ItemsSelected collection of a MultiSelect listbox, a concept that could have been demonstrated in about 10 lines of code. I found it interesting that the author never mentioned the Control Wizard, which can automatically generate VBA code for many control events. Also the author never mentioned that a callback function could be used as the record source for a combobox (or listbox).
In the first half of the book the author uses the Toy Workshop database example to illustrate how to create/modify tables, relationships, forms, controls and reports. The reader very quickly must become familiar with the structure of this database. A complete summary of the tables (listing the fields), forms (listing the controls), queries, and reports in an appendix would have been very helpful. The reader is almost forced to download the sample databases from the Wrox website to get anything out of the book.
The author had many pages presenting the three add-ins that she developed: Design Schemes, LNC Rename and the Menu Manager add-in. On the surface these add-ins appear to be good tools for an Access developer, but the LNC Rename add-in (used to rename objects using the Leszynski naming convention) was not designed to work for controls with existing VBA code. And I wasn't crazy about the design of the main form created by the Menu Manager. Not to mention the fact that this add-in required you to rename your main form using a non-standard "fpri" tag. I would have liked for the author to give me the expert guidance that I need to create my own add-ins rather than to simply use the "canned" add-ins developed by the author.
I didn't read the chapters on Automation dealing with Word, Outlook or applications outside of Office. The chapter "Working With Word" probably is one of the best chapters since this subject appears to one of the author's areas of expertise. I did read the chapter on "Working with Excel". It was OK. It just scratched the surface of the subject of automation between Access and Excel, primarily dealing with how to programmatically export data from Access to Excel and import data from Excel into Access.
Before you decide to purchase this book, I'd recommend taking a look at Alison Balter's book "Mastering Microsoft Access 2000 Development " and Scott Barker's book "Microsoft Access 2000 Power Programming". And if you decide to purchase this book, plan on downloading the sample databases (Note: the three ZIP files are a whopping 114MB) and plan on spending a lot of time studying the sample tables, forms, queries, reports, and VBA code.
18 of 19 people found the following review helpful
Great for your Access library June 13 2004
By Allan Bach - Published on Amazon.com
Format: Paperback Verified Purchase
Helen has been around since Access was introduced. She knows how to solve problems. This book is better than her previous book (Microsoft Press) for Access 2002. Great examples, plenty of code. Helen gives the reader insight into every day solutions. I especially like her Menu Manager Add-in. It is a good help for using her solutions. And, she even has code for sending a fax from Access with WinFax. I wrote my own procedure (it took a great deal of time) and it works fine, but Helen's code is very efficient (over 20 pages devoted to this in her book). It checks for all the folders and sends the fax. Much more information included - from a sample interview with a client, to using Access with Word, Outlook, and Excel.
My only complaint concerns the sample files. Wrox used to include a CD, but now they seem to be leaining toward web downloads. Not a bad idea but, in this case, the files are over 100 MB. If you don't have broadband, you may be working in Access 2004 before you're finished downloading these samples.
Very approachable Aug. 8 2011
By J. Sayer - Published on Amazon.com
Format: Paperback Verified Purchase
This book has good coverage for Access 2003, but is sadly out of date. Still it does have a personality that gives the reader some real one-on-one insight and information. I hope that Helen updates her work.
A useful Access guide to app development and VBA Aug. 5 2010
By Bob - Published on Amazon.com
Format: Paperback Verified Purchase
Helen is a dean of Access VBA development. The book is full of useful, easily adaptable examples of how to customize Access apps with VBA.

Product Images from Customers

Search


Feedback