Access 2007 Bible

"I recommend this book for anyone who wants a strong foundation inAccess."Jeff Lenamon, CIBC World MarketsUpdated edition with exciting new Access 2007features!Harness the power of Access 2007 with the expert guidance inthis comprehensive reference. Beginners will appreciate thethorough attention to database fundamentals and terminology.Experienced users can jump right into Access 2007 enhancements likethe all-new user interface and wider use of XML and Web services.Each of the book's six parts thoroughly focuses on key elements ina logical sequence, so you have what you need, when you need it.Designed as both a reference and a tutorial, Access 2007 Bible is apowerful tool for developers needing to make the most of the newfeatures in Access 2007.* Build Access tables using good relational databasetechniques* Construct efficient databases using a five-step designmethod* Design efficient data-entry and data display forms* Utilize the improved Access report designer* Use Visual Basic(r) for Applications and the VBA Editor toautomate applications* Build and customize Access 2007 ribbons* Seamlessly exchange Access data with SharePoint(r)* Employ advanced techniques such as the Windows(r) API andobject-oriented programming* Add security and use data replication in your AccessapplicationsWhat's on the CD-ROM?Follow the examples in the book chapter by chapter using thebonus materials on the CD-ROM. You'll find separate MicrosoftAccess database files for each chapter and other working files,including* All the examples and databases used in the book, includingdatabase files, images, data files in various formats, and iconfiles used in the book's examples* A complete sample application file, including queries, reports,objects, and modules, that you can use as a referenceSee the CD-ROM appendix for details and complete systemrequirements.Note: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.

Acknowledgments xxxixForeword xliPart I: Access Building Blocks 1Chapter 1: An Introduction to Database Development 3Chapter 2: Creating Access Tables 23Chapter 3: Designing Bulletproof Databases 87Chapter 4: Selecting Data with Queries 123Chapter 5: Using Operators and Expressions in Access 161Chapter 6: Working with Datasheet View 203Chapter 7: Creating Basic Access Forms 237Chapter 8: Working with Data on Access Forms 269Chapter 9: Presenting Data with Access Reports 297Part II: Programming Microsoft Access 345Chapter 10: VBA Programming Fundamentals 347Chapter 11: Mastering VBA Data Types and Procedures 385Chapter 12: Understanding the Access Event Model 417Chapter 13: Using Expressions in Queries and VBA Code 443Chapter 14: Accessing Data with VBA Code 471Chapter 15: Using the VBA Debugging Tools 497Part III: More Advanced Access Techniques 523Chapter 16: Working with External Data 525Chapter 17: Importing and Exporting Data 555Chapter 18: Advanced Access Query Techniques 581Chapter 19: Advanced Access Form Techniques 617Chapter 20: Advanced Access Report Techniques 647Chapter 21: Building Multiuser Applications 685Chapter 22: Integrating Access with Other Applications 723Chapter 23: Integrating Access with SharePoint 749Chapter 24: Using ActiveX Controls 769Chapter 25: Handling Errors and Exceptions 801Part IV: Professional Database Development 821Chapter 26: Optimizing Access Applications 823Chapter 27: Advanced Data Access with VBA 863Chapter 28: Bulletproofing Access Applications 877Chapter 29: Securing Access Applications 909Chapter 30: Using the Windows API 951Chapter 31: Using the Access Replication Features 987Chapter 32: Object-Oriented Programming with VBA 1037Chapter 33: Reusing VBA Code with Libraries 1079Chapter 34: Customizing Access Ribbons 1089Chapter 35: Distributing Access Applications 1117Chapter 36: Using Access Macros 1133Part V: Access as an Enterprise Platform 1163Chapter 37: Using XML in Access 2007 1165Chapter 38: SharePoint as a Data Source 1191Chapter 39: Client/Server Concepts 1209Chapter 40: SQL Server as an Access Companion 1223Chapter 41: Upsizing Access Databases to SQL Server 1249Part VI: Appendixes 1265Appendix A: Access 2007 Specifications 1267Appendix B: What's on the CD-ROM 1275Appendix C: What's New in Access 2007 1279Index 1291Wiley Publishing, Inc. End-User License Agreement 1362