We have a customer with a MS Access application that was designed for their camping ground and accommodation. The programmer now has no time to take it up a level to have web integration and online bookings. We would like to see the full Access Database turned into a web hosted LAMP solution.
There are three stages to this project.
Stage 1. Migrate the full system from Access to MySQL. Including Forms, reports, functionality etc.. Also taking all old data. Having this solution tested and then operational for their systems.
Stage 2. Provide a web bookings mechanism. Adding functionality to allow customers to book rooms directly. This would be down by creating "allotments" where a selection of rooms or sites could be selected as available for online bookings. The customer could then browse for dates and take these rooms, when payment / deposit is confirmed the room is removed from availability. Appropriate notifications, process etc... to go with this.
Stage 3. Develop an API or integrate with up to 3 other online booking systems to allow a 3rd party to communicate and take bookings or to publish rooms to other online booking systems.
We have access codes and installation for the whole system to get access to the full database and permission from the previous contractor to go ahead and get changes made (the system is owned in full by my client).
We are accepting quotes on Stage 1 only as a completed stage 1 should help to give enough idea of time to integrate web bookings.