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