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 2010New FeaturesUpgrading and Converting to Access 2010Macros in Access 2010Using the VBA EditorVBA Basics Using VBA in AccessCreating Classes in VBA Extending VBA with APIsWorking with the Windows Registry Using DAO to Access Data Using ADO to Access DataUsing SQL with VBA Using VBA to Enhance FormsEnhancing Reports with VBA Customizing the Ribbon Customizing the Office BackstageWorking with Office 2010 Working with SharePointWorking with .NET Building Client-Server Applications with AccessThe Access 2010 Templates Access Runtime DeploymentDatabase SecurityAccess 2010 Security Features.