Microsoft Office 2007 is a big improvement from the last version of Office, Access will also be revised. Alison Bälter is the name of the developer access will trust to guide them through the new features Access 2007's. He has an ability rare to take a complex topic and explain it clearly, as shown by the success of ten previous books on Access. Bälter known to provide real-world solutions to specific Access development problems. He is also known for its ability to return her practical examples with just enough underlying theory to give the reader a good overall understanding of Access. In short, this book will give beginning and intermediate Access developers with everything they need to know to design and build Access 2007 applications. It should also appeal to DBAs and power users who want or need to start building a custom Access application. Access the latest book in the series Mastering it will not disappoint her many fans are anxiously awaiting each new version, and should win new fans as well. Introduction Part I Basics of Access Development 1 Access as a Development Tool. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 2 What Every Developer Needs to Know About Databases and Tables. . . . . . . 75 3 Relationships: Your Key to Data Integrity. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115 4 What Every Developer Should Know About Query Basics. . . . . . . . . . . . . . . . . 137 5 What Every Developer Needs to Know About Forms. . . . . . . . . . . . . . . . . . . . . . . . . . 189 6 What Every Developer Needs to Know About Reports. . . . . . . . . . . . . . . . . . . . . . . . 269 7 Are Macros, and When You Need Them? . . . . . . . . . . . . . . . . . . . . . 315 8 VBA: An Introduction. . 345 9 Objects, Properties, Methods, and Events Explained. . 401 10 Advanced Form Techniques. . . . . . . . . . . . . 431 11 Advanced Report Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 493 12 Advanced Query Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 539 13 Advanced VBA Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 599 14 Use of Power Module Class. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 637 15 What is ActiveX Data Objects, and Why Are They Important?. . . . . . . . . . 671 Part II What to Do When It Don? T Go as Plan 16 Debugging: Your Key to Success for Development. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 727 17 Error Handling: Preparing for the Inevitable. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 755 18 Optimizing Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 801 Part III Developing Enterprise Applications and multiuser 19 A Strategy for Developing Access Applications. . . . . . . . . . . . . . . . . . . . . . . . . 835 20 Using External Data. 847 21 Access 2007 and SharePoint. . 883 22 Developing Applications multiuser and Enterprise. . 909 </ P> 00_0672329328_FM.qxd 05/04/2007 09:23 Page iii