Datasheet

Book IV
Chapter 1
Publishing Access
Applications
619
to that SharePoint site, you’ll want to present your users with a form that
acts as the launching pad for your application. The form should contain nav-
igation components so your users can cruise easily from one form or report
to another.
Here’s how to set the default Web form that appears in your SharePoint site:
1. Using your browser, navigate to the SharePoint site that hosts your
Web database application.
2. From the title bar, click Options ➪ Open in Access.
A local copy (which is a fancy way of saying on your computer) of your
Web database application opens in Access 2010 ready for editing. Any
changes that you make won’t show up in SharePoint until you synchro-
nize the local copy back to SharePoint.
3. Click the File tab to present the Access Backstage View.
4. Click the Options command.
The Access Options dialog box appears.
5. Click Current Database.
The options for the current database appear.
6. In the Web Display Form drop-down list, select the form you want as
the default form when users navigate to the SharePoint site.
7. Click OK.
8. Save your changes.
The changes are saved to the local copy of the Web database application,
but won’t show up in SharePoint until your synchronize them back to
your SharePoint site.
9. Click the Info tab, and then click Sync All.
Your changes are synchronized back to your SharePoint site. If you
refresh the home page of the SharePoint site that hosts your Web
database application, the new default Web form displays.
Publishing to Access Services
Access 2007 provided the capability to publish your Access list into a
SharePoint list. Suddenly you could manage and control your data directly
from SharePoint’s browser interface. With Access 2010, you can use the inte-
gration features to publish your entire database application into SharePoint —
along with its associated forms, queries, and reports — as a SharePoint site.
Publishing to Access Services
31_587164-bk04ch01.indd 61931_587164-bk04ch01.indd 619 9/30/10 8:09 PM9/30/10 8:09 PM