Details

Access For Dummies

1. Aufl.

von: Laurie A. Ulrich, Ken Cook
20,99 €
Verlag:	Wiley
Format:	PDF
Veröffentl.:	10.11.2021
ISBN/EAN:	9781119829096
Sprache:	englisch
Anzahl Seiten:	432

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

Become a database boss —and have fun doing it—with this accessible and easy-to-follow guide to Microsoft Access Databases hold the key to organizing and accessing all your data in one convenient place. And you don’t have to be a data science wizard to build, populate, and organize your own. With Microsoft Access For Dummies, you’ll learn to use the latest version of Microsoft’s Access software to power your database needs. Need to understand the essentials before diving in? Check out our Basic Training in Part 1 where we teach you how to navigate the Access workspace and explore the foundations of databases. Ready for more advanced tutorials? Skip right to the sections on Data Management, Queries, or Reporting where we walk you through Access’s more sophisticated capabilities. Not sure if you have Access via Office 2021 or Office 365? No worries – this book covers Access now matter how you access it. The book also shows you how to: <ul> <li>Handle the most common problems that Access users encounter </li> <li>Import, export, and automatically edit data to populate your next database </li> <li>Write powerful and accurate queries to find exactly what you’re looking for, exactly when you need it </li> </ul> Microsoft Access For Dummies is the perfect resource for anyone expected to understand, use, or administer Access databases at the workplace, classroom, or any other data-driven destination.

Inhaltsverzeichnis

Introduction 1 Part 1: Basic Training 5 Chapter 1: Access Basic Training 7 Chapter 2: Navigating the Access Workspace 25 Chapter 3: Database Basics 43 Part 2: Getting It All on the Table 63 Chapter 4: Sounds Like a Plan 65 Chapter 5: Table Tune-Ups 77 Chapter 6: Remodeling Your Data 95 Chapter 7: Types, Masks, and Triggers 111 Part 3: Data Management Mania 135 Chapter 8: A Form for All Reasons 137 Chapter 9: Importing and Exporting Data 157 Chapter 10: Automatically Editing Data 171 Chapter 11: Access and the Web 183 Part 4: The Power of Questions 197 Chapter 12: Finding, Filtering, and Sorting Your Data — Fast 199 Chapter 13: I Was Just Asking for Answers 215 Chapter 14: I Want These AND Those OR Them 241 Chapter 15: Number Crunching with the Total Row. 249 Chapter 16: Express Yourself with Formulas 263 Chapter 17: Take Charge with Action Queries 277 Part 5: Simple and Snazzy Reporting. 289 Chapter 18: Fast and Furious Automatic Reporting 291 Chapter 19: Professionally Designed Reports Made Easy 313 Chapter 20: Groups and Page Breaks, Headers and Footers 341 Chapter 21: Mailings to the Masses 363 Part 6: The Part of Tens 371 Chapter 22: Ten Common Problems 373 Chapter 23: Ten Uncommon Tips 385 Appendix A: Getting Help 393 Index 395

Autorenportrait

Laurie Ann Ulrich is a professional author and trainer on all things technology. Along with recent editions of Access For Dummies, she’s also written books on Excel, Photoshop, and Dreamweaver. Ken Cook is a professional database developer and author who has written on Access and Excel.

Back cover copy

Become a data-boss with this one-stop guide Databases are powerful tools. And they’re not just for data science wizards! In this book, you’ll learn how to design, create, and organize useful and intuitive Access databases perfect for your office, classroom, or anywhere you need to wrangle data. From navigating the Access interface to creating professional-looking reports, this book walks you through the steps you need to take to unlock the potential of your organization’s data. There’s nothing standing between you and the insights your data holds! Inside… <ul><li>Navigate the Access interface</li> <li>Import, export, and organize data</li> <li>Design your database tables</li> <li>Edit your data automatically</li> <li>Create useful forms</li> <li>Harness cloud functionality</li> <li>Build powerful queries</li> <li>Draft intuitive reports</li></ul>