I am hoping for some advice on how to begin creating an online database. I have some electronic publishing experience, but from the literature I have read, I have no real understanding of how to create a functional database. This project is for work. I am looking to create a database to which data from Access can be imported. The end result would be a searchable obituary index where users can search by name and find the date and page for obituaries printed in the local newspaper.
Ideally, the search page would allow the user to search by last name (possibly first name, though when the access database was created in the mid-1990s, the entire name was entered in the same cell.), as well as date.
Any advice would be helpful, including if there are any recommendations regarding software programs that would achieve the desired result.
In addition to how to get started, I was wondering about a few other things.
Should this be hosted on our in-house server or hosted remotely online? (Our website is hosted remotely)
How would I make this database secure?
What other issues may I run into?