Access 2013 For Dummies

The easy guide to Microsoft Access returns with updates on the latest version! Microsoft Access allows you to store, organize, view, analyze, and share data; the new Access 2013 release enables you to build even more powerful, custom database solutions that integrate with the web and enterprise data sources. Access 2013 For Dummies covers all the new features of the latest version of Accessand serves as an ideal reference, combining the latest Access features with the basics of building usable databases. You'll learn how to create an app from the Welcome screen, get support for your desktop databases, and much more. Includes coverage of all the new features of Access 2013, including the updated interface Shows you how to create and share reports Features special videos and materials created by the authors to help reinforce the lessons included in the book Helps you build data analysis and interface tools for your specific needs Offers plenty of techniques and tips for solving common problems Access 2013 For Dummies provides you with access to the latest version of this database tool.

The easy guide to Microsoft Access returns with updates onthe latest version!Microsoft Access allows you to store, organize, view, analyzeand share data; the new Access 2013 release enables you to buildeven more powerful, custom database solutions that integrate withthe web and enterprise data sources. Access 2013 For Dummiescovers all the new features of the latest version of Accessandserves as an ideal reference, combining the latest Access featureswith the basics of building usable databases. You'll learn how tocreate an app from the Welcome screen, get support for your desktopdatabases, and much more.* Includes coverage of all the new features of Access 2013including the updated interface* Shows you how to create and share reports* Features special videos and materials created by the authors tohelp reinforce the lessons included in the book* Helps you build data analysis and interface tools for yourspecific needs* Offers plenty of techniques and tips for solving commonproblemsAccess 2013 For Dummies provides you with access to thelatest version of this database tool.

Introduction 1Part I: Getting Started with Access 2013 9Chapter 1: Access 2013 Basic Training 11Chapter 2: Navigating the Access Workspace 33Chapter 3: Database Basics 55Part II: Setting the Table 73Chapter 4: Table Tune Ups 75Chapter 5: Remodeling Your Data 91Chapter 6: Types, Masks, and Triggers 109Part III: Data Management Mania 131Chapter 7: A Form for All Reasons 133Chapter 8: Importing and Exporting Data 147Chapter 9: Automatic Data Editing 159Chapter 10: Access and the Web 171Part IV: Ask Your Data, and Ye Shall Receive Answers 193Chapter 11: Finding, Filtering, and Sorting Your Data -- Fast 195Chapter 12: I Was Just Asking for Answers 211Chapter 13: I Want These AND Those OR Them 237Chapter 14: Number Crunching with the Total Row 245Chapter 15: Express Yourself with Formulas 257Chapter 16: Take Charge with Action Queries 271Part V: Simple and Snazzy Reporting 281Chapter 17: Fast and Furious Automatic Reporting 283Chapter 18: Professionally Designed Reports Made Easy 305Chapter 19: Headers and Footers and Groups, Oh My! 331Chapter 20: Magical Mass Mailings 353Part VI: More Power to You 361Chapter 21: Analyze This! 363Chapter 22: Steer Users in the Right Direction with Navigation Forms 375Part VII: The Part of Tens 383Chapter 23: Ten Common Problems 385Chapter 24: Ten Uncommon Tips 397Appendix: Getting Help 405Index 413