Book description
Your all-access guide to all things Access 2016If you don't know a relational database from an isolationist table—but still need to figure out how to organize and analyze your data—Access 2016 For Dummies 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 Access 2016 For Dummies is the only resource you'll need to go from data rookie to data pro!
This expanded and updated edition of Access For Dummies 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.
- Speak the lingo of database builders and create databases that suit your needs
- Organize your data into tables and build forms that ease data entry
- Query your data to get answers right
- Create reports that tell the story of your data findings
If you have little to no experience with creating and managing a database of any sort, Access 2016 For Dummies is the perfect starting point for learning the basics of building databases, simplifying data entry and reporting, and improving your overall data skills.
Table of contents
-
- Cover
- Introduction
- Part I: Getting Started with Access 2016
- Part II: Getting It All on the Table
- Part III: Data Management Mania
- Part IV: The Power of Questions
- Part V: Simple and Snazzy Reporting
- Part VI: More Power to You
-
Part VII: The Part of Tens
-
Chapter 24: 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 25: 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 A: Getting Help
-
Chapter 24: Ten Common Problems
- About the Authors
- Cheat Sheet
- Advertisement Page
- Connect with Dummies
- End User License Agreement
Product information
- Title: Access 2016 For Dummies
- Author(s):
- Release date: November 2015
- Publisher(s): For Dummies
- ISBN: 9781119083108
You might also like
video
Access 2016 For Dummies Course
Before you access the world of Access 2016, it pays to plan how you want to …
book
Access 2019 For Dummies
Easy steps to practical databases People who really know how to build, populate, and simplify databases …
book
Access For Dummies
Become a database boss —and have fun doing it—with this accessible and easy-to-follow guide to Microsoft …
video
Microsoft Access Beginners 2016
Microsoft Access is the leading database application and has become a standard in businesses and organizations …