Monday, 26 November 2012

SP 2013 Access services

I never thought I'd be able to say this about MS Access, but WOW!

Amongst some of the new features in SP2013, I'm really impressed by what MS have done in terms of bringing Access into SP2013.

Access tables = SQL tables, etc. Firstly when you bring access into SharePoint it will no longer be a standalone MDB file, the tables / queries and triggers are written to SQL, so you are now dealing with SQL triggers, tables and queries with a nice client side app that even business users understand and find easy to use.​

Business forms
I personally see the new integration replacing many of those custom lists we find scattered around team sites in collaboration environment. Why? because business has been using access for years - just think back to all your client engagements, personally I've come across loads of departments that rely heavily on access databases created by one of their staff members. Also, access forms are easy to work with and are easily tailored to individual and departmental needs.

BI potential
So now we're talking SQL tables as opposed to lists, this means reporting and ultimately BI can be simplified, manipulating SQL tables directly will make it easier to draw reports.

Access apps
Remember this is 2013, they're now referred to as access apps and no longer access databases, and they're dead simple to create too. From site contents simply click "add an app" and from the list of apps available select "Access app" and start designing.

MS have also provided a number of pre designed templates, which include the tables and some sample reports which you can go on to modify to your hearts content.

No comments:

Post a Comment