Access 2007 Bible (eBook)

eBook Download: PDF
2007 | 1. Auflage
1416 Seiten
John Wiley & Sons (Verlag)
978-0-470-12139-9 (ISBN)

Lese- und Medienproben

Access 2007 Bible - Michael R. Groh, Joseph C. Stockman, Gavin Powell, Cary N. Prague, Michael R. Irwin, Jennifer Reardon
Systemvoraussetzungen
37,99 inkl. MwSt
  • Download sofort lieferbar
  • Zahlungsarten anzeigen
"I recommend this book for anyone who wants a strong foundation inAccess."
--Jeff Lenamon, CIBC World Markets

Updated edition with exciting new Access 2007features!

Harness the power of Access 2007 with the expert guidance inthis comprehensive reference. Beginners will appreciate thethorough attention to database fundamentals and terminology.Experienced users can jump right into Access 2007 enhancements likethe all-new user interface and wider use of XML and Web services.Each of the book's six parts thoroughly focuses on key elements ina logical sequence, so you have what you need, when you need it.Designed as both a reference and a tutorial, Access 2007 Bible is apowerful tool for developers needing to make the most of the newfeatures in Access 2007.
* Build Access tables using good relational databasetechniques
* Construct efficient databases using a five-step designmethod
* Design efficient data-entry and data display forms
* Utilize the improved Access report designer
* Use Visual Basic(r) for Applications and the VBA Editor toautomate applications
* Build and customize Access 2007 ribbons
* Seamlessly exchange Access data with SharePoint(r)
* Employ advanced techniques such as the Windows(r) API andobject-oriented programming
* Add security and use data replication in your Accessapplications

What's on the CD-ROM?

Follow the examples in the book chapter by chapter using thebonus materials on the CD-ROM. You'll find separate MicrosoftAccess database files for each chapter and other working files,including
* All the examples and databases used in the book, includingdatabase files, images, data files in various formats, and iconfiles used in the book's examples
* A complete sample application file, including queries, reports,objects, and modules, that you can use as a reference

See the CD-ROM appendix for details and complete systemrequirements.

Note: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.

Acknowledgments xxxix

Foreword xli

Part I: Access Building Blocks 1

Chapter 1: An Introduction to Database Development 3

Chapter 2: Creating Access Tables 23

Chapter 3: Designing Bulletproof Databases 87

Chapter 4: Selecting Data with Queries 123

Chapter 5: Using Operators and Expressions in Access 161

Chapter 6: Working with Datasheet View 203

Chapter 7: Creating Basic Access Forms 237

Chapter 8: Working with Data on Access Forms 269

Chapter 9: Presenting Data with Access Reports 297

Part II: Programming Microsoft Access 345

Chapter 10: VBA Programming Fundamentals 347

Chapter 11: Mastering VBA Data Types and Procedures 385

Chapter 12: Understanding the Access Event Model 417

Chapter 13: Using Expressions in Queries and VBA Code 443

Chapter 14: Accessing Data with VBA Code 471

Chapter 15: Using the VBA Debugging Tools 497

Part III: More Advanced Access Techniques 523

Chapter 16: Working with External Data 525

Chapter 17: Importing and Exporting Data 555

Chapter 18: Advanced Access Query Techniques 581

Chapter 19: Advanced Access Form Techniques 617

Chapter 20: Advanced Access Report Techniques 647

Chapter 21: Building Multiuser Applications 685

Chapter 22: Integrating Access with Other Applications 723

Chapter 23: Integrating Access with SharePoint 749

Chapter 24: Using ActiveX Controls 769

Chapter 25: Handling Errors and Exceptions 801

Part IV: Professional Database Development 821

Chapter 26: Optimizing Access Applications 823

Chapter 27: Advanced Data Access with VBA 863

Chapter 28: Bulletproofing Access Applications 877

Chapter 29: Securing Access Applications 909

Chapter 30: Using the Windows API 951

Chapter 31: Using the Access Replication Features 987

Chapter 32: Object-Oriented Programming with VBA 1037

Chapter 33: Reusing VBA Code with Libraries 1079

Chapter 34: Customizing Access Ribbons 1089

Chapter 35: Distributing Access Applications 1117

Chapter 36: Using Access Macros 1133

Part V: Access as an Enterprise Platform 1163

Chapter 37: Using XML in Access 2007 1165

Chapter 38: SharePoint as a Data Source 1191

Chapter 39: Client/Server Concepts 1209

Chapter 40: SQL Server as an Access Companion 1223

Chapter 41: Upsizing Access Databases to SQL Server 1249

Part VI: Appendixes 1265

Appendix A: Access 2007 Specifications 1267

Appendix B: What's on the CD-ROM 1275

Appendix C: What's New in Access 2007 1279

Index 1291

Wiley Publishing, Inc. End-User License Agreement 1362

Erscheint lt. Verlag 4.1.2007
Reihe/Serie Bible
Sprache englisch
Themenwelt Mathematik / Informatik Informatik Datenbanken
Informatik Office Programme Access
Schlagworte Access 2007 • Computer-Ratgeber • End-User Computing • Microsoft Access
ISBN-10 0-470-12139-4 / 0470121394
ISBN-13 978-0-470-12139-9 / 9780470121399
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