Training
Certifications
Books
Special Offers
Community




 
Microsoft® FrontPage® Version 2002 Inside Out
Author Jim Buyens
Pages 1264
Disk 1 Companion CD(s)
Level Int/Adv
Published 05/02/2001
ISBN 9780735612846
Price $44.99
To see this book's discounted price, select a reseller below.
 

More Information

About the Book
Table of Contents
Sample Chapter
Index
Related Series
Related Books
About the Author

Support: Book & CD

Rate this book
Barnes Noble Amazon Quantum Books

 


Chapter 35: Using SharePoint Team Web Sites continued


Using Lists

Click the Lists link on the menu bar of any page in a SharePoint team Web site to display the Lists page shown in Figure 35-15. This is basically a list of all the lists in the current team Web site. All five lists itemized in the figure appear by default in any new team Web site.

Click to view graphic
Click to view graphic

Figure 35-15.  This page identifies the lists in a SharePoint team Web site. The lists shown here appear by default in every new team Web site.

Physically, a list is nothing more than a table in a database. Each list item is a table row and, as you’ve probably guessed, each list column is a table column. The SharePoint team Web site can create new tables (that is, lists), add columns, modify columns, and delete columns using Web pages that are part of (and integrated with) the team Web site.

Click the entry for any list in the List page to display a List View page like the one shown in Figure 35-16. The links on this page work much like those already described for document libraries and discussion boards (are you noticing a pattern?), but here’s a brief summary:

  • Select A View. Click any link in this area to display the list in the format you want.
  • New Item. Click this link to display a page named New Item Form that adds a new item to the list.
  • Filter. Click this link to limit the displayed messages based on criteria you specify.
  • Export. Click this link to download a Microsoft Excel Web Query file that downloads the data in the list. Such files have a .iqy filename extension that’s normally associated with Microsoft Excel. When you open such a file, Excel connects to the SharePoint team Web site database and downloads the data for the list you requested.
  • This is a highly useful approach because every time you open the Web Query file, Excel connects to the database server and downloads a fresh copy of the data in the list. This saves you from downloading fresh copies of the data manually. If you want to save a copy of the data as of some specific point in time, copy it from the query region and paste it into another spreadsheet.

    Click to view graphic
    Click to view graphic

    Figure 35-16.  Click a list name or icon in a List page (Figure 35-15) to display the items in the list.

  • Subscribe. Click this link if you want to receive e-mail notification whenever someone changes the contents of the list.
  • Modify Settings And Columns. Click this link to change the properties of the list. This includes the name, description, columns, views, and other settings.

The five lists shown in Figure 35-15 all contain different combinations of fields and different views. Nevertheless, they’re all simple database tables that operate using the same basic principles.


Previous   |  Table of Contents   |   Next




Top of Page


Last Updated: Saturday, July 7, 2001