Brilliant Access 2007 VBA

Description

When you're working on your computer and come up against a problem that you're unsure how to solve or want to accomplish something in an application that you aren't sure how to do, where do you look? Manuals and traditional training guides are too unwieldly and make it hard to get to the info you need right away, and helplines are rarely that helpful. Brilliant guides allow you to find the info you need easily and without fuss and guide you through the task using a highly visual, step-by-step approach - providing exactly what you need to know, when you need it.

Develop your Access 2007 expertise instantly with proven techniques

If you've been using Access for a little while, building databases for yourself and/or colleagues, you are ready for the next step: developing automated database applications. If you want quicker, easier, and more accurate data entry; faster searching; better reporting; the ability to manipulate data behind the scenes; and much more, this book is for you.

Brilliant Microsoft Access 2007 VBA will build upon the skills you've already developed in creating database applications and will help you take them to the next level - using Visual Basic for Applications (VBA) to accomplish things you once performed manually. 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. Brilliant Microsoft Office Access 2007 VBA is for professionals who use Microsoft Access frequently in their daily work. This book will teach you all of the essential skills you need to automate your databases as quickly as possible.

This book shows you VBA in action with real-world examples. It will introduce you to programming and its use within Access and hold your hand every step of the way. With the information provided in this book you will explore commands, functions, properties, and methods and how to use them to make your applications perform exactly as you really want them to.

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

Brilliant Microsoft Access 2007 VBA will show you how to...

· 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

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.

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.