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 ...