SharePoint and Access


show more SharePoint and Access provides you with in-depth training on IT. Taught by Simon Allardice as part of the SharePoint 2010 Essential Training show less
please wait ...

SharePoint and Access

If you are someone who lives and breathes working with Microsoft Access, you might like the ability of lists in SharePoint to be opened using Access. Like connecting any list or library to Word, Excel or Outlook, we are going to drive most of this from the list section off the Ribbon. And if you notice that we've seen things already like Connect to Outlook. We could export these details to Excel and just make a little spreadsheet of them, but I am going to select this one, which is Open with Access. Notice the words there.

When you say Connect to Outlook, it suggests a synchronization, which it is. When you say Export to Excel, it's kind of a one-way push, which it is. Open with Access is a little bit in between. So what's it doing? Well, first off, Access needs a local database, so it's asking you now to create a database that it's going to store the information in. I am just going to accept the default, but notice below it it's asking, would you like this databa...

SharePoint and Access
Video duration: 2m 58s 6h 58m Beginner

Viewers:

SharePoint and Access provides you with in-depth training on IT. Taught by Simon Allardice as part of the SharePoint 2010 Essential Training

Subject:
IT
Software:
SharePoint
Author:
please wait ...