Access 2003 Programming by Example with VBA, XML, and ASP
| 2005-03-01 00:00:00 | | 600 | Microsoft Access
This book is designed to take Microsoft Access users to the next step in programming. Its five parts cover an intro-duction to VBA programming, manipulating databases with ADO, using DDL, event programming, and using ASP and XML. With more than 300 hands-on examples and 11 custom projects, users can quickly build the toolset required for developing their own database solutions. Learn How To: Write and debug your programming code with the Visual Basic Editor. Understand and use common VBA programming structures such as conditions, loops, arrays, and collections. Create and manage databases with ActiveX Data Objects (ADO). Perform database tasks with Jet/Access Structured Query Language (SQL) and its Data Definition Language (DDL) component. Query and manipulate your database from a web browser with Active Server Pages (ASP). Export and import Access data to and from XML both manually and programmatically.
User review
More about VBA then Access
This book has been useful.
My only real complaint is that this book does not spend any real time talking about Access.
If you only read this book you would think you had to do everything through VBA. I can't think of too many reasons to create a table at runtime except with a query.
The book is also a little lite on real world examples.
A nice book if you are building a library of access books.
User review
What I didn't know
This book has been a tremendous help to me.
I have been a basic programmer since the 1980s, but have tried to move into object oriented programming without instruction. I purchased this book as a reference. After using it for a while as such, I decided to go completely through it - front to back, following the examples available online.
I have learned so much!
User review
Helps me a great deal - every day!
I really like this book. We still use Access 2003 at work, so I wanted a book specifically for that version and specifically for VBA. I am already a fairly experienced Access user, but was not as experienced in VBA. As anyone who's used Access knows, you need VBA to make just about anything work. I'm very pleased and have gained a great deal of experience from this book. Very good examples and written well. I'm very happy and use it nearly every day.
User review
Good Reference To Have
A book about Access that tells about the different aspects of the software as this book does is worth having on the book shelve. I recommend this book to anyone who needs as I do to have an available book to give examples as well as explain the details and tell about each area of Access databases. It's not a exhaustic concordance of Access but it has enough info to allow one to build some sophisticated databases. Not exactly for the beginning Access programmer but for the intermediate and advance programmer it would be an asset. I want go into detail but you need to read through the pages to understand the valuable resource it is. If you need reference material this book is for you.
User review
Fantastic book for intermediate-advanced users
This is not the book for beginners. But this is the book for users who have a good foundation with the basics of Access- forms, reports, and queries- and want to learn how to use VBA to improve their database. I'm working on a project where I need to reprogram many aspects of the database, and this book has been invaluable. I have plenty of Access books for reference, but this book is the secret weapon for Access programmers.