Access 2013 Bible

Michael Alexander is a Microsoft Certified Application Developer (MCAD) and author of eight books on advanced business analysis with Microsoft Access and Excel. He has more than 15 years of experience consulting and developing Office solutions. Michael has been named a Microsoft MVP for his ongoing contributions to the Excel community.Dick Kusleika has been helping users get the most out of Microsoft Office products for more than 15 years through online forums, blogging, book contributions, and conferences.

• Acknowledgments ix Contents at a Glance xiContents xiiiIntroduction xxxixPart I: Access Building Blocks 1Chapter 1: An Introduction to Database Development 3Chapter 2: Getting Started with Access 19Part II: Understanding Access Tables 31Chapter 3: Creating Access Tables 33Chapter 4: Understanding Table Relationships 89Chapter 5: Working with Access Tables 129Chapter 6: Importing and Exporting Data 167Chapter 7: Linking to External Data 201Part III: Working with Access Queries 227Chapter 8: Selecting Data with Queries 229Chapter 9: Using Operators and Expressions in Access 261Chapter 10: Going Beyond Select Queries 301Part IV: Analyzing Data in Access 337Chapter 11: Transforming Data in Access 339Chapter 12: Working with Calculations and Dates 363Chapter 13: Performing Conditional Analyses 389Chapter 14: Fundamentals of Using Access SQL 407Chapter 15: Subqueries and Domain Aggregate Functions 427Chapter 16: Running Descriptive Statistics in Access 451Part V: Working with Access Forms and Reports 469Chapter 17: Creating Basic Access Forms 471Chapter 18: Working with Data on Access Forms 509Chapter 19: Working with Form Controls 541Chapter 20: Presenting Data with Access Reports 575Chapter 21: Advanced Access Report Techniques 631Part VI: Access Programming Fundamentals 675Chapter 22: Using Access Macros 677Chapter 23: Getting Started with Access VBA 715Chapter 24: Mastering VBA Data Types and Procedures 757Chapter 25: Understanding the Access Event Model 799Chapter 26: Debugging Your Access Applications 821Part VII: Advanced Access Programming Techniques 853Chapter 27: Accessing Data with VBA Code 855Chapter 28: Advanced Data Access with VBA 897Chapter 29: Integrating Access and SQL Server 915Chapter 30: Customizing the Ribbon 957Chapter 31: Preparing Your Access Application for Distribution 993Part VIII: Access and Windows SharePoint Services  1037Chapter 32: Understanding Windows SharePoint Services 1039Chapter 33: Integrating Access with SharePoint 1045Chapter 34: Understanding Access Services 1059Chapter 35: Deploying Access Applications to SharePoint 1067Chapter 36: Using Access Data Macros 1089Part IX: Appendixes 1109Appendix A: Access 2013 Specifications 1111Appendix B: Optimizing Access Applications 1117Appendix C: Understanding Query Performance and Database Corruption 1139Appendix D: Function Reference for Data Analysts 1147Index 1183