Self-Help Books from Cengage Learning PTR

Microsoft® Access VBA Programming for the Absolute Beginner

Microsoft® Access VBA Programming for the Absolute Beginner

ISBN 13: 9781133788959

ISBN 10: 1133788955

Author: Michael Vine

Pages: 400

Published: 12/30/2011

Print Book Price: $34.99 Add to cart

eBook Price: $17.14 Add to cart

eBook Download Instructions

Companion downloads

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.
Note*: If you are buying the e-book version of this product, any CD/DVD supplement files referenced throughout the book can be accessed for free at our Companion Downloads page.
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.
  • Teaches readers the basics of computer programming using the Microsoft Access 2010 VBA language.
  • 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.
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.
cover image - Microsoft® Access VBA Programming for the Absolute Beginner
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.
Sample Chapters