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 with use our site collection url to open the page.

clip_image002

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

clip_image004

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

clip_image006

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.

clip_image008

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

clip_image010

Deleting a List

We might be requiring deleting an existing entire List. In this case do the following steps.

1. Open the List

2. Click the List ribbon menu item

clip_image012

3. Click List Settings

clip_image014

4. Use Delete this List link

clip_image016

Now the list will get 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 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.

clip_image018

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

clip_image020

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

clip_image022

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.

Leave a Reply

Your email address will not be published. Required fields are marked *