Michael R. Groh is a well-known authority on Microsoft Access, having written or contributed to more than 20 books and over 200 articles on the topic. Mike has also spoken at dozens of Access conferences throughout the world.

• Acknowledgments xxxiiiIntroduction xxxvPart I: Access Building Blocks 1Chapter 1: An Introduction to Database Development 3Chapter 2: Creating Access Tables 25Chapter 3: Designing Bulletproof Databases 91Chapter 4: Selecting Data with Queries 129Chapter 5: Using Operators and Expressions in Access 171Chapter 6: Working with Datasheet View 215Chapter 7: Creating Basic Access Forms 251Chapter 8: Working with Data on Access Forms 289Chapter 9: Presenting Data with Access Reports 319Part II: Programming Microsoft Access 375Chapter 10: VBA Programming Fundamentals 377Chapter 11: Mastering VBA Data Types and Procedures 417Chapter 12: The Access Event Model 451Chapter 13: Accessing Data with VBA Code 473Chapter 14: Debugging Your Access Applications 523Chapter 15: Using Access Data Macros 551Part III: More-Advanced Access Techniques 577Chapter 16: Working with External Data 579Chapter 17: Importing and Exporting Data 609Chapter 18: Advanced Access Query Techniques 637Chapter 19: Advanced Access Form Techniques 679Chapter 20: Advanced Access Report Techniques 709Chapter 21: Building Multiuser Applications 751Chapter 22: Integrating Access with Other Applications 789Chapter 23: Handling Errors and Exceptions 819Part IV: Professional Database Development 839Chapter 24: Optimizing Access Applications 841Chapter 25: Advanced Data Access with VBA 881Chapter 26: Bulletproofing Access Applications 897Chapter 27: Using the Windows Application Programming Interface 939Chapter 28: Object-Oriented Programming with VBA 969Chapter 29: Customizing Access Ribbons 1009Chapter 30: Using Access Macros 1049Chapter 31: Distributing Access Applications 1083Part V: Access and Windows SharePoint Services 1101Chapter 32: Understanding Windows SharePoint Services 1103Chapter 33: Integrating Access with SharePoint 1117Chapter 34: Understanding Access Services 1135Chapter 35: Deploying Access Applications to SharePoint 1145Part VI: Access as an Enterprise Platform 1181Chapter 36: Client/Server Concepts 1183Chapter 37: SQL Server as an Access Companion 1199Chapter 38: Upsizing Access Databases to SQL Server 1223Part VII: Appendixes 1243Appendix A: Access 2010 Specifications 1245Appendix B: What’s New in Access 2010 1253Appendix C: What’s on the CD-ROM 1267 Index 1271

Michael R. Groh is a well-known authority on Microsoft Access, having written or contributed to more than 20 books and over 200 articles on the topic. Mike has also spoken at dozens of Access conferences throughout the world.

• Acknowledgments xxxiiiIntroduction xxxvPart I: Access Building Blocks 1Chapter 1: An Introduction to Database Development 3Chapter 2: Creating Access Tables 25Chapter 3: Designing Bulletproof Databases 91Chapter 4: Selecting Data with Queries 129Chapter 5: Using Operators and Expressions in Access 171Chapter 6: Working with Datasheet View 215Chapter 7: Creating Basic Access Forms 251Chapter 8: Working with Data on Access Forms 289Chapter 9: Presenting Data with Access Reports 319Part II: Programming Microsoft Access 375Chapter 10: VBA Programming Fundamentals 377Chapter 11: Mastering VBA Data Types and Procedures 417Chapter 12: The Access Event Model 451Chapter 13: Accessing Data with VBA Code 473Chapter 14: Debugging Your Access Applications 523Chapter 15: Using Access Data Macros 551Part III: More-Advanced Access Techniques 577Chapter 16: Working with External Data 579Chapter 17: Importing and Exporting Data 609Chapter 18: Advanced Access Query Techniques 637Chapter 19: Advanced Access Form Techniques 679Chapter 20: Advanced Access Report Techniques 709Chapter 21: Building Multiuser Applications 751Chapter 22: Integrating Access with Other Applications 789Chapter 23: Handling Errors and Exceptions 819Part IV: Professional Database Development 839Chapter 24: Optimizing Access Applications 841Chapter 25: Advanced Data Access with VBA 881Chapter 26: Bulletproofing Access Applications 897Chapter 27: Using the Windows Application Programming Interface 939Chapter 28: Object-Oriented Programming with VBA 969Chapter 29: Customizing Access Ribbons 1009Chapter 30: Using Access Macros 1049Chapter 31: Distributing Access Applications 1083Part V: Access and Windows SharePoint Services 1101Chapter 32: Understanding Windows SharePoint Services 1103Chapter 33: Integrating Access with SharePoint 1117Chapter 34: Understanding Access Services 1135Chapter 35: Deploying Access Applications to SharePoint 1145Part VI: Access as an Enterprise Platform 1181Chapter 36: Client/Server Concepts 1183Chapter 37: SQL Server as an Access Companion 1199Chapter 38: Upsizing Access Databases to SQL Server 1223Part VII: Appendixes 1243Appendix A: Access 2010 Specifications 1245Appendix B: What’s New in Access 2010 1253Appendix C: What’s on the CD-ROM 1267 Index 1271

Michael R. Groh is a well-known authority on Microsoft Access, having written or contributed to more than 20 books and over 200 articles on the topic. Mike has also spoken at dozens of Access conferences throughout the world.

• Acknowledgments xxxiiiIntroduction xxxvPart I: Access Building Blocks 1Chapter 1: An Introduction to Database Development 3Chapter 2: Creating Access Tables 25Chapter 3: Designing Bulletproof Databases 91Chapter 4: Selecting Data with Queries 129Chapter 5: Using Operators and Expressions in Access 171Chapter 6: Working with Datasheet View 215Chapter 7: Creating Basic Access Forms 251Chapter 8: Working with Data on Access Forms 289Chapter 9: Presenting Data with Access Reports 319Part II: Programming Microsoft Access 375Chapter 10: VBA Programming Fundamentals 377Chapter 11: Mastering VBA Data Types and Procedures 417Chapter 12: The Access Event Model 451Chapter 13: Accessing Data with VBA Code 473Chapter 14: Debugging Your Access Applications 523Chapter 15: Using Access Data Macros 551Part III: More-Advanced Access Techniques 577Chapter 16: Working with External Data 579Chapter 17: Importing and Exporting Data 609Chapter 18: Advanced Access Query Techniques 637Chapter 19: Advanced Access Form Techniques 679Chapter 20: Advanced Access Report Techniques 709Chapter 21: Building Multiuser Applications 751Chapter 22: Integrating Access with Other Applications 789Chapter 23: Handling Errors and Exceptions 819Part IV: Professional Database Development 839Chapter 24: Optimizing Access Applications 841Chapter 25: Advanced Data Access with VBA 881Chapter 26: Bulletproofing Access Applications 897Chapter 27: Using the Windows Application Programming Interface 939Chapter 28: Object-Oriented Programming with VBA 969Chapter 29: Customizing Access Ribbons 1009Chapter 30: Using Access Macros 1049Chapter 31: Distributing Access Applications 1083Part V: Access and Windows SharePoint Services 1101Chapter 32: Understanding Windows SharePoint Services 1103Chapter 33: Integrating Access with SharePoint 1117Chapter 34: Understanding Access Services 1135Chapter 35: Deploying Access Applications to SharePoint 1145Part VI: Access as an Enterprise Platform 1181Chapter 36: Client/Server Concepts 1183Chapter 37: SQL Server as an Access Companion 1199Chapter 38: Upsizing Access Databases to SQL Server 1223Part VII: Appendixes 1243Appendix A: Access 2010 Specifications 1245Appendix B: What’s New in Access 2010 1253Appendix C: What’s on the CD-ROM 1267 Index 1271