Access Forms and Reports For Dummies (eBook)

(Autor)

eBook Download: PDF
2005 | 1. Auflage
416 Seiten
John Wiley & Sons (Verlag)
978-0-471-77626-0 (ISBN)

Lese- und Medienproben

Access Forms and Reports For Dummies - Brian Underdahl
Systemvoraussetzungen
22,99 inkl. MwSt
  • Download sofort lieferbar
  • Zahlungsarten anzeigen
Create queries that make forms and reports useful

Develop forms to access the data you need and make reports that
make sense!

If you thought you had to use a spreadsheet program to produce
reports and forms, guess what! Access can turn out great-looking
forms and reports that actually show what's going on with your data
-- if you know how to ask it nicely. This hands-on guide helps you
do just that, and it works with all versions of Access.

Discover how to

* Ask Access the right questions

* Work with sets of data

* Create simple forms with a wizard

* Use queries to create new tables

* Troubleshoot queries

* Add visual features to reports

Brian Underdahl is the well-known, best selling author of over 70 computer books on a broad range of subjects. He has appeared on a number of TV shows, including the Computer Chronicles, and several TechTV programs, and is the subject of an hour-long interview on the syndicated Computer Outlook radio program. One of his titles was recently recommended to viewers by Scott Gurvey, Bureau Chief, on the Nightly Business Report on PBS, and his books have won awards including an Award of Merit from the Northern California Technical Communications Competition and the Referenceware Excellence Award for best title in the Graphic Design and Multimedia category. Brian has been involved in personal computers from their beginning and has a background in electrical engineering. His last "real" job was as a Senior Programmer/Analyst for a large company, where he worked hard to bring the power and freedom of PCs to the desktops. Brian figures that it's the author who should do the work so that readers can get their money's worth. That's why his books are different -- he takes the time to explain what's going on so that readers can understand the subjects easily.

Introduction 1

Part I: Accessing Both Ends: Getting Data In and Info Out 7

Chapter 1: Getting to Know Forms and Reports 9

Chapter 2: Getting Started with Queries 25

Chapter 3: Creating Simple Forms 45

Chapter 4: Building Basic Reports 67

Part II: Creating Effective Queries 93

Chapter 5: Creating Multi-Table Queries 95

Chapter 6: Modifying Data with Queries 113

Chapter 7: Expanding Queries with SQL 133

Chapter 8: Dealing with Quarrelsome Queries 151

Part III: Building Really Useful Forms 169

Chapter 9: Building Better Forms by Using Controls 171

Chapter 10: Using Multiple Tables in Forms 191

Chapter 11: Fixing Form Faults 205

Part IV: Designing Great Reports 219

Chapter 12: Adding Fancy Touches to Reports 221

Chapter 13: Creating Reports that Summarize Data 241

Chapter 14: When Reports Go Wrong 257

Part V: Way Cool Advanced Queries, Forms, and Reports 267

Chapter 15: Tricks for Finding Data with Queries 269

Chapter 16: Tricks for Updating with Queries 283

Chapter 17: Killer Ways to Improve Forms 295

Chapter 18: Expert Methods for Sharing Reports 315

Chapter 19: Making Reports Look Better 331

Chapter 20: Adding Efficiency with Great Tools 345

Part VI: The Part of Tens 363

Chapter 21: Ten Great Access Sites Online 365

Chapter 22: Ten Things to Know About Queries (That Also Help You with Forms and Reports) 371

Index 375

Erscheint lt. Verlag 10.10.2005
Sprache englisch
Themenwelt Mathematik / Informatik Informatik Datenbanken
Informatik Office Programme Access
Informatik Office Programme Outlook
Schlagworte Computer-Ratgeber • End-User Computing • Microsoft Access
ISBN-10 0-471-77626-2 / 0471776262
ISBN-13 978-0-471-77626-0 / 9780471776260
Haben Sie eine Frage zum Produkt?
PDFPDF (Adobe DRM)

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: PDF (Portable Document Format)
Mit einem festen Seiten­layout eignet sich die PDF besonders für Fach­bücher mit Spalten, Tabellen und Abbild­ungen. Eine PDF kann auf fast allen Geräten ange­zeigt werden, ist aber für kleine Displays (Smart­phone, eReader) nur einge­schränkt geeignet.

Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine Adobe-ID und die Software Adobe Digital Editions (kostenlos). Von der Benutzung der OverDrive Media Console raten wir Ihnen ab. Erfahrungsgemäß treten hier gehäuft Probleme mit dem Adobe DRM auf.
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 Adobe-ID sowie eine kostenlose App.
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.

Mehr entdecken
aus dem Bereich