Microsoft® Access VBA Programming for the Absolute Beginner

  • AUTHOR: Michael Vine
  • ISBN-13: 9781133788959 
  • Grade(s): 9 | 10 | 11 | 12
  • 400 Pages  Paperback 
  • 4th Edition  |  Previous Editions: 2007, 2005, 2002
  • ©2012     Published
  • Prices are valid only in the respective region

Overview

About The Product

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

  • 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.

About the Contributor

AUTHOR
  • 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.

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.

New to this Edition

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