0%

Book Description

If you use Microsoft Access in your every day business life but haven't learned to fully exploit the program, now's your chance. Automating Microsoft Access with VBA is a thorough introduction to programming Microsoft Accessing using Visual Basic for Applications (VBA). With this book, you will gain a working knowledge of VBA and be able to customize your Microsoft Access databases. You will cover topics that include:

  • Operators and functions

  • Debugging and error handling

  • Menu commands

  • Forms and reports

  • Jet databases

  • DAO object model

Save money by learning to use VBA to customize your databases instead of paying someone else to do it for you!

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
18.190.219.65