I need to develop a smartphone based app to gather data (using GUI with pull-downs, checkboxes, free-form entry), photos and GPS location. (Probably Android but open to iOS.) The data and photos need to be uploaded over the internet to a database on a server. The server will then be accessed using a web-browser interface by researchers. This all needs to be fairly secure with individual login accounts.
My proficiencies lie in data modeling, SQL Server and Microsoft Access database application development using VBA. I am looking for advise on a good approach for building this system, taking into account that I will need to learn the necessary programming language(s) fairly quickly. I would consider using a development environment like Iron Speed -- but not sure if a browser-based solution will give me the control I need of the camera.
I would appreciate any thoughts or guidance and would be particularly interested in links to examples or instructions that could move me along. Thanks!