Details

Access 2016 For Dummies

1. Aufl.

von: Laurie A. Ulrich, Ken Cook
19,99 €
Verlag:	Wiley
Format:	PDF
Veröffentl.:	13.10.2015
ISBN/EAN:	9781119083276
Sprache:	englisch
Anzahl Seiten:	464

In den Warenkorb

Als Gutschein

DRM-geschütztes eBook, Sie benötigen z.B. Adobe Digital Editions und eine Adobe ID zum Lesen.

Beschreibungen

Titelbeschreibung

Your all-access guide to all things Access 2016 If 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. <ul> <li>Speak the lingo of database builders and create databases that suit your needs</li> <li>Organize your data into tables and build forms that ease data entry</li> <li>Query your data to get answers right</li> <li>Create reports that tell the story of your data findings</li> </ul> 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.

Inhaltsverzeichnis

Introduction 1 Part I: Getting Started with Access 2016 5 Chapter 1: Access 2016 Basic Training 7 Chapter 2: Navigating the Access Workspace 27 Chapter 3: Database Basics 49 Chapter 4: Sounds Like a Plan 67 Part II: Getting It All on the Table 77 Chapter 5: Table Tune Ups 79 Chapter 6: Remodeling Your Data 97 Chapter 7: Types, Masks, and Triggers 113 Part III: Data Management Mania 137 Chapter 8: A Form for All Reasons 139 Chapter 9: Importing and Exporting Data 157 Chapter 10: Automatic Data Editing 171 Chapter 11: Access and the Web 183 Part IV: The Power of Questions 203 Chapter 12: Finding, Filtering, and Sorting Your Data — Fast 205 Chapter 13: I Was Just Asking for Answers 221 Chapter 14: I Want These AND Those OR Them 247 Chapter 15: Number Crunching with the Total Row 255 Chapter 16: Express Yourself with Formulas 267 Chapter 17: Take Charge with Action Queries 281 Part V: Simple and Snazzy Reporting 291 Chapter 18: Fast and Furious Automatic Reporting 293 Chapter 19: Professionally Designed Reports Made Easy 315 Chapter 20: Headers and Footers and Groups, Oh My! 341 Chapter 21: Magical Mass Mailings 361 Part VI: More Power to You 369 Chapter 22: Analyze This! 371 Chapter 23: Steer Users in the Right Direction with Navigation Forms 381 Part VII: The Part of Tens 391 Chapter 24: Ten Common Problems 393 Chapter 25: Ten Uncommon Tips 403 Appendix A: Getting Help 409 Index 417

Autorenportrait

Laurie Ulrich Fuller is a professional technology author and trainer. She's created training materials that cover Microsoft Office and Adobe Creative Suite. Ken Cook is a professional database developer, instructor, and author. The two experts have teamed to write the previous three editions of Access For Dummies.

Back cover copy

Learn to: <ul> <li> Speak the lingo of database developers and create databases that suit your needs</li> <li> Organize your data into tables and build forms that simplify data entry</li> <li> Query your data to get answers and insight</li> <li> Create reports that present data in a way that's easy to understand</li> </ul> Unlock the magic of databases and see how Access 2016 can make your life easier! A good database makes it easy to store, find, and report on the data you need. With a bit of the know-how in this book, you can create an outstanding relational database. Follow the simple steps to learn how to build data tables, establish relationships between your tables, create forms, execute queries, and generate reports that squeeze all the value out of your data. <ul> <li> Database basics — explore databases, database terminology, how Access works, and how to navigate the program</li> <li> Table talk — learn to plan and build tables, use primary keys, and understand table relationships</li> <li> Magical management — generate useful forms, import data from various sources, learn to edit data automatically, and use Access with the web</li> <li> Data Q&A — query your data using filter and sort tools, run the Query Wizard, and update lots of data quickly using Action Queries</li> <li> Reporting for duty — create quick automatic reports, design individualized reports with great presentation features, and develop mass mailings</li> <li> Analyze this — use the Analyzer tools to make your database more efficient and help database users find their way with navigation forms</li> </ul> Open the book and find: <ul> <li>How to build a database from the ground up</li> <li>The rules of making tables that organize your data</li> <li>Steps for building forms using the Form Wizard</li> <li>How to import data from other sources</li> <li>Advice on sharing data on the Web</li> <li>Fast ways to find data in your database</li> <li>The tricks behind creating queries that get answers</li> <li>Ideas on creating eye-catching reports</li> <li>Tips on troubleshooting Access</li> </ul>