Access 2007 Bible~tqw~ darksiderg

*******************************************************************************
Access 2007 Bible
*******************************************************************************

-------------------------------------------------------------------------------
General Information
-------------------------------------------------------------------------------
Type.................: Ebook
Part Size............: 73,311,322 bytes




-------------------------------------------------------------------------------
Post Information
-------------------------------------------------------------------------------
Posted by............: ~tqw~

-------------------------------------------------------------------------------
Release Notes
-------------------------------------------------------------------------------
Making the most of Access 2007 means mastering its built-in features, extending
them programmatically, and integrating your databases with your broader
environment. Access 2007 Bible covers all that and more. You could start as a
beginner, grow into an enterprise developer, and still find great value here.

The authors teach everything through an extensive example application that links
theory and technique with business problem solving. Using it, you learn all the
basics in nine chapters: from designing databases to navigating Access 2007's
revamped interface to creating reports.

The authors next turn to VBA, linking concepts to useful techniques such as
creating functions to calculate taxes. There's an up-to-the-minute section on
integration, from basic data import/export to leveraging SharePoint team sites.
You'll find practical insight into database optimization, bulletproofing,
security, distribution, even using Access alongside SQL Server. This isn't just
a tour of Access: It's a tour de force.

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.
Chapter27: 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.

Product Details

* ISBN: 0470046732
* ISBN-13: 9780470046739
* Format: Paperback, 1400pp
* Publisher: Wiley, John & Sons, Incorporated
* Pub. Date: January 2007

-------------------------------------------------------------------------------
Install Notes
-------------------------------------------------------------------------------
Adobe Acrobat Reader
-------------------------------------
~TQW~ darksiderg h33t