O'Reilly logo

Access™ 2007 Bible by Gavin Powell, Joseph C. Stockman, Jennifer Reardon, Michael R. Groh, Michael R. Irwin, Cary N. Prague

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Part V. Access as an Enterprise Platform

IN THIS PART

Access continues to grow as an integral part of enterprise data management. Important capabilities have been added with each new release of Microsoft Access. Even though Access is not a strong tool for creating or driving Web sites, Access 2007 includes outstanding capabilities for integrating with data sources located anywhere on the Internet.

This part begins by examining extensible markup language (XML), the lingua franca of Internet data sharing. XML is a native data format recognized and used by Access 2007, and all communication with SharePoint is through XML exchange.

The most significant of these new capabilities is integration with Microsoft SharePoint Services. Access 2007 seamlessly integrates with SharePoint, using SharePoint Lists as linked tables. This means that your Access 2007 applications can share data with SharePoint users anywhere in the world. SharePoint data linked to Access databases is completely updatable and can be displayed on Access forms and reports.

Access is able to share data with SQL Server, Oracle, and other enterprise database engines. For obvious reasons, Access works best with Microsoft SQL Server, and we cover this topic in the following chapters. You'll learn how to extract static data from a SQL ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required