I host 20 odd Wordpress based sites on a Rackspace Win 2012 web server.
One client wants to get employees to fill in a spreadsheet full of data (same data fields such as name & a score on several criteria). They then plan on copying & pasting said data into one master spreadsheet quarterly so that they can review the information & produce reports.
They discussed it with me & I suggested that they'd be better putting the information onto a database that all employees can update & then the managers will be able to view the reports in real-time.
I initially looked at Microsoft Access & have also played around with Zoho Creator.
I think that Access would do the job (I need to brush up my skills on the software!). The only problem is that they want to access it from remote locations such as from home, etc.
So, I've thought that the best thing to do would be to stick a web based access database on my web server that they can then access with usernames (which I believe can be done in MSAccess).
I've been doing some fiddling & it appears that I need to have Sharepoint running on my server for this to work. Is this correct & what are the license costs for this?