Business Solutions

Microsoft® Office Access 2007 VBA

Develop your Access 2007 VBA expertise instantly with proven techniques

Microsoft Office Access 2007 VBA builds on the skills you’ve already developed in creating database applications and helps you take them to the next level—using Visual Basic for Applications (VBA) to accomplish things you once performed manually. To facilitate this lofty goal, Access includes the VBA programming language. Even if you’ve never programmed, this book will help you learn how to leverage the power of VBA to make your work with Access more efficient than ever before. Microsoft Office Access 2007 VBA is for professionals who use Microsoft Access frequently in their daily work. You have serious work to get done and you can’t spend all day reading a computer book. This book teaches you the essential skills you need to automate your databases as quickly as possible.

Although written for Access 2007, the techniques and concepts covered will work in most versions of Microsoft Access.

Highlights of This Book Include

          •        Navigating within the Visual Basic Editor

          •        Using variables, constants, and data types

          •        Employing built-in functions

          •        Creating procedures

          •        Understanding object-and event-driven coding

          •        Working with arrays

          •        Understanding scope

          •        Working with forms

          •        Using selection controls

          •        Creating reports

          •        Exploring menus, navigation, and ribbons

          •        Using object models

          •        Working with data

          •        Defining database schema

          •        Using the Windows API

          •        Working with XML files

          •        Exploring Access SQL

On the Website

Download database files used in the book at www.quepublishing.com.

Category     Office Applications

Covers         Visual Basic for Applications 

User Level    Intermediate - Advanced

Scott B. Diamond is a seasoned database designer and Microsoft Access 2007 MVP. During the last 20+ years, he has designed databases on a wide range of platforms, including dBASE, FoxPro, SQL/DS, Lotus Approach, Lotus Notes, and, for the past 10 years, Microsoft Access. Scott has worked as a consultant, both in-house and freelance, and as a support professional at firms that are among the leaders in their industries. Scott spends some of his free time answering questions at the premier site for Access support: http://www.utteraccess.com.

Brent Spaulding started writing applications about 20 years ago and has utilized Microsoft Access since version 2.0. He looks forward to using Access well into the future. In July 2007, he received the Microsoft MVP award for Access, which recognizes his talent and contributions to the Access community.

Front cover bullets:

Edit and debug your code

Use looping and conditional statements

Understand the Access object- and event-driven architecture

Automate data entry

Learn how to use variables for dynamic automation

Create user-friendly applications for others

Create custom functions and objects

Customize the user interface

Manipulate data and objects with code

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 4 Ratings

Excellent book - 2008-05-03
Reviewer Rating:
I found this to be an incredible book. When I began using the book I was a novice Access user. The book was an incredible tool to vastly improving my knowledge of Access and it's use in the business world. I own a business and with the help of this book I created a database to run the entire operation.

Very poorly written and a waste of Money - 2008-03-09
Reviewer Rating:
Very poorly written and a complete waste of money. There are many more helpful books written by competent authors right here on Amazon. 1 star.

Leverage the database power of MS Access v 2007 with VBA. - 2009-04-15
Reviewer Rating:
This is a very good book to learn or review the programming language applied to MS Access, which is a solid database tool. I've purchased many similar books since 1997, but I like this one best of all.

Microsoft Office Access 2007 VBA - 2009-01-19
Reviewer Rating:
Very good book detailing the different aspects overall of VBA without the needed detail. This book makes a better reference tool since its content makes it easier and quicker to find what you need for a given VBA code question.

Browse Similar Topics

Top Level Categories:
Desktop Applications
Programming

Sub-Categories:
Desktop Applications > Access
Programming > Visual Basic for Applications