Higher Education

Microsoft® Access VBA Programming for the Absolute Beginner, 4th Edition

  • Michael Vine
  • ISBN-10: 1133788955  |  ISBN-13: 9781133788959
  • 400 Pages
  • Previous Editions: 2007, 2005, 2002
  • © 2012 | Published
  • College Bookstore Wholesale Price = $26.25

About

Overview

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.

Features and Benefits

  • 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.
  • Includes information on concepts such as graphical user interface development and design, data query techniques, and loops and conditions.
  • Utilizes a game-based instructional approach that helps make learning programming fun.

Table of Contents

1. An Introduction to Access 2010 .
2. Access Essentials.
3. Introduction to Access VBA.
4. Conditions.
5. Looping Structures.
6. Common Formatting and Conversion Functions.
7. Code Reuse and Data Structures.
8. Debugging, Input Validation, File Processing, and Error Handling.
9. Microsoft Access SQL.
10. Database Programming with ADO.
11. Object-Oriented Programming with Access
12. Macros and Performance Tuning.
Appendix A: Common Character Codes.
Appendix B: Keyboard Shortcuts for the Code Window.
Appendix C: Trappable Errors.
Appendix D: Visual Basic Environment Options.
Appendix E: Reserved Words and Symbols.
Index.

What's New

  • Teaches readers the basics of computer programming using the Microsoft Access 2010 VBA language.

Meet the Author

Author Bio

Michael Vine

Michael Vine is a senior IT professional who specializes in data warehousing and business intelligence. Beyond corporate life, he has taught computer science classes at the university and college level and authored many software programming books.