Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access, and Word

6.4. Creating Access Forms and Reports from a SharePoint List

Once you bring your first list into Access, a natural question might be, "Can I create forms and reports from the list data?" The answer is yes.

Suppose you start with the Employees list. If you remember from earlier in this chapter, the Employees list uses two fields that define their values using items found in two other lists, the Depts and the Skills lists. Thus when you link the Employees SharePoint list to Access, it also links these two lists.

6.4.1. Creating a Simple Form

With the three employee-related tables linked into Access, you can generate a simple form for displaying and using just the data from the Employees table. The fastest way to create a new form for a single ...