SharePoint 2010 - Using Lists


In this article we can focus on Lists in SharePoint. We can create multiple lists in SharePoint 2010. The limit can be configured through Central Administration.

For starting, use our site collection URL to open the page.

ShrLst1.gif

Creating a List

Now we can start by creating a List. As mentioned in the previous article a SharePoint List is a collection of items. We can specify columns as metadata for the List. We can create a List based on existing templates or from scratch.

Click on the Lists option from the left side and click the Create button. The following dialog box appears:

ShrLst2.gif

Choose one of the templates; for example Announcements. Enter the name for your list and Click the Create button. The new List will be created as shown below:

ShrLst3.gif

You can use the Items or List ribbons to add item, or modify the view.

Adding items to a List

Click on the Add new Announcement link from the List and you will get the following screen:

ShrLst4.gif

Enter the details for Announcement and click the Save button. Your new item will be displayed as below:

ShrLst5.gif

Deleting a List

We might be required to delete an existing entire List. In this case do the following steps.

  1. Open the List
  2. Click the List ribbon menu item

    ShrLst6.gif
     
  3. Click List Settings

    ShrLst7.gif
     
  4. Use Delete this List link

    ShrLst8.gif

Now the list will be deleted from the site.

Note: In a list there is always an ID column which is hidden. So while creating custom columns for the list, the name ID will be reserved. It is case-sensitive too.

Indexes on List

SharePoint allows us to manage large amounts of data. The data are actually be stored inside SQL Server database tables. So we can suggest the Indexing feature of tables to allow faster fetching of records. We can use the Indexed Columns feature of any List to provide indexing.

Click on the List Settings > Indexed Columns link to pen Indexed Columns page.

ShrLst9.gif

Use the Create a new Index in the upcoming page. Choose the column for indexing and click the Ok button to create the index.

ShrLst10.gif

Now the index will be successfully created and shown in the index details of List.

ShrLst11.gif

In real world scenarios indexes provide high leverage in data loading and manipulations.

References

http://office.microsoft.com/en-us/sharepoint-foundation-help/create-or-delete-a-list-HA010377306.aspx

Summary

In this article we have explored Lists and Indexes in SharePoint. The list provides an interface to store related entities and library provides document storage facility. There are many more templates to explore in the List section.