|
Access 2003 VBA Programmer's Reference (Programmer to Programmer)
|
List Price:
$39.99
Bugarin.info Price:
$29.19
Your Savings: $ 10.80 ( 27% )
Subject To Change Without Notice
Availability: Usually ships in 24 hours
Manufacturer: Wrox
|
Average Customer Rating:   
|
|
Binding: Paperback
Dewey Decimal Number: 005.7565
EAN: 9780764559037
ISBN: 0764559036
Label: Wrox
Manufacturer: Wrox
Number Of Items: 1
Number Of Pages: 984
Publication Date: 2004-04-09
Publisher: Wrox
Studio: Wrox
|
|
|
|
|
|
Editorial Reviews:
|
* Covers all features of VBA programming for Access database applications
* Begins with an overview of VBA and highlights what's new in Microsoft Access 2003, the most popular database system in the world
* Real-world code examples demonstrate each programming topic, including using the Access Object Model, VBA execution and error handling, creating database objects with VBA, writing secure VBA code, and much more
* Shows how Access 2003 provides enhanced XML support, making it easier for programmers to publish data to the Web and exchange it with other organizations
|
|
|
Spotlight customer reviews:
|
Customer Rating:
Summary: Brings it all together
Comment: I started working with VB back at the turn of the Century (yes, that was 8 years ago), same with ADO and databases in General. A little of this here, a little of that there It wasnt till the last year that I had to do VBA and Access, and this book brought it all together.
Its not for a beginner. They dont discuss writting queries, or designing data bases nor branching and decision making. It DOES talk about Macros, Objects, Security, API and how to use the tools in Access to make full featured Access application and integrete it with other MS Office products. It gives subtle nauances that you just cant find no matter how often you push F1
I was getting this stuff on my own of course, but trying to figure out something from the Help documentation and NorthWind just wasnt doing it. Our clients give my consulting company a lot of money to get things done This book was just what I needed consoldate my skill set and meet our clients needs.
Customer Rating:
Summary: Look for another book
Comment: I have built some pretty significant excel forms & processes using the VBA environment. This book does little to take you into developing in ACCESS. The examples are poor, inconsistent and too vague for a newbie to the environment.
Customer Rating:
Summary: This is the book I use most.
Comment: I count 6 MS Access books on my shelf at work. If I could only have one, it would be this one. I find information that I haven't found in any of the others. It's also the best reference on Access SQL. I'm in the process of developing from a casual access user to professional level, and have lots of questions.
Customer Rating:
Summary: Paper Weight
Comment: Probably the worst index I have ever seen in a programmer's reference. I really don't want to have to read the entire book to find that there is little or nothing on a particular topic of interest. These 958 pages make a great paperweight.
Customer Rating:
Summary: Useful comparison of ADP versus MDB
Comment: I own this book along with Wordware's Access 2003 Programming by Example with VBA, XML and ASP. I find that this book has a more comprehensive treatement of subjects such as using ADE, Access upsizing via ADP versus MDB databases with linked tables and DAO. Granted that DAO is quite dated but its inclusion in the book is prefaced by a discussion of the advantages that it has over ADO in some limited applications. The book also tries to provide a balanced view of the advantages and disadvantages of each technology, even if it does spend more of its time concentrating on DAO.
If you are looking for a serious reference on ADO, I would suggest that you give the Wordware title serious consideration. However, if you are comparing ADP versus MDB databases in upsizing scenarios or if you are looking for a good reference on ADE which is well rounded in its description of VBA as applied to Access in general; as opposed to a specific data access model such as ADO, then this is the book for you.
The writers have done this all before and approach the subject in a narrative tone which worked for me. The section on ADP sold me on the book as I was looking at an application for upsizing an Access database to SQL server, whilst still retaining Access for the forms and reports. I was considering the two main approaches of using ADP versus MDB with linked tables and this book was able to provide me with all of the information required for me to make a sound decision.
In fact I liked it so much whilst browsing it at my local Boffins bookshop that I just had to buy it on the spot! However, whilst very good, it is not worthy of 5 stars due to its excessive focus on DAO.
|
|
|
|
|
|
|
|
