Access 2010 Bible

Acknowledgments xxxiii

Introduction xxxv

Part I: Access Building Blocks 1

Chapter 1: An Introduction to Database Development 3

Chapter 2: Creating Access Tables 25

Chapter 3: Designing Bulletproof Databases 91

Chapter 4: Selecting Data with Queries 129

Chapter 5: Using Operators and Expressions in Access 171

Chapter 6: Working with Datasheet View 215

Chapter 7: Creating Basic Access Forms 251

Chapter 8: Working with Data on Access Forms 289

Chapter 9: Presenting Data with Access Reports 319

Part II: Programming Microsoft Access 375

Chapter 10: VBA Programming Fundamentals 377

Chapter 11: Mastering VBA Data Types and Procedures 417

Chapter 12: The Access Event Model 451

Chapter 13: Accessing Data with VBA Code 473

Chapter 14: Debugging Your Access Applications 523

Chapter 15: Using Access Data Macros 551

Part III: More-Advanced Access Techniques 577

Chapter 16: Working with External Data 579

Chapter 17: Importing and Exporting Data 609

Chapter 18: Advanced Access Query Techniques 637

Chapter 19: Advanced Access Form Techniques 679

Chapter 20: Advanced Access Report Techniques 709

Chapter 21: Building Multiuser Applications 751

Chapter 22: Integrating Access with Other Applications 789

Chapter 23: Handling Errors and Exceptions 819

Part IV: Professional Database Development 839

Chapter 24: Optimizing Access Applications 841

Chapter 25: Advanced Data Access with VBA 881

Chapter 26: Bulletproofing Access Applications 897

Chapter 27: Using the Windows Application Programming Interface 939

Chapter 28: Object-Oriented Programming with VBA 969

Chapter 29: Customizing Access Ribbons 1009

Chapter 30: Using Access Macros 1049

Chapter 31: Distributing Access Applications 1083

Part V: Access and Windows SharePoint Services 1101

Chapter 32: Understanding Windows SharePoint Services 1103

Chapter 33: Integrating Access with SharePoint 1117

Chapter 34: Understanding Access Services 1135

Chapter 35: Deploying Access Applications to SharePoint 1145

Part VI: Access as an Enterprise Platform 1181

Chapter 36: Client/Server Concepts 1183

Chapter 37: SQL Server as an Access Companion 1199

Chapter 38: Upsizing Access Databases to SQL Server 1223

Part VII: Appendixes 1243

Appendix A: Access 2010 Specifications 1245

Appendix B: What’s New in Access 2010 1253

Appendix C: What’s on the CD-ROM 1267

Index 1271