If I create an MS Access database that has an interactive form, can I publish this form to Sharepoint. Everything that I read says that this is possible, but I cannot seem to figure it out.
I just started with a company that has about 60 people using excel workbooks. Each person has their own workbook that my department creates (60 times). Each week we take all 60 workbooks and compile it, get our results and create 60 more individual excel sheets. I can put everything in Access and do away with it all, but I would really like to put the Access form onto Sharepoint just like it was online form. (It's not just data entry, but also updating current records). Also, I do have the options of linking to a SQL Server, or a Sharepoint List as well.
How do I go about doing this?