How to create a webpage from an MS Access 2007 Form

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?
LVL 11
aelliso3Asked:
Who is Participating?
 
Ted BouskillConnect With a Mentor Senior Software DeveloperCommented:
I disagree, the storage location is your biggest concern.  Because it dictates how you can get access to it.

Everything you described can be done in Sharepoint forms.  If you have the Enterprise version of MOSS you can use InfoPath which is built for custom forms.

Sharepoint Designer (which is now free) is very powerful and you can build very complex forms with it to interact with a SQL data source or a Sharepoint list.

Sharepoint lists are perfect for small data sets with simple relationships.  That's what we use it for.  We do use some external custom SQL databases but only when we have to for high end performance or if the data is very complex.
0
 
66866Commented:
What version of Sharepoint are you using? Is it WSS 3.0 or MOSS 2007?
0
 
aelliso3Author Commented:
MOSS 2007
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
Ted BouskillSenior Software DeveloperCommented:
0
 
aelliso3Author Commented:
Sharepoint list would be fine for storing the data and connecting to it, but I still need some type of form for the users to input or edit the data. This form will also need to display calculations, and other read-only data on it.
The data is not complex, and there's not a huge amount of it. I'd prefer to keep the data in SQL, but hat part is the least of my concerns right now.
0
 
aelliso3Author Commented:
Excellent ... Sharepoint designer was not something that I have seen before, but it is something that I am downloading now and will check into. This looks like it may be exactly what I need.  Thanks for your help
0
 
Ted BouskillSenior Software DeveloperCommented:
There is a learning curve with Sharepoint but trust me, it's worth it.  To give you an idea about what can be done with Sharepoint go to Microsoft's XBox site. www.xbox.com (It's ALL Sharepoint)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.