Access 2007 Bible (Paperback)

Acknowledgments xxxix

Foreword xli

Part I: Access Building Blocks 1

Chapter 1: An Introduction to Database Development 3

Chapter 2: Creating Access Tables 23

Chapter 3: Designing Bulletproof Databases 87

Chapter 4: Selecting Data with Queries 123

Chapter 5: Using Operators and Expressions in Access 161

Chapter 6: Working with Datasheet View 203

Chapter 7: Creating Basic Access Forms 237

Chapter 8: Working with Data on Access Forms 269

Chapter 9: Presenting Data with Access Reports 297

Part II: Programming Microsoft Access 345

Chapter 10: VBA Programming Fundamentals 347

Chapter 11: Mastering VBA Data Types and Procedures 385

Chapter 12: Understanding the Access Event Model 417

Chapter 13: Using Expressions in Queries and VBA Code 443

Chapter 14: Accessing Data with VBA Code 471

Chapter 15: Using the VBA Debugging Tools 497

Part III: More Advanced Access Techniques 523

Chapter 16: Working with External Data 525

Chapter 17: Importing and Exporting Data 555

Chapter 18: Advanced Access Query Techniques 581

Chapter 19: Advanced Access Form Techniques 617

Chapter 20: Advanced Access Report Techniques 647

Chapter 21: Building Multiuser Applications 685

Chapter 22: Integrating Access with Other Applications 723

Chapter 23: Integrating Access with SharePoint 749

Chapter 24: Using ActiveX Controls 769

Chapter 25: Handling Errors and Exceptions 801

Part IV: Professional Database Development 821

Chapter 26: Optimizing Access Applications 823

Chapter 27: Advanced Data Access with VBA 863

Chapter 28: Bulletproofing Access Applications 877

Chapter 29: Securing Access Applications 909

Chapter 30: Using the Windows API 951

Chapter 31: Using the Access Replication Features 987

Chapter 32: Object-Oriented Programming with VBA 1037

Chapter 33: Reusing VBA Code with Libraries 1079

Chapter 34: Customizing Access Ribbons 1089

Chapter 35: Distributing Access Applications 1117

Chapter 36: Using Access Macros 1133

Part V: Access as an Enterprise Platform 1163

Chapter 37: Using XML in Access 2007 1165

Chapter 38: SharePoint as a Data Source 1191

Chapter 39: Client/Server Concepts 1209

Chapter 40: SQL Server as an Access Companion 1223

Chapter 41: Upsizing Access Databases to SQL Server 1249

Part VI: Appendixes 1265

Appendix A: Access 2007 Specifications 1267

Appendix B: What’s on the CD-ROM 1275

Appendix C: What’s New in Access 2007 1279

Index 1291

Wiley Publishing, Inc. End-User License Agreement 1362