Microsoft Office Outlook is the application of choice for many people to manage their mail, contacts, tasks, calendars and more. You can connect your SharePoint lists and libraries with Outlook and work directly from that environment. All of your data is synced back into SharePoint as you make changes to it in Outlook (and vice versa). You can also use Outlook to take your documents offline, and synchronize them back as needed.

SharePoint sites, lists and libraries can also be viewed through a mobile device. The mobile enabled functionality is demonstrated in this video.

Access 2007 is a very robust client application. However, at times it is better to move your data from Access to SharePoint so anyone can browse to it easily using just a web browser. This video shows how you can make that happen by transferring an Access 2007 table directly as a SharePoint List.

Create Custom Lists in SharePoint if you want to create a list from scratch. Define your own custom columns and the type of data that you wish to store in each column

With the release of SharePoint 2007, the two way sync functionality between Excel and SharePoint lists was taken away. Now, with an Add-On developed by Microsoft, you can once again synchronize SharePoint lists with Excel spreadsheets.

This video shows you exactly how to obtain the add-on, install it and then use it in your environment.

Copying/Moving/Backing up lists. With or without data

Implement Surveys within any SharePoint. You will also see how to use branching logic within the surveys

RSS (Real Simple Syndication) is very prevalant throughout SharePoint. Learn how to use RSS in SharePoint lists and libraries

Use Site Columns in SharePoint to create list column templates

Learn how to create columns and add data to the custom list