Microsoft Office Access 2007 VBA

Business SolutionsMicrosoft® Office Access 2007 VBADevelop your Access 2007 VBA expertise instantly with proven techniquesMicrosoft 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 i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ ·i¾ i¾ i¾ i¾ i¾ i¾ i¾ Navigating within the Visual Basic Editor i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ ·i¾ i¾ i¾ i¾ i¾ i¾ i¾ Using variables, constants, and data types i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ ·i¾ i¾ i¾ i¾ i¾ i¾ i¾ Employing built-in functions i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ ·i¾ i¾ i¾ i¾ i¾ i¾ i¾ Creating procedures i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ ·i¾ i¾ i¾ i¾ i¾ i¾ i¾ Understanding object-and event-driven coding i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ ·i¾ i¾ i¾ i¾ i¾ i¾ i¾ Working with arrays i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ ·i¾ i¾ i¾ i¾ i¾ i¾ i¾ Understanding scope i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ ·i¾ i¾ i¾ i¾ i¾ i¾ i¾ Working with forms i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ ·i¾ i¾ i¾ i¾ i¾ i¾ i¾ Using selection controls i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ ·i¾ i¾ i¾ i¾ i¾ i¾ i¾ Creating reports i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ ·i¾ i¾ i¾ i¾ i¾ i¾ i¾ Exploring menus, navigation, and ribbons i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ ·i¾ i¾ i¾ i¾ i¾ i¾ i¾ Using object models i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ ·i¾ i¾ i¾ i¾ i¾ i¾ i¾ Working with data i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ ·i¾ i¾ i¾ i¾ i¾ i¾ i¾ Defining database schema i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ ·i¾ i¾ i¾ i¾ i¾ i¾ i¾ Using the Windows API i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ ·i¾ i¾ i¾ i¾ i¾ i¾ i¾ Working with XML files i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ ·i¾ i¾ i¾ i¾ i¾ i¾ i¾ Exploring Access SQLOn the WebsiteDownload database files used in the book at www.quepublishing.com.Category i¾ i¾ i¾ Office Applications Coversi¾ i¾ i¾ i¾ i¾ i¾ i¾ i¾ Visual Basic for Applicationsi¾ User Leveli¾ i¾ i¾ Intermediate - AdvancedScott 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 codeUse looping and conditional statementsUnderstand the Access object- and event-driven architectureAutomate data entryLearn how to use variables for dynamic automationCreate user-friendly applications for othersCreate custom functions and objectsCustomize the user interfaceManipulate data and objects with code