From the Back Cover
VBA–Visual Basic for Applications–is built into variousMicrosoft®products, including Excel, Word, and Access. VBAenables you to add features to applications that multiply theirfunctionality, and this book will show you how to extend yourAccess applications with VBA.
You will begin with the programming life cycle, the Visual BasicEditor environment, and essential programming concepts.You’ll move through object-oriented programming concepts,learn to retrieve and update data with ADO, use VBA to createreports programmatically, export Access data to various Webformats, and migrate an existing Access database to an Accessproject that uses SQL Server®. You’ll learn advancedtopics such as working with external DLLs, handling security,creating transactions, and creating custom code libraries. You willalso learn how to distribute your application, and using two casestudies, you will apply these concepts to a project trackingapplication and a customer service application. These case studiesillustrate some of the more advanced and impressive features yourAccess applications can include, such as generating e-mailsprogrammatically.
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 updatedata
- Methods for creating reports and Web content from thedatabase
- 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 createddatabases that include tables, forms, and possibly macros. No priorexperience with 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 attorney with Woodard, Emhardt,Moriarty, McNett & Henry LLP, a worldwide intellectual propertylaw firm based in Indianapolis, Indiana. Denise has a uniquebackground in both technology and law, and presently uses her deeptechnical and legal expertise to counsel hi-tech clients onintellectual property and technical matters.
Denise has ten years of experience creating software applications,ranging from standalone and client-server to enterprise-wideapplications. Denise has worked for leading software companies suchas Microsoft and EDS, and has earned a worldwide reputation for hertechnology expertise. She received a Bachelor of Arts degree inComputer Science – Business (summa cum laude) from AndersonUniversity, and a Doctor of Jurisprudence degree from IndianaUniversity School of Law in Indianapolis.
Denise has co-authored five software development books to date:Visual Basic .NET and SQL Server 2000: Building An EffectiveData Layer
(Wrox Press), Beginning Visual Basic.NETDatabases
(Wrox Press), Professional .NET Framework
(Wrox Press), Professional SQL Server 2000
(Wrox Press), andMSDE Bible
(IDG Books). Denise was a featured technologyspeaker at the Microsoft European Professional Developer’sConference in December 2001 and has on numerous occasions assistedMicrosoft’s Training and Certification group in creating newexams for their MCSD and MCSE certifications. She herself holds theMCSD certification.
Denise can be reached at email@example.com firstname.lastname@example.org.