{"product_id":"access-2010-all-in-one-for-dummies-isbn-9780470532188","title":"Access 2010 All-in-One For Dummies","description":"\u003cb\u003eThe all-in-one reference to all aspects of Microsoft Access 2010\u003c\/b\u003e  \u003cp\u003eIf you want to learn Microsoft Access inside and out, the nine minibooks in this easy-access reference are exactly what you need. Read the book cover to cover, or jump into any of the minibooks for the instruction and topics you need most. Learn how to connect Access to SQL Server, manipulate your data locally, use nifty new features from Office 2010 such as the enhanced Ribbon, create queries and macros like a champ, and much more. From the basics to advanced functions, it’s what you need to make Access more accesssible.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eShows you how to store, organize, view, analyze, and share data using Microsoft Access 2010, the database application included with Microsoft Office 2010\u003c\/li\u003e \u003cli\u003eIncludes nine minibooks that cover such topics as database design, tables, queries, forms, reports, macros, database administration, securing data, programming with Visual Basic for Applications (VBA), and using Access with the Web\u003c\/li\u003e \u003cli\u003eHelps you build database solutions that integrate with the Web and other enterprise data sources\u003c\/li\u003e \u003cli\u003eOffers plenty of techniques, tips, and tricks to help you get the most out of Access\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eThis all-in-one guide contains everything you need to start power-using Access 2010!\u003c\/p\u003e \u003cp\u003eIntroduction 1\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook I: Essential Concepts 7\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Introducing Access 2010 9\u003c\/p\u003e \u003cp\u003eChapter 2: Getting Started, Getting Around 17\u003c\/p\u003e \u003cp\u003eChapter 3: Designing Your Database the Relational Way 37\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook II: Tables for Storing Your Data 65\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Creating and Modifying Tables 67\u003c\/p\u003e \u003cp\u003eChapter 2: Refining Your Table in Design View 103\u003c\/p\u003e \u003cp\u003eChapter 3: Sorting, Finding, and Filtering Data in a Datasheet 121\u003c\/p\u003e \u003cp\u003eChapter 4: Importing and Exporting Data 137\u003c\/p\u003e \u003cp\u003eChapter 5: Avoiding “Garbage In, Garbage Out” 161\u003c\/p\u003e \u003cp\u003eChapter 6: Relating Your Tables and Protecting Your Data 179\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook III: Queries (or Getting Information from Your Data) 189\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Creating Select Queries 191\u003c\/p\u003e \u003cp\u003eChapter 2: Letting Queries Do the Math 223\u003c\/p\u003e \u003cp\u003eChapter 3: Doing Neat Things with Action Queries and Query Wizards 257\u003c\/p\u003e \u003cp\u003eChapter 4: Viewing Your Data from All Angles Using Crosstabs and PivotTables 279\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook IV: Forms for Editing Data 303\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Designing and Using Forms (and Reports) 305\u003c\/p\u003e \u003cp\u003eChapter 2: Jazzing Up Your Forms (and Reports) 329\u003c\/p\u003e \u003cp\u003eChapter 3: Creating Smarter Forms 353\u003c\/p\u003e \u003cp\u003eChapter 4: Doing Calculations in Forms and Subforms (and Reports) 377\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook V: Reporting in Words and Pictures 397\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Creating and Spiffing Up Reports 399\u003c\/p\u003e \u003cp\u003eChapter 2: Printing Beautiful Reports 427\u003c\/p\u003e \u003cp\u003eChapter 3: Creating Charts and Graphs from Your Data 445\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook VI: Automation with Macros 471\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Making Macros Do the Work 473\u003c\/p\u003e \u003cp\u003eChapter 2: Making Macros Smarter 491\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook VII: Database Administration 509\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Database Housekeeping 511\u003c\/p\u003e \u003cp\u003eChapter 2: Sharing the Fun: Managing Multiuser Access 521\u003c\/p\u003e \u003cp\u003eChapter 3: Securing Your Access Database 535\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook VIII: Programming in VBA 547\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: What the Heck Is VBA? 549\u003c\/p\u003e \u003cp\u003eChapter 2: Writing Code 569\u003c\/p\u003e \u003cp\u003eChapter 3: Writing Smarter Code 593\u003c\/p\u003e \u003cp\u003eChapter 4: Controlling Forms with VBA 617\u003c\/p\u003e \u003cp\u003eChapter 5: Using SQL and Recordsets 641\u003c\/p\u003e \u003cp\u003eChapter 6: Debugging Your Code 653\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook IX: Going Beyond Access 663\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Automation with Other Office Programs 665\u003c\/p\u003e \u003cp\u003eChapter 2: Using Access as a Front-End to SQL Server 681\u003c\/p\u003e \u003cp\u003eChapter 3: Using Access with SharePoint 697\u003c\/p\u003e \u003cp\u003eAppendix: Installing Microsoft Access 719\u003c\/p\u003e \u003cp\u003eIndex 725\u003c\/p\u003e  \u003cb\u003eAlison Barrows\u003c\/b\u003e has written books on Access, Windows, and the Internet, including \u003ci\u003eAccess For Dummies Quick Reference\u003c\/i\u003e.  \u003cp\u003e\u003cb\u003eMargaret Levine Young\u003c\/b\u003e is coauthor of over two dozen books, including \u003ci\u003eThe Internet For Dummies\u003c\/i\u003e.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eJoseph C. Stockman\u003c\/b\u003e is an independent consultant, software designer, and author.\u003c\/p\u003e  \u003cb\u003eBuild powerful custom database solutions to keep your data organized and accessible\u003c\/b\u003e  \u003cp\u003eWhat kind of golden nuggets are in your data? This reference shows how to take advantage of Microsoft Access 2010's new features and capabilities so you can, well, access the information you need. You'll breeze through everything from tables, queries, and forms to database administration and Visual Basic for Applications as you learn this program.\u003c\/p\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eSet the table — follow easy ways to make new tables, create table templates, and utilize the Table Wizard\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003ePick and choose your data — learn how to find the information you want and organize it in a way that's more useful\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eGet creative with forms — build your own forms using the Form Wizard\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eCut your workload — find out how to write simple instructions that tell Access how to automate steps instead of doing it yourself\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eShow it off — see the best ways to design reports and print form letters, mailing labels, numbers with totals and subtotals, and more\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eKeep your database clean — discover what you need to do to ensure that your data is neat and tidy\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eGo beyond Access — interact with and move data to and from other programs on your computer or computers all over the world\u003c\/p\u003e \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003cb\u003eOpen the book and find:\u003c\/b\u003e\u003c\/p\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eHow to easily design your relational database\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eWays to create select queries\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eHow to design and use forms for editing data\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eTechniques for spiffing up reports with charts and graphs\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eMethods for making macros smarter\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eSteps for securing your database\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eTips for programming in VBA\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eHow to use Access with SharePoint and SQL Server\u003c\/p\u003e \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003cb\u003e9 Books in 1\u003c\/b\u003e\u003c\/p\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eEssential Concepts\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eTables\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eQueries\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eForms\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eReports\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eMacros\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eDatabase Administration\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eProgramming in VBA\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eGoing Beyond Access\u003c\/p\u003e \u003c\/li\u003e \u003c\/ul\u003e","brand":"For Dummies","offers":[{"title":"Default Title","offer_id":47988652900581,"sku":"NP9780470532188","price":39.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9780470532188.jpg?v=1761781127","url":"https:\/\/k12savings.com\/products\/access-2010-all-in-one-for-dummies-isbn-9780470532188","provider":"K12savings","version":"1.0","type":"link"}