OverviewBusiness 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
