This book is designed to take Microsoft Access users to the next step--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.
Customer Reviews:
Avg. Customer Rating: 4.5 / 5.0
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!
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.
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... more info
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.
