Forum Discussion
How to create Microsoft Access web app?
Thank you so much for your reply. I appreciate your support. I am not a computer specialist but a school leader. I run my independent school and would like to add some IT systems to it.
Basically, what I want to do is to create a database that would have all data (Student Information/Management System), (Staff Management System), Client Information, etc...) All on the same database so that we can work with all data from one place. Also to be able to assign roles and permissions to who can access/change what.
If changes/access can be made online then my team from their remote locations can work on the systems. Also, if those systems can be put on a website, then even clients can add their information, requests etc..
I apologize for the long message. I hope you understand my situation and guide me on how I can do this.
Thanks.
Given the fact that this relational database application is intended for external use, as well as internal use, Access is a non-starter as a stand-alone solution. You can't expect your clients to use Access.
That said, there is room for a hybrid solution, IMO, with an in-house Access FE through which you can manage administrative tasks, create reports and similar functions using the same remote data source as the one driving your website.
Having implemented such a solution 12 or 12 years ago for a major University, I can say with confidence that a well-designed relational database solution combining the strengths of a desk-top Access interface and a web-browser interface can make for a strong solution.Again, though, the fact that your clients will judge the competence of the school on their experience means to me that this is not a suitable "first-time in Access" project.
- George
I fully agree, to a point. As you said, for internal purposes the hybrid solution can be an excellent solution. But because he mentioned clients as well, I pushed Access aside.
That said, this could be a 2 pronged solution, hybrid for internal and once that is working smoothly, then look towards building a web solution. As long as the specs for the project are at properly from the start then this could be very doable.- Thank you Daniel, I am looking for a programmer to work on this project. Thank you so much for your support. I am also looking at filemaker pro. Have you used it?
- Thank you so much for your message. Looking at the amount of work needed, I am trying to see if I can find someone to do it professionally. I was wondering if you have recommendations for any good programmers etc.. and the kind of cost involved in such a project?
