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.