SmartSellTM - The New Way to Sell Online

Shop over a million Toys in our Huge New Range

Access 2013 Bible (Bible)


Product Description
Product Details

Table of Contents

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

About the Author

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.

Ask a Question About this Product More...
Write your question below:
Look for similar items by category
How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling Access 2013 Bible (Bible) on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Back to top