asked on

Using Access and SharePoint as employee activity analytics tool

I need to build an employee activity analytics tool fast, in a matter of 10 days. I was thinking about Access 2013 database and web app, combined to Sharepoint 2013 , to whom all employees register their activities through form, and certain employees should be able to run analysis, which means queries, reports, statistics, etc... However, whilst classic desktop Access is all good, i know not very much so about Sharepoint and Access web apps. I have no Sharepoint in my Office package, so I would like to know what to get and how much is it going to cost, there are around 40 employees whose activity i want to track and analyse. I have a local server, that I'd like to use.
So is this a good way to go? Even better way to be to go SQL database on server, and asp.NET web app, but that would take a lot more than 10 days to build. Plus, with Access I get to import a lot of data from Excel (time)sheets employees currently use to register their activity.

ASKER CERTIFIED SOLUTION

PatHartman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

_TAD_

10 days is a fairly quick turn around for learning a new product like Access Web app. Sure it's a lot like Access in many ways, but there are gotchas that you really need to be aware of before hand so you don't back yourself in a corner.

As PatHartman suggested - find another solution for the immediate task at hand, and then learn Access Web App when you are able. MS did a fantastic job of creating several Access Web App templates they provide for free. Using those templates I've built some very complex data entry solutions in SharePoint in as little as 1 or 2 hours (It's awesome -- but not recommended on a deadline until you know the product).

infoalex

You can use the standard SharePoint "Audit log reports"