Microsoft Access 2010 VBA Programming Inside Out

by Couch, Andrew

• ISBN13: 9780735659872
• ISBN10: 0735659877
• Edition: 1st
• Format: Paperback
• Copyright: 2011-07-15
• Publisher: Microsoft Press

Summary

You're beyond the basics, so dive right in and build sophisticated and elegant business solutions with Access-using Microsoft#xAE; Visual Basic#xAE; for Applications (VBA). This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts use VBA to exploit the power of Access-and challenge yourself to new levels of mastery! Gain a deep understanding of how to design effective Access applications Get started with client-server design and cloud computing Broaden your skill set by developing applications linked to Microsoft SQL Server Support existing applications that contain a large amount of programming code Tame complex controls such as the TreeView, Tab, and ListView Use a variety of approaches to design your user interface Automate the integration of data from different sources Extend Access applications by connecting to Microsoft SharePoint#xAE; and other Microsoft Office#xAE; applications

Author Biography

Andrew Couch is a Microsoft MVP for Access and an experienced instructor who has taught Introductory and Advanced Access courses as well as VBA programming courses. He is the author of Microsoft Access 2010 VBA Programming Inside Out.

Table of Contents

Introduction

Features and Conventions Used in This Book

About the Companion Content

Acknowledgments

Support and Feedback

How to Access Your Online Edition Hosted by Safari

How to Download the Online Edition to Your Computer

VBA Environment and Language

Using the VBA Editor and Debugging Code

Understanding the VBA Language Structure

Understanding the VBA Language FeaturesAccess Object Model and Data Access Objects (DAO)

Applying the Access Object Model

Understanding the Data Access Object ModelWorking with Forms and Reports

Using Forms and Events

Using Form Controls and Events

Creating Reports and EventsAdvanced Programming with VBA Classes

Adding Functionality with Classes

Using Classes and Events

Using Classes and FormsExternal Data and Office Integration

Linking Access Tables

Integrating Microsoft OfficeSQL Server and SQL Azure

Using SQL Server

Upsizing Access to SQL Server

Using SQL AzureApplication Design

Building Applications

Using ADO and ADOX

About the Author

Table of Contents provided by Publisher. All Rights Reserved.