Beginning Access™ 2007 VBA

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