{"product_id":"access-2013-bible-isbn-9781118490358","title":"Access 2013 Bible","description":"\u003cp\u003e\u003cb\u003eA comprehensive reference to the updated and new features of Access 2013\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAs the world's most popular database management tool, Access enables you to organize, present, analyze, and share data as well as build powerful database solutions. However, databases can be complex. That's why you need the expert guidance in this comprehensive reference. \u003ci\u003eAccess 2013 Bible\u003c\/i\u003e helps you gain a solid understanding of database purpose, construction, and application so that whether you're new to Access or looking to upgrade to the 2013 version, this well-rounded resource provides you with a thorough look at everything Access can do.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eExplains how to create tables, manipulate datasheets, and work with multiple tables\u003c\/li\u003e \u003cli\u003eTeaches you how to apply the seven-step design method to build databases that are tailored to your needs\u003c\/li\u003e \u003cli\u003eCovers building forms with wizards, creating bound and unbound forms, and adding data validation\u003c\/li\u003e \u003cli\u003eShows you ways to automate query parameters, create functions and subroutines, and add programmed error routines\u003c\/li\u003e \u003cli\u003eFeatures a bonus website with content that contains all source code from the book as well as bonus shareware, freeware, trial, demo, and evaluation programs\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eIf you are looking for a comprehensive book on all things Access, look no further than \u003ci\u003eAccess 2013 Bible\u003c\/i\u003e.\u003c\/p\u003e Acknowledgments ix \u003cp\u003eContents at a Glance xi\u003c\/p\u003e \u003cp\u003eContents xiii\u003c\/p\u003e \u003cp\u003eIntroduction xxxix\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I: Access Building Blocks 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: An Introduction to Database Development 3\u003c\/p\u003e \u003cp\u003eChapter 2: Getting Started with Access 19\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II: Understanding Access Tables 31\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 3: Creating Access Tables 33\u003c\/p\u003e \u003cp\u003eChapter 4: Understanding Table Relationships 89\u003c\/p\u003e \u003cp\u003eChapter 5: Working with Access Tables 129\u003c\/p\u003e \u003cp\u003eChapter 6: Importing and Exporting Data 167\u003c\/p\u003e \u003cp\u003eChapter 7: Linking to External Data 201\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III: Working with Access Queries 227\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 8: Selecting Data with Queries 229\u003c\/p\u003e \u003cp\u003eChapter 9: Using Operators and Expressions in Access 261\u003c\/p\u003e \u003cp\u003eChapter 10: Going Beyond Select Queries 301\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV: Analyzing Data in Access 337\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 11: Transforming Data in Access 339\u003c\/p\u003e \u003cp\u003eChapter 12: Working with Calculations and Dates 363\u003c\/p\u003e \u003cp\u003eChapter 13: Performing Conditional Analyses 389\u003c\/p\u003e \u003cp\u003eChapter 14: Fundamentals of Using Access SQL 407\u003c\/p\u003e \u003cp\u003eChapter 15: Subqueries and Domain Aggregate Functions 427\u003c\/p\u003e \u003cp\u003eChapter 16: Running Descriptive Statistics in Access 451\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V: Working with Access Forms and Reports 469\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 17: Creating Basic Access Forms 471\u003c\/p\u003e \u003cp\u003eChapter 18: Working with Data on Access Forms 509\u003c\/p\u003e \u003cp\u003eChapter 19: Working with Form Controls 541\u003c\/p\u003e \u003cp\u003eChapter 20: Presenting Data with Access Reports 575\u003c\/p\u003e \u003cp\u003eChapter 21: Advanced Access Report Techniques 631\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VI: Access Programming Fundamentals 675\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 22: Using Access Macros 677\u003c\/p\u003e \u003cp\u003eChapter 23: Getting Started with Access VBA 715\u003c\/p\u003e \u003cp\u003eChapter 24: Mastering VBA Data Types and Procedures 757\u003c\/p\u003e \u003cp\u003eChapter 25: Understanding the Access Event Model 799\u003c\/p\u003e \u003cp\u003eChapter 26: Debugging Your Access Applications 821\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VII: Advanced Access Programming Techniques 853\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 27: Accessing Data with VBA Code 855\u003c\/p\u003e \u003cp\u003eChapter 28: Advanced Data Access with VBA 897\u003c\/p\u003e \u003cp\u003eChapter 29: Integrating Access and SQL Server 915\u003c\/p\u003e \u003cp\u003eChapter 30: Customizing the Ribbon 957\u003c\/p\u003e \u003cp\u003eChapter 31: Preparing Your Access Application for Distribution 993\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VIII: Access and Windows SharePoint Services  1037\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 32: Understanding Windows SharePoint Services 1039\u003c\/p\u003e \u003cp\u003eChapter 33: Integrating Access with SharePoint 1045\u003c\/p\u003e \u003cp\u003eChapter 34: Understanding Access Services 1059\u003c\/p\u003e \u003cp\u003eChapter 35: Deploying Access Applications to SharePoint 1067\u003c\/p\u003e \u003cp\u003eChapter 36: Using Access Data Macros 1089\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IX: Appendixes 1109\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAppendix A: Access 2013 Specifications 1111\u003c\/p\u003e \u003cp\u003eAppendix B: Optimizing Access Applications 1117\u003c\/p\u003e \u003cp\u003eAppendix C: Understanding Query Performance and Database Corruption 1139\u003c\/p\u003e \u003cp\u003eAppendix D: Function Reference for Data Analysts 1147\u003c\/p\u003e \u003cp\u003eIndex 1183\u003c\/p\u003e \u003cp\u003e\u003cb\u003eMichael Alexander\u003c\/b\u003e 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.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eDick Kusleika\u003c\/b\u003e 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.\u003c\/p\u003e  \u003cp\u003eDESIGN YOUR OWN RELATIONAL DATABASES\u003c\/p\u003e \u003cp\u003eBUILD POWERFUL ANALYTICS AND REPORTING\u003c\/p\u003e \u003cp\u003ePROGRAM AND PUBLISH YOUR OWN APPLICATIONS\u003c\/p\u003e \u003cp\u003eYour all-access guide to Access 2013\u003c\/p\u003e \u003cp\u003eThis information-packed reference is exactly what you need to take your Access abilities to a whole new level. From using Access to store data and analyze information to building reports, creating applications, and more, you'll start with the basics and work your way through detailed instruction on more advanced tools. Learn to create effective tables, powerful analytic queries, robust applications with Access forms, and attractive Access reports while gaining insight on topics like SharePoint® integration and Visual Basic programming. Whether you're new to Access or just new to Access 2013, this book is an invaluable, in-depth resource for all things Access.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eGet a solid grounding in database fundamentals\u003c\/li\u003e \u003cli\u003eUse Access to analyze large amounts of data\u003c\/li\u003e \u003cli\u003eTurn your data into attractive PDF-style reports and outputs\u003c\/li\u003e \u003cli\u003eAutomate redundant reporting and analysis using Access macros\u003c\/li\u003e \u003cli\u003eBuild powerful departmental applications with Access forms\u003c\/li\u003e \u003cli\u003eSave time and increase productivity with Access VBA\u003c\/li\u003e \u003cli\u003eIntegrate or publish your data on SharePoint sites\u003c\/li\u003e \u003cli\u003eFollow along with downloadable examples and database files from the book\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eCreate data collection mechanisms that can be shared online\u003c\/p\u003e \u003cp\u003eBuild custom applications designed just for you\u003c\/p\u003e \u003cp\u003eUse the intuitive Query Builder in Access for easy analysis\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47988652933349,"sku":"NP9781118490358","price":49.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781118490358.jpg?v=1761781127","url":"https:\/\/k12savings.com\/es\/products\/access-2013-bible-isbn-9781118490358","provider":"K12savings","version":"1.0","type":"link"}