You are previewing Beginning Access™ 2007 VBA.
O'Reilly logo
Beginning Access™ 2007 VBA

Book Description

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.

Table of Contents

  1. Copyright
  2. About the Author
  3. Credits
  4. Dedication
  5. Acknowledgments
  6. Introduction
  7. Introduction to Access 2007 VBA
    1. What Is Access 2007 VBA?
    2. What's New in Access 2007 VBA?
    3. Access 2007 VBA Programming 101
    4. Summary
    5. Exercises
  8. The Basics of Writing and Testing VBA Cod
    1. Creating Modules
    2. Standard Modules versus Class Modules
    3. Creating and Calling Procedures
    4. Using Variables and Constants to Store Values
    5. Controlling Program Flow
    6. Documenting Your Code
    7. Error Debugging
    8. Error Handling
    9. Summary
    10. Exercises
  9. Programming Applications Using Object
    1. Elements of an Object
    2. Viewing Objects Using the Object Browser
    3. Ways to Refer to Objects
    4. Using Access Collections and Objects
    5. Summary
    6. Exercises
  10. Creating Your Own Object
    1. Using Class Modules to Create Your Own Objects
    2. Create Custom Properties for Existing Objects
    3. Create Custom Methods for Existing Objects
    4. Summary
    5. Exercises
  11. Interacting with Data Using ADO and SQL
    1. Introduction to Data Access
    2. Using ADODB to Work with Data
    3. Introduction to SQL
    4. Using ADOX to Manipulate Data Objects
    5. Summary
    6. Exercises
  12. Building Interactive Form
    1. Form Navigation and Flow
    2. Working with Controls
    3. Building User Interaction
    4. Adding Polish to Your Forms
    5. Summary
    6. Exercises
  13. Importing, Linking, and Exporting Using External Data Source
    1. Linking, Importing, and Exporting Overview
    2. Access and Other Databases
    3. Transferring Complete SQL Server Database
    4. Spreadsheets
    5. Text Files
    6. XML Files
    7. E-mails and Outlook
    8. Other Ways to Export Data
    9. Summary
    10. Exercises
  14. Using Access with Web Services and SharePoint List
    1. Introduction to Web Services
    2. Using Data from Web Services
    3. Introduction to SharePoint Lists
    4. Using Data from SharePoint Lists
    5. Summary
    6. Exercises
  15. Creating Reports and Web-Enabled Outpu
    1. Working with Reports from VBA
    2. Exporting Access Data to Web Formats
    3. Summary
    4. Exercises
  16. Building SQL Server Applications with Access Project
    1. Access Projects—Using Access as a Front End to SQL server
    2. Setting Up SQL Server
    3. Creating Access Projects (ADPs)
    4. Working with SQL Server Objects from Access
    5. Migrating an Existing Access Database to an Access Project
    6. Summary
    7. Exercises
  17. Advanced Access Programmin
    1. Using Dynamic Link Libraries (DLLs)
    2. Automation
    3. ActiveX Controls
    4. Libraries
    5. Add-Ins
    6. Transactions
    7. Summary
    8. Exercises
  18. Finishing the Applicatio
    1. Multiuser Considerations
    2. Optimizing Your Applications
    3. Securing Your Application
    4. Distributing Your Application
    5. Maintaining the Application
    6. Summary
    7. Exercises
  19. Case Study 1: Project Tracker Application
    1. Design Specifications
    2. Building the Database
    3. Building the User Interface
    4. Building the Class Modules for the Objects
    5. Building the Standard Modules
    6. Connecting the User Interface to the Code
    7. Touring the Finished Project Tracker Application
    8. Summary
  20. Case Study 2: Customer Service Applicatio
    1. Design Specifications
    2. Building the Database and Database Objects
    3. Building the User Interface
    4. Building the Class Module for the Objects
    5. Building the Standard Modules
    6. Connecting the User Interface to the Code
    7. Touring the Finished Customer Service Application
    8. Summary
  21. Exercise Answers
    1. Chapter 1
    2. Chapter 2
    3. Chapter 3
    4. Chapter 4
    5. Chapter 5
    6. Chapter 6
    7. Chapter 7
    8. Chapter 8
    9. Chapter 9
    10. Chapter 10
    11. Chapter 11
    12. Chapter 12
  22. Index