Microsoft 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. Microsoft Access 2013 For Dummies 1 About the Authors 7 Contents at a Glance 9 Table of Contents 11 Introduction 19 About This Book 19 Conventions Used in This Book 20 What You Don’t Have to Read 20 Foolish Assumptions 21 How This Book Is Organized 21 Icons Used in This Book 24 Where to Go from Here 25 Part I: Getting Started with Access 2013 27 Chapter 1: Access 2013 Basic Training 29 What Is Access Good For, Anyway? 30 What’s New in Access 2013? 39 How Access Works and How You Work with It 42 Now What? 48 Chapter 2: Navigating the Access Workspace 51 Diving Right In 53 Working with Onscreen Tools in Access 56 Customizing the Access Workspace 62 Mousing Around 71 Navigating Access with the Alt Key 71 Chapter 3: Database Basics 73 Database Lingo 73 Field Types and Uses 76 Choosing Between Flat and Relational Databases 80 Building a Database 83 Adding and Removing Tables 86 Part II: Setting the Table 91 Chapter 4: Table Tune Ups 93 The Primary Key to Success 93 Making Tables Get Along 97 Building Table Relationships 99 Indexing for Faster Queries 104 Chapter 5: Remodeling Your Data 109 Opening a Table for Editing 110 Inserting Records and Fields 113 Modifying Field Content 119 Name-Calling 120 Turn Uh-Oh! into Yee-Hah! 124 Chapter 6: Types, Masks, and Triggers 127 Access Table Settings 127 Field Data Formats 130 Gaining Control of Data Entry 138 Give Your Fingers a Mini Vacation by Default 147 Part III: Data Management Mania 149 Chapter 7: A Form for All Reasons 151 Generating Forms 151 Customizing Form Parts 158 Chapter 8: Importing and Exporting Data 165 Retrieving Data from Other Sources 166 Hit the Road, Data 174 Chapter 9: Automatic Data Editing 177 Please Read This First! 177 Creating Consistent Corrections 179 Using Queries to Automate the Editing Process 182 Chapter 10: Access and the Web 189 How Access Works with the Web 189 Understanding Office 365 190 Meet the Custom Web App 191 Click! Using Hyperlinks in Your Access Database 193 Embedding Web Content into Your Access Forms 199 Publishing Your Data to the Web 205 Part IV: Ask Your Data, and Ye Shall Receive Answers 211 Chapter 11: Finding, Filtering, and Sorting Your Data — Fast 213 Using the Find Command 214 Sorting from A to Z or Z to A 218 Fast and Furious Filtering 220 Chapter 12: I was Just Asking...for Answers 229 Simple ( Yet Potent) Filter and Sort Tools 230 Select Queries 240 Getting Your Feet Wet with Ad Hoc Queries 247 Chapter 13: I Want These AND Those OR Them 255 Working with AND and/or OR 255 Combining AND with OR and OR with AND 261 Chapter 14: Number Crunching with the Total Row 263 Kissing That Calculator Goodbye via the Total Row 263 Adding the Total Row to Your Queries 265 Giving the Total Row a Workout 266 Creating Your Own Top-Ten List 272 Choosing the Right Field for the Summary Instruction 273 Chapter 15: Express Yourself with Formulas 275 A Simple Calculation 276 Complex Calculations 278 Hooray for the Expression Builder 283 Chapter 16: Take Charge with Action Queries 289 Easy Update 290 Add Records in a Flash 294 Quick Cleanup 297 Part V: Simple and Snazzy Reporting 299 Chapter 17: Fast and Furious Automatic Reporting 301 Quick and Not-So-Dirty Automatic Reporting 302 Previewing Your Report 313 Beauty Is Only Skin ( Report) Deep 317 Chapter 18: Professionally Designed Reports Made Easy 323 Report Repairs 324 Report Organization 326 Formatting Stuff 330 Sneaking a Peek 343 Getting a Themes Makeover 344 Adding More Design Elements 345 Chapter 19: Headers and Footers and Groups, Oh My! 349 A Place for Everything and Everything in Its Place 350 Customizing Properties 358 Chapter 20: Magical Mass Mailings 371 Massive Mailings with the Label Wizard 371 Part VI: More Power to You 379 Chapter 21: Analyze This! 381 From Flat File to Relational Tables with Table Analyzer 382 Record Database Object Information with the Database Documenter 386 Improve Database Performance without Steroids 390 Chapter 22: Steer Users in the Right Direction with Navigation Forms 393 The Comings and Goings of a Navigation Form 393 Am I in the Right Place? Testing Navigation Forms 396 Maintaining the Navigation Form 397 Displaying the Navigation Form at Startup 399 Part VII: The Part of Tens 401 Chapter 23: Ten Common Problems 403 That’s Just Not Normal 403 You Type 73.725, but It Changes to 74 404 The Words They Are A-Changing 405 Was There and Now It’s Gone 406 You Run a Query, but the Results Aren’t What You Expect 407 The Dreaded Parameter Dialog Box 409 The Slowest Database in Town 409 Your Database File Is as Big as a Whale 411 You Get a Mess When Importing Your Spreadsheet 412 We’re Sorry; Your Database File Is Corrupt 412 Chapter 24: Ten Uncommon Tips 415 Document Everything as Though One Day You’ll be Questioned by the FBI 416 Keep Your Fields as Small as Possible 417 Use Number Fields for Real Numbers 418 Validate Your Data 418 Use Understandable Names to Keep Things Simple 418 Delete with Great Caution 419 Backup, Backup, Backup 419 Think, Think, and Think Again 420 Get Organized and Stay Organized 420 There’s No Shame in Asking for Help 420 Appendix: Getting Help 423 Asking Access for Help 424 Online Help 426 Who’s Our Next Caller? 428 Index 431

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 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 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 Access and 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 Drowning in data? Learn to manage it all and make it useful with the tools in Access 2013. This guide will help you organize your data, produce reports that make you look like a genius, and create forms that enable your staff to enter and manage more data -- Source other than Library of Congress