You are previewing Microsoft® Access VBA Programming for the Absolute Beginner.
O'Reilly logo
Microsoft® Access VBA Programming for the Absolute Beginner

Book Description

Developed by computer science instructors, books in the for the absolute beginner™ series teach the principles of programming through simple game creation. Get the jump on computer programming and database concepts with MICROSOFT ACCESS VBA PROGRAMMING FOR THE ABSOLUTE BEGINNER, FOURTH EDITION. In this book, you'll learn the fundamental concepts of computer programming with Microsoft Access 2010 VBA, including variables, conditions, loops, arrays, procedures, and functions. You'll also learn about object relational database design, beginning SQL concepts, reports, and database programming using VBA. And if you're new to relational databases or Microsoft Access, don't worry--the book includes an introduction to Microsoft Access 2010 and beginning database concepts. Updates include coverage of enhancements and new technologies released in Microsoft Access 2010, including new user interface upgrades, new data types, VBA functions, and macros. Each chapter includes a chapter-based program designed around simple games, for a fun approach to learning. Featuring easy-to-read, step-by-step instruction, MICROSOFT ACCESS VBA PROGRAMMING FOR THE ABSOLUTE BEGINNER, FOURTH EDITION is the fast, easy way to learn Access VBA programming.

Table of Contents

  1. Title Page
  2. Copyright Page
  3. Dedication
  4. ACKNOWLEDGMENTS
  5. ABOUT THE AUTHOR
  6. TABLE OF CONTENTS
  7. INTRODUCTION
  8. CHAPTER 1 AN INTRODUCTION TO ACCESS 2010
    1. WHAT IS MICROSOFT ACCESS?
    2. ACCESS VS. EXCEL
    3. MICROSOFT ACCESS 2010 LIMITATIONS
    4. SYSTEM REQUIREMENTS
    5. WORKING WITH OLDER DATABASE FORMATS
    6. WHAT’S NEW IN ACCESS 2010
    7. SUMMARY
  9. CHAPTER 2 ACCESS ESSENTIALS
    1. DATABASE NORMALIZATION
    2. CREATING A NEW ACCESS 2010 DATABASE
    3. TABLES AND FIELDS
    4. TABLE RELATIONSHIPS
    5. FORMS
    6. QUERIES
    7. SUMMARY
  10. CHAPTER 3 INTRODUCTION TO ACCESS VBA
    1. THE EVENT-DRIVEN PARADIGM
    2. OBJECT-BASED PROGRAMMING
    3. THE VBA IDE
    4. ACCESSING OBJECTS AND THEIR PROPERTIES
    5. VARIABLES AND BEGINNING DATA TYPES
    6. VBA ARITHMETIC AND ORDER OF OPERATIONS
    7. CHAPTER PROGRAM: FRUIT STAND
    8. SUMMARY
  11. CHAPTER 4 CONDITIONS
    1. IF BLOCKS
    2. SELECT CASE STRUCTURES
    3. DIALOG BOXES
    4. COMMON CONTROLS CONTINUED
    5. CHAPTER PROGRAM: HANGMAN
    6. SUMMARY
  12. CHAPTER 5 LOOPING STRUCTURES
    1. INTRODUCTION TO LOOPING STRUCTURES
    2. LIST AND COMBO BOXES
    3. RANDOM NUMBERS
    4. CHAPTER PROGRAM: MATH QUIZ
    5. SUMMARY
  13. CHAPTER 6 COMMON FORMATTING AND CONVERSION FUNCTIONS
    1. STRING-BASED FUNCTIONS
    2. DATE AND TIME FUNCTIONS
    3. CONVERSION FUNCTIONS
    4. FORMATTING
    5. CHAPTER PROGRAM: SECRET MESSAGE
    6. SUMMARY
  14. CHAPTER 7 CODE REUSE AND DATA STRUCTURES
    1. CODE REUSE
    2. STANDARD MODULES
    3. ARRAYS
    4. USER-DEFINED TYPES
    5. CHAPTER PROGRAM: DICE
    6. SUMMARY
  15. CHAPTER 8 DEBUGGING, INPUT VALIDATION, FILE PROCESSING, AND ERROR HANDLING
    1. DEBUGGING
    2. INPUT VALIDATION
    3. ERROR HANDLING
    4. FILE PROCESSING
    5. CHAPTER PROGRAM: TRIVIAL CHALLENGE
    6. SUMMARY
  16. CHAPTER 9 MICROSOFT ACCESS SQL
    1. INTRODUCTION TO ACCESS SQL
    2. DATA MANIPULATION LANGUAGE
    3. DATA DEFINITION LANGUAGE
    4. SUMMARY
  17. CHAPTER 10 DATABASE PROGRAMMING WITH ADO
    1. ADO OVERVIEW
    2. CONNECTING TO A DATABASE
    3. WORKING WITH RECORDSETS
    4. CHAPTER PROGRAM: CHOOSE MY ADVENTURE
    5. SUMMARY
  18. CHAPTER 11 OBJECT-ORIENTED PROGRAMMING WITH ACCESS VBA
    1. WORKING WITH COLLECTIONS
    2. INTRODUCTION TO OBJECT-ORIENTED PROGRAMMING
    3. CREATING CUSTOM OBJECTS
    4. CHAPTER PROGRAM: MONSTER DATING SERVICE
    5. SUMMARY
  19. CHAPTER 12 MACROS AND PERFORMANCE TUNING
    1. MACROS
    2. ACCESS DATABASE PERFORMANCE CONSIDERATIONS
    3. SUMMARY
  20. APPENDIX A COMMON CHARACTER CODES
  21. APPENDIX B KEYBOARD SHORTCUTS FOR THE CODE WINDOW
  22. APPENDIX C TRAPPABLE ERRORS
  23. APPENDIX D VISUAL BASIC ENVIRONMENT OPTIONS
  24. APPENDIX E RESERVED WORDS AND SYMBOLS
  25. INDEX