Business solutions Automating Microsoft

Table of contents

1. Title Page
2. Copyright Page
3. Dedication
4. Contents at a Glance
5. Table of Contents
6. About the Authors
7. Acknowledgments
8. We Want to Hear from You!
9. Introduction
10. I. Laying the Foundation
    1. 1. Why Access? Why VBA?
    2. 2. Getting Around in the Visual Basic Editor
    3. 3. Using Variables, Constants, and Data Types
    4. 4. Using Procedures
    5. 5. Choosing the Right VBA Function
    6. 6. Using Flow-of-Control Statements
    7. 7. Working with Arrays
    8. 8. Understanding Objects
    9. 9. Understanding Scope and Lifetime
11. II. Working with the Access User Interface
    1. 10. Working with Forms
    2. 11. Analyzing the Access Event Model
    3. 12. Working with List and Combo Boxes
    4. 13. Working with Other Controls
    5. 14. Working with Reports
    6. 15. Working with the Application Collections
12. III. Working with Access Data
    1. 16. Retrieving Data with ADO
    2. 17. Manipulating Data with ADO
    3. 18. Creating Objects with ADOX
    4. 19. Performing Advanced Data Operations
13. IV. Using Advanced VBA Techniques in Access
    1. 20. Working with Data Files
    2. 21. Automating Other Applications
    3. 22. Working with XML Files
    4. 23. Using the Windows API
14. V. Appendix
    1. A. Review of Access SQL
15. Index