Product Description

What is this book about?

Written by an Access programmer with more than 10 years of VBA experience, this is the perfect guide for Access users who are ready to take their databases to the next level, or for programmers who are new to Access or VBA.  Veteran Access developer Denise Gosnell shows readers the ins and outs of Access VBA and provides plenty of source code, and fully developed sample applications to guide you along the way.

Not only do readers learn to build “stand–alone” desktop applications, but readers also learn how to integrate Access applications with Web Services, and SQL Server.

Product Details

• Amazon Sales Rank: #331238 in Books
• Published on: 2004-09-24
• Original language: English
• Number of items: 1
• Binding: Paperback
• 552 pages

From the Back Cover
VBA–Visual Basic for Applications–is built into various Microsoft®products, including Excel, Word, and Access. VBA enables you to add features to applications that multiply their functionality, and this book will show you how to extend your Access applications with VBA.

You will begin with the programming life cycle, the Visual Basic Editor environment, and essential programming concepts. You’ll move through object–oriented programming concepts, learn to retrieve and update data with ADO, use VBA to create reports programmatically, export Access data to various Web formats, and migrate an existing Access database to an Access project that uses SQL Server®. You’ll learn advanced topics such as working with external DLLs, handling security, creating transactions, and creating custom code libraries. You will also learn how to distribute your application, and using two case studies, you will apply these concepts to a project tracking application and a customer service application. These case studies illustrate some of the more advanced and impressive features your Access applications can include, such as generating e–mails programmatically.

What you will learn from this book

• Object–oriented programming techniques using VBA
• How to use built–in objects and create your own
• How to use ActiveX Data Objects (ADO) to retrieve and update data
• Methods for creating reports and Web content from the database
• Techniques for integrating with Office applications
• How to build SQL Server solutions with Access projects

Who this book is for

This book is for Access users and programmers who have created databases that include tables, forms, and possibly macros. No prior experience with VBA is required.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

About the Author
Denise Gosnell is a software attorney with Woodard, Emhardt, Moriarty, McNett & Henry LLP, a worldwide intellectual property law firm based in Indianapolis, Indiana. Denise has a unique background in both technology and law, and presently uses her deep technical and legal expertise to counsel hi–tech clients on intellectual property and technical matters.
Denise has ten years of experience creating software applications, ranging from standalone and client–server to enterprise–wide applications. Denise has worked for leading software companies such as Microsoft and EDS, and has earned a worldwide reputation for her technology expertise. She received a Bachelor of Arts degree in Computer Science – Business (summa cum laude) from Anderson University, and a Doctor of Jurisprudence degree from Indiana University School of Law in Indianapolis.
Denise has co–authored five software development books to date: Visual Basic .NET and SQL Server 2000: Building An Effective Data Layer (Wrox Press), Beginning Visual Basic.NET Databases (Wrox Press), Professional .NET Framework (Wrox Press), Professional SQL Server 2000 (Wrox Press), and MSDE Bible (IDG Books). Denise was a featured technology speaker at the Microsoft European Professional Developer’s Conference in December 2001 and has on numerous occasions assisted Microsoft’s Training and Certification group in creating new exams for their MCSD and MCSE certifications. She herself holds the MCSD certification.
Denise can be reached at dgosnell@uspatent.com or denisegosnell@yahoo.com.

Customer Reviews

Not for beginners
This is just another book about Access that describes itself as being for beginners. Like all of the rest I have seen it totally fails.
The first few pages were quite promising and I thought this was a book I would be comfortable with. However I should have known from the introduction that things may go wrong when the author questioned whether to discuss DAO or ADO. What do these terms mean to a Beginner?
Chapter 2 was the next crunch when the subject of declaring arrays was thrown into the arena. Code was provided without any explaination whatsoever. Fortunateley I had another book that contained a section which gave an explaination of the subject.
I have yet to find a book on this subject in which the author can explain the terminology before launching into it.

Broad overlook of vba but does not go into detail
i found when reading this book gives a general idea of vba but doesn't go into the depth that i thought it would. One very fustrating thing that happens throughout the book is that the author give your website refrences to learn more about the subject.
The book also starts of "If there are any mistakes please post on the website" this is very discouraging and there are mistakes and for someone who wants to learn vba this can be very confusing.

Fantastic book - a must for anyone wanting to expand their access knowledge
This book should be on every access user's bookshelf. I agree in part with the reviewer who said its not for the beginner.

This book should be bought after you've read microsoft press step by step book. The two case studies at the end of the book are first rate - far better than i've seen in any other (and i have alot of access and dbms books) the exercises develop you steadily and carefully till the end.

I keep going back to it, years after I bought it.