Sharing an Access database with Access Services


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

Sharing an Access database with Access Services

With Access Services in SharePoint 2010, you can create a database in Microsoft Access 2010 and publish it up into SharePoint. It will take your Access tables and turn them into SharePoint lists. It will take your Access macros and turn them into workflows. The best way to do it is to start off with a new Access database called a blank web database. If you have an existing Access database, you still can publish that up into SharePoint, but you might have to remove a few things that are incompatible.

So, I'm going to create a blank web database. I am going to call it Purchases and Create. It takes me into Access into my first table. So, I'm going to define a few entries here. I'll say the first one is a text field called Product Name. The next one is Currency for Price. The next one I'll say is a text field for Serial Number, and the next one is a Yes/No for whether it's activated.

I'll save this and just save it as Purchases. Well, I could directly enter information int...

Sharing an Access database with Access Services
Video duration: 7m 19s 6h 58m Beginner

Viewers:

Sharing an Access database with Access Services 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 ...