Access 2007 Bible (Paperback)

Michael R. Groh, Joseph C. Stockman, Gavin Powell, Cary N. Prague, Michael R. Irwin, Jennifer Reardon

Access 2007 Bible (Paperback)
  • 出版商: Wiley
  • 出版日期: 2006-12-01
  • 售價: $2,340
  • 貴賓價: 9.5 折 $2,223
  • 語言: 英文
  • 頁數: 1416
  • 裝訂: Paperback
  • ISBN: 0470046732
  • ISBN-13: 9780470046739

    • 已絕版

買這商品的人也買了...

相關主題

商品描述

Description

"I recommend this book for anyone who wants a strong foundation in Access."
—Jeff Lenamon, CIBC World Markets

Updated edition with exciting new Access 2007 features!

Harness the power of Access 2007 with the expert guidance in this comprehensive reference. Beginners will appreciate the thorough attention to database fundamentals and terminology. Experienced users can jump right into Access 2007 enhancements like the all-new user interface and wider use of XML and Web services. Each of the book's six parts thoroughly focuses on key elements in a logical sequence, so you have what you need, when you need it. Designed as both a reference and a tutorial, Access 2007 Bible is a powerful tool for developers needing to make the most of the new features in Access 2007.

  • Build Access tables using good relational database techniques
  • Construct efficient databases using a five-step design method
  • Design efficient data-entry and data display forms
  • Utilize the improved Access report designer
  • Use Visual Basic(r) for Applications and the VBA Editor to automate applications
  • Build and customize Access 2007 ribbons
  • Seamlessly exchange Access data with SharePoint(r)
  • Employ advanced techniques such as the Windows(r) API and object-oriented programming
  • Add security and use data replication in your Access applications

What's on the CD-ROM?

Follow the examples in the book chapter by chapter using the bonus materials on the CD-ROM. You'll find separate Microsoft Access database files for each chapter and other working files, including

  • All the examples and databases used in the book, including database files, images, data files in various formats, and icon files 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 system requirements.

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

 

Table of Contents

Acknowledgments.

Foreword.

Part I: Access Building Blocks.

Chapter 1: An Introduction to Database Development.

Chapter 2: Creating Access Tables.

Chapter 3: Designing Bulletproof Databases.

Chapter 4: Selecting Data with Queries.

Chapter 5: Using Operators and Expressions in Access.

Chapter 6: Working with Datasheet View.

Chapter 7: Creating Basic Access Forms.

Chapter 8: Working with Data on Access Forms.

Chapter 9: Presenting Data with Access Reports.

Part II: Programming Microsoft Access.

Chapter 10: VBA Programming Fundamentals.

Chapter 11: Mastering VBA Data Types and Procedures.

Chapter 12: Understanding the Access Event Model.

Chapter 13: Using Expressions in Queries and VBA Code.

Chapter 14: Accessing Data with VBA Code.

Chapter 15: Using the VBA Debugging Tools.

Part III: More Advanced Access Techniques.

Chapter 16: Working with External Data.

Chapter 17: Importing and Exporting Data.

Chapter 18: Advanced Access Query Techniques.

Chapter 19: Advanced Access Form Techniques.

Chapter 20: Advanced Access Report Techniques.

Chapter 21: Building Multiuser Applications.

Chapter 22: Integrating Access with Other Applications.

Chapter 23: Integrating Access with SharePoint.

Chapter 24: Using ActiveX Controls.

Chapter 25: Handling Errors and Exceptions.

Part IV: Professional Database Development.

Chapter 26: Optimizing Access Applications.

Chapter 27: Advanced Data Access with VBA.

Chapter 28: Bulletproofing Access Applications.

Chapter 29: Securing Access Applications.

Chapter 30: Using the Windows API.

Chapter 31: Using the Access Replication Features.

Chapter 32: Object-Oriented Programming with VBA.

Chapter 33: Reusing VBA Code with Libraries.

Chapter 34: Customizing Access Ribbons.

Chapter 35: Distributing Access Applications.

Chapter 36: Using Access Macros.

Part V: Access as an Enterprise Platform.

Chapter 37: Using XML in Access 2007.

Chapter 38: SharePoint as a Data Source.

Chapter 39: Client/Server Concepts.

Chapter 40: SQL Server as an Access Companion.

Chapter 41: Upsizing Access Databases to SQL Server.

Part VI: Appendixes.

Appendix A: Access 2007 Specifications.

Appendix B: What’s on the CD-ROM.

Appendix C: What’s New in Access 2007.

Index.

Wiley Publishing, Inc. End-User License Agreement.

類似商品