loading 
register   login

Access 2007 Programming by Example with VBA, XML, and ASP (Wordware Database Library)

by: Julitta Korol
en | Wordware Publishing, Inc.

159822042X  9781598220421  9781435681415 

Access 2007 Programming by Example with VBA, XML, and ASP (Wordware Database Library)
By Julitta Korol




Product Description:

Access 2007 Programming by Example with VBA, XML, and ASP shows non-programmers how Access databases can be created, managed, and customized with Visual Basic for Applications (VBA) -- a powerful programming language built into Access. Hundreds of hands-on examples and projects throughout the book show users how to take charge of their Access databases with programming.

Learn how to: * Write and debug your programming code with the Visual Basic Editor. * Access and manipulate databases with Data Access Objects (DAO) and ActiveX Data Objects (ADO). * Use the Data Definition Language (DDL) to enforce data integrity and manage database security. * Modify the behavior of forms, reports, and controls by writing event procedures. * Publish dynamic Access data to the web using Active Server Pages (ASP) and Extensible Markup Language (XML). * Work with the new features for tables, forms, reports, macros, and templates that are available in the Access 2007 user interface.




Summary: This is the way to learn to program Access
Rating: 5

I have been trying to learn how to program Access for a few years and this is the only book that I am confident will help me master programming Access 2007. I purchased the Access 2003 version last year and then the 2007 Access a couple months ago. To my surprise, Ms. Korol had added more than 200 pages to ensure that folks understand how to use Access 2007's new features, including the Multi-value Data Type, Attachment Data Type, Append Only Memo Field, Rich Text Memo Field, and PDF/XPS files. Although I have not studied it yet, there's an entire chapter on customizing the Ribbon.

The very best aspect of the book is that it contains code samples for just about everything that you'll need to build a robust Access application. Most code samples are given as both DAO and ADO.

You'll still need other books in your Access library but you'll probably want two copies of Access 2007 Programming by Example -- one for home and one for the office. This book will save you lots of time on user community boards whether you are a beginner or an advanced developer. And although the first section says no previous programming experience is necessary, I would still recommend a beginning Access VBA course or programming class.



Summary: Just what Access programmers need
Rating: 5

There are many books on Access development using VBA. Most are written for those who are new to writing code or those who have limited experience.

For those who have been programming for some time, this book will give a rush. Ms. Korol does an excellent job of getting right to the core of her examples. Not only does she show code (and excellent code, at that), she also shows both DAO and ADO. When most other authors preface their books with a paragraph about DAO being dead, Ms. Korol does what is so needed - she keeps DAO alive. And, she travels farther using XML and ASP in easy to understand examples.

If you're new to development with Access, I would still recommend this book because some day you'll be looking for a procedure to accomplish some task and need help. All you'll have to do is look in the index for ideas.

Thank you, Ms. Korol, for taking what must have been a great deal of time and writing a book for me (and, of course, others, too).



Summary: Great Books - Excellent for Access VBA Work
Rating: 5

If you are looking for a book to learn basics of Microsoft Access then you are looking at the wrong book. If you want to impress your boss with Access Macros, it is again a wrong book.
It is however an excellent book that covers the whole nine-yard of Microsoft Access VBA development. It starts out directly into basics of Modules and Visual Basic Editor environment. Takes you quickly through basics of VBA. This is followed by details on how you can use VBA on MS Access Database (and on other external databases through MS Access). Book lives up to its title, it is loaded with excellent examples of VBA code. I read through some of the other Access VBA books before getting this book and on side-by-side comparison; this book stands out in depth, examples and detail.