Skip to main content

Beginning Access 2007 VBA

Beginning Access 2007 VBA

Denise M. Gosnell

ISBN: 978-0-470-04684-5

Apr 2007

576 pages

Select type: Paperback

Product not available for purchase


This book provides you with the tools and techniques you’ll need in order to build more sophisticated solutions. After walking through the features of Access 2007 VBA, you’ll learn all about object-oriented programming and ADO. You’ll then progress to advanced VBA concepts such as working with external DLLs and using automation to control external programs. Plus, two comprehensive case studies presents you with the hands-on experience in building real-world solutions using the concepts covered in the book.

Chapter 1. Introduction to Access 2007 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 and SQL.

Chapter 6. Building Interactive Forms.

Chapter 7. Importing, Linking, and Exporting Using External Data Sources.

Chapter 8. Using Access with Web Services and SharePoint Lists.

Chapter 9. Creating Reports and Web-Enabled Output.

Chapter 10. Building SQL Server Applications with Access Projects.

Chapter 11. Building SQL Server Applications with Access Projects.

Chapter 12. Finishing the Application.

Chapter 13. Case Study I: Project Tracker Application.

Chapter 14. Case Study II: Customer Service Application.

Appendix A. Exercise Answers.

Code Download Download