Microsoft Access 2013 For Dummies -- About the Authors -- Contents at a Glance -- Table of Contents -- Introduction -- About This Book -- Conventions Used in This Book -- What You Don't Have to Read -- Foolish Assumptions -- How This Book Is Organized -- Icons Used in This Book -- Where to Go from Here -- Part I: Getting Started with Access 2013 -- Chapter 1: Access 2013 Basic Training -- What Is Access Good For, Anyway? -- What's New in Access 2013? -- How Access Works and How You Work with It -- Now What? -- Chapter 2: Navigating the Access Workspace -- Diving Right In -- Working with Onscreen Tools in Access -- Customizing the Access Workspace -- Mousing Around -- Navigating Access with the Alt Key -- Chapter 3: Database Basics -- Database Lingo -- Field Types and Uses -- Choosing Between Flat and Relational Databases -- Building a Database -- Adding and Removing Tables -- Part II: Setting the Table -- Chapter 4: Table Tune Ups -- The Primary Key to Success -- Making Tables Get Along -- Building Table Relationships -- Indexing for Faster Queries -- Chapter 5: Remodeling Your Data -- Opening a Table for Editing -- Inserting Records and Fields -- Modifying Field Content -- Name-Calling -- Turn Uh-Oh! into Yee-Hah! -- Chapter 6: Types, Masks, and Triggers -- Access Table Settings -- Field Data Formats -- Gaining Control of Data Entry -- Give Your Fingers a Mini Vacation by Default -- Part III: Data Management Mania -- Chapter 7: A Form for All Reasons -- Generating Forms -- Customizing Form Parts -- Chapter 8: Importing and Exporting Data -- Retrieving Data from Other Sources -- Hit the Road, Data -- Chapter 9: Automatic Data Editing -- Please Read This First! -- Creating Consistent Corrections -- Using Queries to Automate the Editing Process -- Chapter 10: Access and the Web -- How Access Works with the Web -- Understanding Office 365.

Meet the Custom Web App -- Click! Using Hyperlinks in Your Access Database -- Embedding Web Content into Your Access Forms -- Publishing Your Data to the Web -- Part IV: Ask Your Data, and Ye Shall Receive Answers -- Chapter 11: Finding, Filtering, and Sorting Your Data - Fast -- Using the Find Command -- Sorting from A to Z or Z to A -- Fast and Furious Filtering -- Chapter 12: I was Just Asking…for Answers -- Simple ( Yet Potent) Filter and Sort Tools -- Select Queries -- Getting Your Feet Wet with Ad Hoc Queries -- Chapter 13: I Want These AND Those OR Them -- Working with AND and/or OR -- Combining AND with OR and OR with AND -- Chapter 14: Number Crunching with the Total Row -- Kissing That Calculator Goodbye via the Total Row -- Adding the Total Row to Your Queries -- Giving the Total Row a Workout -- Creating Your Own Top-Ten List -- Choosing the Right Field for the Summary Instruction -- Chapter 15: Express Yourself with Formulas -- A Simple Calculation -- Complex Calculations -- Hooray for the Expression Builder -- Chapter 16: Take Charge with Action Queries -- Easy Update -- Add Records in a Flash -- Quick Cleanup -- Part V: Simple and Snazzy Reporting -- Chapter 17: Fast and Furious Automatic Reporting -- Quick and Not-So-Dirty Automatic Reporting -- Previewing Your Report -- Beauty Is Only Skin ( Report) Deep -- Chapter 18: Professionally Designed Reports Made Easy -- Report Repairs -- Report Organization -- Formatting Stuff -- Sneaking a Peek -- Getting a Themes Makeover -- Adding More Design Elements -- Chapter 19: Headers and Footers and Groups, Oh My! -- A Place for Everything and Everything in Its Place -- Customizing Properties -- Chapter 20: Magical Mass Mailings -- Massive Mailings with the Label Wizard -- Part VI: More Power to You -- Chapter 21: Analyze This! -- From Flat File to Relational Tables with Table Analyzer.

Record Database Object Information with the Database Documenter -- Improve Database Performance without Steroids -- Chapter 22: Steer Users in the Right Direction with Navigation Forms -- The Comings and Goings of a Navigation Form -- Am I in the Right Place? Testing Navigation Forms -- Maintaining the Navigation Form -- Displaying the Navigation Form at Startup -- Part VII: The Part of Tens -- Chapter 23: Ten Common Problems -- That's Just Not Normal -- You Type 73.725, but It Changes to 74 -- The Words They Are A-Changing -- Was There and Now It's Gone -- You Run a Query, but the Results Aren't What You Expect -- The Dreaded Parameter Dialog Box -- The Slowest Database in Town -- Your Database File Is as Big as a Whale -- You Get a Mess When Importing Your Spreadsheet -- We're Sorry -- Your Database File Is Corrupt -- Chapter 24: Ten Uncommon Tips -- Document Everything as Though One Day You'll be Questioned by the FBI -- Keep Your Fields as Small as Possible -- Use Number Fields for Real Numbers -- Validate Your Data -- Use Understandable Names to Keep Things Simple -- Delete with Great Caution -- Backup, Backup, Backup -- Think, Think, and Think Again -- Get Organized and Stay Organized -- There's No Shame in Asking for Help -- Appendix: Getting Help -- Asking Access for Help -- Online Help -- Who's Our Next Caller? -- Index.