Access 2010 Programmer's Reference

Front Cover
John Wiley & Sons, Oct 28, 2010 - Computers - 1272 pages
A comprehensive guide to programming for Access 2010 and 2007

Millions of people use the Access database applications, and hundreds of thousands of developers work with Access daily. Access 2010 brings better integration with SQL Server and enhanced XML support; this Wrox guide shows developers how to take advantage of these and other improvements.

With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic.

Access 2010 Programmer's Referenceis a comprehensive guide to the best-of-breed techniques for programming Access applications.

Coverage Includes:

  • Introduction to Microsoft Access 2010
  • New Features
  • Upgrading and Converting to Access 2010
  • Macros in Access 2010
  • Using the VBA Editor
  • VBA Basics
  • Using VBA in Access
  • Creating Classes in VBA
  • Extending VBA with APIs
  • Working with the Windows Registry
  • Using DAO to Access Data
  • Using ADO to Access Data
  • Using SQL with VBA
  • Using VBA to Enhance Forms
  • Enhancing Reports with VBA
  • Customizing the Ribbon
  • Customizing the Office Backstage
  • Working with Office 2010
  • Working with SharePoint
  • Working with .NET
  • Building Client-Server Applications with Access
  • The Access 2010 Templates
  • Access Runtime Deployment
  • Database Security
  • Access 2010 Security Features

From inside the book

Selected pages

Contents

Section 1
176
Section 2
179
Section 3
180
Section 4
181
Section 5
188
Section 6
191
Section 7
192
Section 8
194
Section 20
215
Section 21
221
Section 22
672
Section 23
678
Section 24
684
Section 25
685
Section 26
695
Section 27
696

Section 9
196
Section 10
197
Section 11
200
Section 12
202
Section 13
203
Section 14
204
Section 15
205
Section 16
206
Section 17
212
Section 18
213
Section 19
214
Section 28
698
Section 29
701
Section 30
705
Section 31
760
Section 32
779
Section 33
783
Section 34
785
Section 35
786
Section 36
787
Section 37
788
Section 38
791

Other editions - View all

Common terms and phrases

About the author (2010)

Teresa Hennig is a Microsoft Access MVP, and is President of the Seattle Access Group and the Pacific Northwest Access Developer Group. Her company, Data Dynamics NW, has been creating Access solutions since 1997.

Rob Cooper is a senior test lead at Microsoft. During the Access 2010 release, he led the team that worked on exciting new features such as the Macro Designer, Navigation Control, and Web Browser Control.

Geoffrey Griffith has more than 13 years experience with Access. He began his Access life working in Access 2.0 and eventually worked on the Microsoft Access Team for the Access 2007 release.

Jerry Dennison is a Microsoft Access MVP and has been developing custom and commercial Access applications since 1991. He is the owner of TradeIt! Software Support Services, an Access-based barter management solution.

Bibliographic information