Lists and Libraries
Almost everything in a SharePoint site exists within either a list or a library. A library is a specialized type of list that includes more support for documents. You can think of lists and libraries as conceptually similar to database tables in that they consist of fields and are often rectangular. However, a given list might support more than one type of content and be jagged, or it might include folders and represent a hierarchy. In this respect, a list is very unlike a database table.
Furthermore, a list’s template not only defines the data that the list can store, but also how that data is presented, the forms used to view and edit an item, and event handlers that act on the data. In many respects a given list template is an application unto itself.
Lists support multiple views of data by allowing you to choose which columns display, the column order, the sort order of rows, groupings, and filters. They also support a variety of view styles including:
A standard view
A datasheet view for use when editing many items
A calendar view that supports views at the month, week, and day level based on date time columns
A Gantt view that provides a view of tasks over time
An Access view
The Access view displays on the Create View page but is not really a view at all, though it is a way to visualize and use list items. When you choose this view, a wizard interface opens that lets you choose how the list information will appear in Access. The wizard offers options for a couple of form types, a datasheet, a pivot table, and a report. The wizard generates the Access objects based on your choices and creates a connection to the list.