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.
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.
Chapter 1 Introduction to Access 2003 VBA
Chapter 2 The basics of writing and testing VBA code
Chapter 3 Programming applications using objects
Chapter 4 Creating your own objects
Chapter 5 Interacting with data using ADO and SQL
Chapter 6 Building interactive forms
Chapter 7 Importing, linking, and exporting using external
data sources
Chapter 8 Creating reports and Web-enabled output
Chapter 9 Building SQL server applications with Access
Projects
Chapter 10 Advanced Access programming
Chapter 11 Finishing the application
Chapter 12 Case study 1 : project tracker application
Chapter 13 Case study 2 : customer service application