{"product_id":"access-2016-for-dummies-isbn-9781119083108","title":"Access 2016 For Dummies","description":"\u003cb\u003eYour all-access guide to all things Access 2016\u003c\/b\u003e \u003cp\u003eIf you don't know a relational database from an isolationist table—but still need to figure out how to organize and analyze your data—\u003ci\u003eAccess 2016 For Dummies\u003c\/i\u003e is for you. Written in a friendly and accessible manner, it assumes no prior Access or database-building knowledge and walks you through the basics of creating tables to store your data, building forms that ease data entry, writing queries that pull real information from your data, and creating reports that back up your analysis. Add in a dash of humor and fun, and \u003ci\u003eAccess 2016 For Dummies\u003c\/i\u003e is the only resource you'll need to go from data rookie to data pro! \u003c\/p\u003e\u003cp\u003eThis expanded and updated edition of \u003ci\u003eAccess For Dummies\u003c\/i\u003e covers all of the latest information and features to help data newcomers better understand Access' role in the world of data analysis and data science. Inside, you'll get a crash course on how databases work—and how to build one from the ground up. Plus, you'll find step-by-step guidance on how to structure data to make it useful, manipulate, edit, and import data into your database, write and execute queries to gain insight from your data, and report data in elegant ways. \u003c\/p\u003e\u003cul\u003e \u003cli\u003eSpeak the lingo of database builders and create databases that suit your needs\u003c\/li\u003e \u003cli\u003eOrganize your data into tables and build forms that ease data entry\u003c\/li\u003e \u003cli\u003eQuery your data to get answers right\u003c\/li\u003e \u003cli\u003eCreate reports that tell the story of your data findings\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eIf you have little to no experience with creating and managing a database of any sort, \u003ci\u003eAccess 2016 For Dummies\u003c\/i\u003e is the perfect starting point for learning the basics of building databases, simplifying data entry and reporting, and improving your overall data skills. \u003c\/p\u003e\u003cp\u003eIntroduction 1\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I: Getting Started with Access 2016 5\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Access 2016 Basic Training 7\u003c\/p\u003e \u003cp\u003eChapter 2: Navigating the Access Workspace 27\u003c\/p\u003e \u003cp\u003eChapter 3: Database Basics 49\u003c\/p\u003e \u003cp\u003eChapter 4: Sounds Like a Plan 67\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II: Getting It All on the Table 77\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 5: Table Tune Ups 79\u003c\/p\u003e \u003cp\u003eChapter 6: Remodeling Your Data 97\u003c\/p\u003e \u003cp\u003eChapter 7: Types, Masks, and Triggers 113\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III: Data Management Mania 137\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 8: A Form for All Reasons 139\u003c\/p\u003e \u003cp\u003eChapter 9: Importing and Exporting Data 157\u003c\/p\u003e \u003cp\u003eChapter 10: Automatic Data Editing 171\u003c\/p\u003e \u003cp\u003eChapter 11: Access and the Web 183\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV: The Power of Questions 203\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 12: Finding, Filtering, and Sorting Your Data — Fast 205\u003c\/p\u003e \u003cp\u003eChapter 13: I Was Just Asking for Answers 221\u003c\/p\u003e \u003cp\u003eChapter 14: I Want These AND Those OR Them 247\u003c\/p\u003e \u003cp\u003eChapter 15: Number Crunching with the Total Row 255\u003c\/p\u003e \u003cp\u003eChapter 16: Express Yourself with Formulas 267\u003c\/p\u003e \u003cp\u003eChapter 17: Take Charge with Action Queries 281\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V: Simple and Snazzy Reporting 291\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 18: Fast and Furious Automatic Reporting 293\u003c\/p\u003e \u003cp\u003eChapter 19: Professionally Designed Reports Made Easy 315\u003c\/p\u003e \u003cp\u003eChapter 20: Headers and Footers and Groups, Oh My! 341\u003c\/p\u003e \u003cp\u003eChapter 21: Magical Mass Mailings 361\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VI: More Power to You 369\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 22: Analyze This! 371\u003c\/p\u003e \u003cp\u003eChapter 23: Steer Users in the Right Direction with Navigation Forms 381\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VII: The Part of Tens 391\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 24: Ten Common Problems 393\u003c\/p\u003e \u003cp\u003eChapter 25: Ten Uncommon Tips 403\u003c\/p\u003e \u003cp\u003eAppendix A: Getting Help 409\u003c\/p\u003e \u003cp\u003eIndex 417\u003c\/p\u003e   \u003cp\u003e\u003cb\u003eLaurie Ulrich Fuller \u003c\/b\u003eis a professional technology author and trainer. She's created training materials that cover Microsoft Office and Adobe Creative Suite. \u003cb\u003eKen Cook\u003c\/b\u003e is a professional database developer, instructor, and author. The two experts have teamed to write the previous three editions of \u003ci\u003eAccess For Dummies\u003c\/i\u003e.     \u003c\/p\u003e\u003cp\u003e\u003cb\u003e\u003ci\u003eLearn to:\u003c\/i\u003e\u003c\/b\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003e Speak the lingo of database developers and create databases that suit your needs\u003c\/li\u003e \u003cli\u003e Organize your data into tables and build forms that simplify data entry\u003c\/li\u003e \u003cli\u003e Query your data to get answers and insight\u003c\/li\u003e \u003cli\u003e Create reports that present data in a way that's easy to understand\u003c\/li\u003e \u003c\/ul\u003e  \u003cp\u003e\u003cb\u003eUnlock the magic of databases and see how Access 2016 can make your life easier!\u003c\/b\u003e  \u003c\/p\u003e\u003cp\u003eA good database makes it easy to store, find, and report on the data you need. With a bit of the know-how in this book, you can create an outstanding relational database. Follow the simple steps to learn how to build data tables, establish relationships between your tables, create forms, execute queries, and generate reports that squeeze all the value out of your data.   \u003c\/p\u003e\u003cul\u003e \u003cli\u003e \u003cb\u003eDatabase basics\u003c\/b\u003e — explore databases, database terminology, how Access works, and how to navigate the program\u003c\/li\u003e  \u003cli\u003e \u003cb\u003eTable talk\u003c\/b\u003e — learn to plan and build tables, use primary keys, and understand table relationships\u003c\/li\u003e  \u003cli\u003e \u003cb\u003eMagical management\u003c\/b\u003e — generate useful forms, import data from various sources, learn to edit data automatically, and use Access with the web\u003c\/li\u003e  \u003cli\u003e \u003cb\u003eData Q\u0026amp;A\u003c\/b\u003e — query your data using filter and sort tools, run the Query Wizard, and update lots of data quickly using Action Queries\u003c\/li\u003e  \u003cli\u003e \u003cb\u003eReporting for duty\u003c\/b\u003e — create quick automatic reports, design individualized reports with great presentation features, and develop mass mailings\u003c\/li\u003e  \u003cli\u003e \u003cb\u003eAnalyze this\u003c\/b\u003e — use the Analyzer tools to make your database more efficient and help database users find their way with navigation forms\u003c\/li\u003e  \u003c\/ul\u003e  \u003cp\u003e\u003cb\u003eOpen the book and find:\u003c\/b\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003eHow to build a database from the ground up\u003c\/li\u003e \u003cli\u003eThe rules of making tables that organize your data\u003c\/li\u003e \u003cli\u003eSteps for building forms using the Form Wizard\u003c\/li\u003e \u003cli\u003eHow to import data from other sources\u003c\/li\u003e \u003cli\u003eAdvice on sharing data on the Web\u003c\/li\u003e \u003cli\u003eFast ways to find data in your database\u003c\/li\u003e \u003cli\u003eThe tricks behind creating queries that get answers\u003c\/li\u003e \u003cli\u003eIdeas on creating eye-catching reports\u003c\/li\u003e \u003cli\u003eTips on troubleshooting Access\u003c\/li\u003e \u003c\/ul\u003e","brand":"For Dummies","offers":[{"title":"Default Title","offer_id":47988652802277,"sku":"NP9781119083108","price":29.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119083108.jpg?v=1761781126","url":"https:\/\/k12savings.com\/products\/access-2016-for-dummies-isbn-9781119083108","provider":"K12savings","version":"1.0","type":"link"}