Microsoft Office Access 2007 VBA - Softcover

Diamond, Scott B.

Softcover

ISBN 10: 0789737310 ISBN 13: 9780789737311

Publisher: Que, 2007

Synopsis

An indispensible, well-organized reference and guide to developing Access applications and automating daily task Even if reader never programmed before, they can learn how to use VBA to make work with Access more productive than ever before Teaches real-life techniques to help the reader more easily navigate applications Builds on the Access skills needed in a business setting and helps reader do their job more quickly and efficiently

About this title

About the Author

Scott B. Diamond has been an information technology geek for more than 20 years. He has spent much of that time designing databases on various platforms. He started using Microsoft Access with Office 97 and has mastered all the subsequent versions. Besides developing database applications for the company where he’s employed as an applications administrator, Scott also does freelance work, developing Access applications and consulting. He has always maintained that he’s lucky his vocation is also his avocation, so he spends some of his free time helping people on web-based Q&A boards such as utteraccess.com (the premier support site for Access). He recently received Microsoft’s MVP award for Access in acknowledgment of his contribution to the Access community. Scott, an avid bicyclist, lives on Long Island, New York, with his wife and daughter. You can reach Scott at AccessVBA@diamondassoc.com or visit his website, www.diamondassoc.com.

 

Brent Spaulding started writing applications about 20 years ago, generally focusing on data and data analysis. He has designed systems that have a wide range of focus: gymnastics class management, product assembly analysis, equipment fault logging, and manufacturing management systems. He has used Microsoft Access since version 2.0 and looks forward to using Access well into the future. In July 2007 Brent, who is employed in the automotive industry, received the Microsoft MVP award for Access, which recognizes his talent and contribution to the Access community. He spends much of his personal time learning and helping others on websites such as utteraccess.com, where he is known as datAdrenaline.

 

Brent lives in southern Indiana with his wife and children.

 

From the Back Cover

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 year

Edition details

• Publisher: Que
• Publication date: 2007
• ISBN 10: 0789737310
• ISBN 13: 9780789737311
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 408