Beginning Access 2003 VBA

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.

CONTENTS:

Introduction.

  
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.

  
Appendix A: Exercise Answers.

  
Index.