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

Chapter 38. SharePoint as a Data Source

IN THIS CHAPTER

  • Considering SharePoint as a data source

  • Understanding SharePoint and Access interfaces

  • Using SharePoint data on Access forms

  • Displaying SharePoint data in Access reports

  • Using a SharePoint tracking application

  • Looking at SharePoint collaborative applications

  • Understanding Microsoft SharePoint Designer

Several of the previous chapters of this book have touched on different data sources for Access 2007. You've seen how Access 2007 supports importing, linking, and exporting data. Access 2007 has no equal when it comes to sharing data with other applications.

This chapter explains how to use Microsoft SharePoint as a data source for Access applications. Microsoft has taken great pains to ensure that Access and SharePoint interoperate seamlessly, providing Access developers with a rich source of data accessible from anywhere on the Internet.

SharePoint data are stored as lists. SharePoint lists can be exported from, and imported into, Access applications. SharePoint lists are available from any SharePoint site, sharing data across the Internet. In earlier chapters, you read about the SharePoint basics, about the services provided by SharePoint Services, and how various types of applications can be implemented using SharePoint. Additionally, you've read about how a SharePoint Web site and Access can integrate with each other. Linking to SharePoint lists make data stored on a SharePoint Web site appear as linked tables in Access.

Essentially, ...

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