Access^TM 2007 Bible

by Michael R. Groh; Joseph C. Stockman; Gavin Powell; Cary N. Prague (Database Creations, Inc. ); Michael R. Irwin; Jennifer Reardon (Advanced Software Concepts )

• ISBN13: 9780470121399
• ISBN10: 0470121394
• Format: eBook
• Copyright: 2007-04-01
• Publisher: Wiley

Summary

"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

Access Building Blocks

An Introduction to Database Development

Creating Access Tables

Designing Bulletproof Databases

Selecting Data with Queries

Using Operators and Expressions in Access

Working with Datasheet View

Creating Basic Access Forms

Working with Data on Access Forms

Presenting Data with Access Reports

Programming Microsoft Access

VBA Programming Fundamentals

Mastering VBA Data Types and Procedures

Understanding the Access Event Model

Using Expressions in Queries and VBA Code

Accessing Data with VBA Code

Using the VBA Debugging Tools

More Advanced Access Techniques

Working with External Data

Importing and Exporting Data

Advanced Access Query Techniques

Advanced Access Form Techniques

Advanced Access Report Techniques

Building Multiuser Applications

Integrating Access with Other Applications

Integrating Access with SharePoint

Using ActiveX Controls

Handling Errors and Exceptions

Professional Database Development

Optimizing Access Applications

Advanced Data Access with VBA

Bulletproofing Access Applications

Securing Access Applications

Using the Windows API

Using the Access Replication Features

Object -Oriented Programming with VBA

Reusing VBA Code with Libraries

Customizing Access Ribbons

Distributing Access Applications

Using Access Macros

Access as an Enterprise Platform

Using XML in Access 2007

SharePoint as a Data Source

Client /Server Concepts

SQL Server as an Access Companion

Upsizing Access Databases to SQL Server

Appendixes

Access 2007 Specifications

What's on the CD-ROM

What's New in Access 2007

Index

Wiley Publishing, Inc.

End-User License Agreement

Table of Contents provided by Publisher. All Rights Reserved.