From the Back Cover
If you want to take your Access databases to a more robust level offunctionality, then this is the book for you. It provides the toolsand techniques you'll need in order to build more sophisticatedsolutions. You'll find plenty of source code and fully developedsample applications to guide you along the way.
After walking through the features of Access 2007 VBA, you'lllearn all about object-oriented programming and ADO. You'll thenprogress to advanced VBA concepts such as working with externalDLLs and using automation to control external programs. And withthe help of two comprehensive case studies, you'll gain hands-onexperience in building real-world solutions using the conceptscovered in the book.
From creating custom objects and reports programmatically tointegrating Access with web services and SQL Server, this hands-onguide gets you started quickly.
What you will learn from this book
- Techniques for using ActiveX® Data Objects (ADO) toretrieve and update data
Steps for building reports and web content from the database
How to develop SQL Server solutions with Access projects
Tips for fine-tuning and distributing your application
Ways to import, link, and export data to and from external datasources
How to send emails programmatically from your database
How to create interactive forms, export data to HTML, enhancesecurity, and much more
Who this book is for
This book is for the Access 2007 user who is just gettingstarted in creating their own applications as well as theprogrammer who is new to Access development. No prior experiencewith VBA is required.
Wrox Beginning guides are crafted to make learningprogramming languages and technologies easier than you think,providing a structured tutorial format that will guide you throughall the techniques involved.
About the Author
is a software patent attorney and technologyconsultant with Gosnell & Associates, Inc., which she foundedin 2005. Denise has a unique background in both technology and law,and presently uses her deep technical and legal expertise tocounsel hi-tech clients on intellectual property and technicalmatters. Denise was recognized in February 2005 with theIndianapolis Business Journal
award: “Top 40 Under40,” which recognizes the top up-and-coming professionalsunder the age of 40 in the city of Indianapolis each year. She alsoappeared on the Inside Indiana Business with Gerry Dick
television show in March 2005 to discuss hi-tech issues facing thebusiness world.
Denise has over 12 years of experience in creating softwareapplications, ranging from standalone and client-server toenterprise-wide applications. Denise has worked for leadingsoftware companies such as Microsoft and EDS, and has earned aworldwide reputation for her technology expertise. She received abachelor of arts degree in Computer Science–Business (summacum laude) from Anderson University, where she currently serves asan adjunct professor for the Computer Science Department. Deniseobtained a doctor of jurisprudence degree from Indiana UniversitySchool of Law in Indianapolis.
Denise has authored and coauthored seven other software developmentbooks to date, covering topics such as database development,Access, Visual Basic .NET, and web services. Most recently, Deniseauthored Professional Development with Web APIs
(Wiley 2005)and Beginning Access 2003 VBA
(Wiley 2004). Denise was afeatured technology speaker at the Microsoft European ProfessionalDeveloper’s Conference in December 2001 and has on numerousoccasions assisted Microsoft’s Training and Certificationgroup in creating new exams for their MCSD and MCSE certifications.