Access 2003 Power Programming with VBA | 
 enlarge | Authors: Allen G. Taylor, Virginia Andersen
Publisher: Wiley
Category: Book
List Price: $49.99
Buy New: $22.17
You Save: $27.82 (56%)
New (26) Used (17) from $21.99
Rating:  5 reviews
Sales Rank: 125793
Media: Paperback
Edition: 1
Pages: 792
Number Of Items: 1
Shipping Weight (lbs): 2.3
Dimensions (in): 9.1 x 7.4 x 1.7
ISBN: 0764525883
Dewey Decimal Number: 005.7565
UPC: 785555864061
EAN: 9780764525889
ASIN: 0764525883
Publication Date: October 15, 2003
Availability: Usually ships in 1-2 business days
Shipping: Expedited shipping available
Condition: BRAND NEW MAY HAVE A REMAINDER MARK. 100% money back guarantee.
| |
| Also Available In:
|
| Similar Items:
|
| Editorial Reviews:
Amazon.com
Microsoft Access remains an important part of the Windows developer's environment, in that the doughty database management system represents a simple and relatively straightforward core for forms-based software modules. Access 2003 Power Programming with VBA is a resource for programmers (particularly novice ones) working with Access and its native tongue, Visual Basic for Applications (VBA). The emphasis in these pages falls on getting specific tasks done (examples include modifying a stock menu bar, connecting to data sources, listening for interface events, and exporting XML). Other coverage is more basic, and appropriate for Access developers in their novitiate stage. It deals with such fundamentals as declaring variables, establishing control structures (such as loops and case statements), and using the features of the Visual Basic Editor. Will this book help you? Probably, to some extent. It's well-written and the authors have made wise decisions about which aspects of the Access universe to include and which to leave out (Access is a big subject). Their explanatory sections are clear and easy to follow, and their code is clever enough. On the other hand, the odds are small that you'll get all the information you need out of this book, unless the application you want to write is super-simple. Take this book as one step in a potentially long journey toward the application you want, and in an even longer one toward VBA mastery. --David Wall Topics covered: The most important tools and techniques to be used in writing applications based on Microsoft Access 2003. Software design and the differences among the many Access releases are covered at first, and a clever section on Access development without VBA explains database schema development and the use of standard forms. Most of the book deals with VBA, though, including its capacity to create graphical user interfaces, connect to databases, integrate with other applications, and work with XML data. A chapter on multi-user applications (which has mainly to do with database locking) is helpful.
Product Description
* As part of the Power Pack family of books, this book gives programmers and advanced Access users the knowledge they need to master the power within Access-the world's most widely used database management system
* Shows how to use VBA to design efficient, user-friendly end-user applications in Access
* Starts with database concepts and event-driven programming, then covers VBA programming fundamentals, the Visual Basic Editor, VBA language elements, and code debugging
* Covers advanced Access programming techniques like connecting to databases with ADO and interacting with other applications
* Includes helpful discussions on compatibility issues and manipulating Visual Basic components
* Companion Web site includes all the code examples in the book
|
| Customer Reviews:
 Good Book for Programming assistance December 7, 2007
Rebecca Wesenberg
1 out of 4 found this review helpful
This is a good reference book for those of us who are not the best at programming.
 ADO templates don't work (Ch 15) July 20, 2005
Webtest (Carlisle, PA USA)
14 out of 16 found this review helpful
This book is fairly decent, except that the template code for "Connecting to Databases with ADO" (Chapter 15) is riddled with errors. Most of this is probably due to problems with Access versions and configuration, but in any case, templates that don't work are frustrating and useless. There is absolutely no errata information for this book on the Wiley web site, and Wiley doesn't take inquiries, regardless of the notes in the front of the book. Find a different book for Client/Server study.
Solid Introduction to VBA October 5, 2004
Spud (Bynum, NC USA)
59 out of 60 found this review helpful
Here is a solid introduction to programming in Access, including how to use some of the built-in features that make VBA easier to use. If you've been using Access to make forms and run quieries you should be able to pick up this book and start programming. Power Programming tells you how to create procedures and functions. The code isn't very useful by itself, but the book explains how things work so you should be able to write your own procedures.
You can learn how to customize menus using built-in dialog boxes or build them programmatically (pretty useful.) There is a long chapter on database connectivity and there is about twenty pages about XML support. There's also a couple of pages about Access backwards compatability (or lack of!)
There isn't a CD with the book and I keep trying to find a place in the book that gives a website with the code. It would be helpful to have the code available for cutting and pasting since it's so easy to make a typo.
If you are an expereienced VBA programmer, You probably want to find another book. I was looking for a book that would help me transition from Access 2000 to Access 2003. This book does not do that. I wish I had read the editiorial review more closely especially the part that says "a resource for programmers (particularly novice ones)" Another good quote from the editorial review is "the odds are small that you'll get all the information you need out of this book, unless the application you want to write is super-simple." But then you can never get everyting out of one book anyway.
Best Book for Programming Access May 4, 2004
S. Levinson (La Mirada, California United States)
14 out of 57 found this review helpful
This is the best book I have found for VBA programming I have found. It provided answers to a lot of my questions that I couldn't find in other books.
Best Book on Access Programming May 4, 2004
S. Levinson (La Mirada, California United States)
7 out of 54 found this review helpful
This is the best book I have found for VBA programming on Microsoft Access.
|
|
|
