Access For Dummies (eBook)
432 Seiten
John Wiley & Sons (Verlag)
978-1-119-82910-2 (ISBN)
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:
* Handle the most common problems that Access users encounter
* Import, export, and automatically edit data to populate your next database
* Write powerful and accurate queries to find exactly what you're looking for, exactly when you need it
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.
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.
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
| Erscheint lt. Verlag | 16.11.2021 |
|---|---|
| Sprache | englisch |
| Themenwelt | Mathematik / Informatik ► Informatik ► Datenbanken |
| Informatik ► Office Programme ► Access | |
| Informatik ► Office Programme ► Outlook | |
| Schlagworte | ACCESS • Computer-Ratgeber • End-User Computing • Office Productivity-Microsoft (General & Office suite) • Office-Software Microsoft |
| ISBN-10 | 1-119-82910-0 / 1119829100 |
| ISBN-13 | 978-1-119-82910-2 / 9781119829102 |
| Haben Sie eine Frage zum Produkt? |
EPUB (Adobe DRM)Größe: 15,6 MB
Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM
Dateiformat: EPUB (Electronic Publication)
EPUB ist ein offener Standard für eBooks und eignet sich besonders zur Darstellung von Belletristik und Sachbüchern. Der Fließtext wird dynamisch an die Display- und Schriftgröße angepasst. Auch für mobile Lesegeräte ist EPUB daher gut geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine
Geräteliste und zusätzliche Hinweise
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
