O'Reilly logo

Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access, and Word by Michael P. Antonovich

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

6.6. Controlling Which Forms and Reports Are Available in SharePoint

Not only can you publish an Access database to SharePoint, but you can control which forms and reports SharePoint users can directly access. To illustrate this concept, let's begin by looking at the Northwind database.

Even if you have Office 2007 installed on your machine, you may not have the latest, greatest version of the Northwind database, the one specifically designed for Access 2007. However, Microsoft has made it easy to obtain and install it. Just follow these steps:

  1. Open Access.

  2. Click the Office Button. Then select Database Properties in the Manage section.

  3. From the Getting Started screen, select Sample in the From Microsoft Office Online section.

  4. Northwind 2007 should ...

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