{"product_id":"9780672329326","title":"Alison Balter's Mastering Microsoft Office Access 2007 Development","description":"\u003cp\u003eMicrosoft Office 2007 is a major upgrade from the last version of Office; Access will also be greatly revised. Alison Balter is the name that Access developers will trust to guide them through Access 2007's new features. She has the rare ability to take complex topics and explain them clearly, as shown by the success of her ten previous books on Access. Balter is known for providing real-world solutions to specific Access development problems. She also is known for her ability to back up her practical examples with just enough underlying theory to give the reader a good overall understanding of Access. In short, this book will provide beginning and intermediate Access developers with everything that 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 get started building custom Access apps. This latest book in her Mastering Access series will not disappoint her many fans who anxiously await each new version, and should win her new fans as well.\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eIntroduction\u003c\/p\u003e\u003cp\u003ePart I The Basics of Access Development\u003c\/p\u003e\u003cp\u003e1 Access as a Development Tool. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7\u003c\/p\u003e\u003cp\u003e2 What Every Developer Needs to Know About Databases and Tables . . . . . . . 75\u003c\/p\u003e\u003cp\u003e3 Relationships: Your Key to Data Integrity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115\u003c\/p\u003e\u003cp\u003e4 What Every Developer Needs to Know About Query Basics. . . . . . . . . . . . . . . . . 137\u003c\/p\u003e\u003cp\u003e5 What Every Developer Needs to Know About Forms. . . . . . . . . . . . . . . . . . . . . . . . . . 189\u003c\/p\u003e\u003cp\u003e6 What Every Developer Needs to Know About Reports. . . . . . . . . . . . . . . . . . . . . . . . 269\u003c\/p\u003e\u003cp\u003e7 What Are Macros, and When Do You Need Them? . . . . . . . . . . . . . . . . . . . . . . . . . . . 315\u003c\/p\u003e\u003cp\u003e8 VBA: An Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 345\u003c\/p\u003e\u003cp\u003e9 Objects, Properties, Methods, and Events Explained . . . . . . . . . . . . . . . . . . . . . . . . . . 401\u003c\/p\u003e\u003cp\u003e10 Advanced Form Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 431\u003c\/p\u003e\u003cp\u003e11 Advanced Report Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 493\u003c\/p\u003e\u003cp\u003e12 Advanced Query Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 539\u003c\/p\u003e\u003cp\u003e13 Advanced VBA Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 599\u003c\/p\u003e\u003cp\u003e14 Exploiting the Power of Class Modules. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 637\u003c\/p\u003e\u003cp\u003e15 What Are ActiveX Data Objects, and Why Are They Important?. . . . . . . . . . 671\u003c\/p\u003e\u003cp\u003ePart II What to Do When Things Don’t Go as Planned\u003c\/p\u003e\u003cp\u003e16 Debugging: Your Key to Successful Development . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 727\u003c\/p\u003e\u003cp\u003e17 Error Handling: Preparing for the Inevitable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 755\u003c\/p\u003e\u003cp\u003e18 Optimizing Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 801\u003c\/p\u003e\u003cp\u003ePart III Developing Multiuser and Enterprise Applications\u003c\/p\u003e\u003cp\u003e19 A Strategy to Developing Access Applications. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 835\u003c\/p\u003e\u003cp\u003e20 Using External Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 847\u003c\/p\u003e\u003cp\u003e21 Access 2007 and SharePoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 883\u003c\/p\u003e\u003cp\u003e22 Developing Multiuser and Enterprise Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . 909\u003c\/p\u003e\u003cp\u003e00_0672329328_FM.qxd 5\/4\/07 9:23 AM Page iii\u003c\/p\u003e\u003cp\u003ePart IV Black Belt Programming\u003c\/p\u003e\u003cp\u003e23 Working with and Customizing Ribbons . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 935\u003c\/p\u003e\u003cp\u003e24 Automation: Communicating with Other Applications. . . . . . . . . . . . . . . . . . . . . . 949\u003c\/p\u003e\u003cp\u003e25 Exploiting the Power of the Windows API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 985\u003c\/p\u003e\u003cp\u003e26 Creating Your Own Libraries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1011\u003c\/p\u003e\u003cp\u003e27 Using Builders and Wizards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1027\u003c\/p\u003e\u003cp\u003e28 An Introduction to Access and the Internet\/Intranet. . . . . . . . . . . . . . . . . . . . . . . . 1055\u003c\/p\u003e\u003cp\u003ePart V Adding Polish to Your Application\u003c\/p\u003e\u003cp\u003e29 Documenting Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1073\u003c\/p\u003e\u003cp\u003e30 Maintaining Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1091\u003c\/p\u003e\u003cp\u003e31 Database Security Made Easy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1103\u003c\/p\u003e\u003cp\u003e \u003ci\u003e \u003c\/i\u003e\u003c\/p\u003e\u003cp\u003eThe following appendixes are available for download\u003c\/p\u003e\u003cp\u003eat www.samspublishing.com\/title\/0672329328.\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003ePart VI Appendixes\u003c\/p\u003e\u003cp\u003eA Naming Conventions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . PDF:1131\u003c\/p\u003e\u003cp\u003eB Table Structures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . PDF:1137\u003c\/p\u003e\u003cp\u003eIndex. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1193\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e","brand":"Sams","offers":[{"title":"Default Title","offer_id":47013819744496,"sku":"9780672329326","price":64.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780672329326_p0.jpg?v=1763786816","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780672329326","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}