My ultimate goal is to create a Web based application to prevent me from having to answer my wifes constant question... "where is the?...".
So, I've developed the basics in an Access 2016 database, and it is far from finished, but it does basically prove the idea is functional.
I've developed this on my Windows 10 Pro desktop.
I also have a second Windows 10 Pro that I run purely as a "service resource system". What I mean by "service resource system" is it acts as a print server, so as you can imagine, its not the most powerful of devices, but it doesn't have to provide sub second response.
My current thoughts are that on this "service resource system" i'll install the free version of SQL Server, and migrate the Access Database onto SQL Server.
I will then develop the Web application using Visual Studio community, and deploy that to the "service resource system". I'm sure you will have spotted the use of "low cost/no cost" tools, which is how I'd prefer to continue.
We have iPad's around the house, and these will be the prime device(s) used to access the resulting Web interface.
The guidance I'm seeking is, am I heading the right direction?