Groh Access 2010 Bible

1. Auflage 2010
ISBN: 978-0-470-87202-4
Verlag: John Wiley & Sons
Format: PDF
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 1392 Seiten, E-Book

Reihe: Bible

The expert guidance you need to get the most out of Access2010
Get the Access 2010 information you need to succeed with thiscomprehensive reference. If this is your first encounter withAccess, you'll appreciate the thorough attention to databasefundamentals and terminology. If you're familiar with earlierversions, you can jump right into Access 2010 enhancementssuch as the new Access user interface and wider use of XML and Webservices.
* Takes you under the hood of Microsoft Access 2010, the databaseapplication included with Microsoft Office 2010
* Explores the latest enhancements, such as a new user interfaceand wider use of XML and Web services; also, how to exchange datawith Word, Excel, PowerPoint, and other Office apps
* Covers how to create tables, manipulate datasheets, and workwith multiple tables
* Explains the seven database objects and how to use a seven-stepdesign method to build a database tailored to your needs
* Shows you how to build forms, use Visual Basic and the VBAEditor, automate query parameters, create functions andsubroutines, use XML to create data access pages, and more
* Includes a CD with all source code from the book and workingexamples, plus bonus shareware, freeware, trial, demo andevaluation programs that work with or enhance Microsoft Office
You'll want to keep this soup-to-nuts Access referenceclose at hand!
Note: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.

Autoren/Hrsg.

Groh, Michael R.

Inhaltsverzeichnis

Acknowledgments xxxiii
Introduction xxxv
Part I: Access Building Blocks 1
Chapter 1: An Introduction to Database Development 3
Chapter 2: Creating Access Tables 25
Chapter 3: Designing Bulletproof Databases 91
Chapter 4: Selecting Data with Queries 129
Chapter 5: Using Operators and Expressions in Access 171
Chapter 6: Working with Datasheet View 215
Chapter 7: Creating Basic Access Forms 251
Chapter 8: Working with Data on Access Forms 289
Chapter 9: Presenting Data with Access Reports 319
Part II: Programming Microsoft Access 375
Chapter 10: VBA Programming Fundamentals 377
Chapter 11: Mastering VBA Data Types and Procedures 417
Chapter 12: The Access Event Model 451
Chapter 13: Accessing Data with VBA Code 473
Chapter 14: Debugging Your Access Applications 523
Chapter 15: Using Access Data Macros 551
Part III: More-Advanced Access Techniques 577
Chapter 16: Working with External Data 579
Chapter 17: Importing and Exporting Data 609
Chapter 18: Advanced Access Query Techniques 637
Chapter 19: Advanced Access Form Techniques 679
Chapter 20: Advanced Access Report Techniques 709
Chapter 21: Building Multiuser Applications 751
Chapter 22: Integrating Access with Other Applications 789
Chapter 23: Handling Errors and Exceptions 819
Part IV: Professional Database Development 839
Chapter 24: Optimizing Access Applications 841
Chapter 25: Advanced Data Access with VBA 881
Chapter 26: Bulletproofing Access Applications 897
Chapter 27: Using the Windows Application Programming Interface939
Chapter 28: Object-Oriented Programming with VBA 969
Chapter 29: Customizing Access Ribbons 1009
Chapter 30: Using Access Macros 1049
Chapter 31: Distributing Access Applications 1083
Part V: Access and Windows SharePoint Services 1101
Chapter 32: Understanding Windows SharePoint Services 1103
Chapter 33: Integrating Access with SharePoint 1117
Chapter 34: Understanding Access Services 1135
Chapter 35: Deploying Access Applications to SharePoint 1145
Part VI: Access as an Enterprise Platform 1181
Chapter 36: Client/Server Concepts 1183
Chapter 37: SQL Server as an Access Companion 1199
Chapter 38: Upsizing Access Databases to SQL Server 1223
Part VII: Appendixes 1243
Appendix A: Access 2010 Specifications 1245
Appendix B: What's New in Access 2010 1253
Appendix C: What's on the CD-ROM 1267
Index 1271

Über Autor(innen)

Michael R. Groh is a well-known authority on Microsoft Access, having written or contributed to more than 20 books and over 200 articles on the topic. Mike has also spoken at dozens of Access conferences throughout the world.