We have a third party scheduling/appointment application that uses MS access as its database. The application lacks some functionality and isn’t web based.
For instance we would like to allow employees to login to a website and check their schedules remotely. I have done some basic quires and reporting in this database so it should be fairly simple to create the correct quires and display the results in some basic format.
Requirements:
• The orginal database can only be read from. No writing to the database.
• The web based form would allow a user to select a staff member and a certain date range (current date or in the future, not past dates) and display the schedule.
• This webpage should be compatible with any browser or smartphone.
• The webserver must be able to run on Windows XP
Please let me know if you have any questions or if you need any more information. I will take a backup of the existing database (about 20 MB compressed) and sterilize some of the data. That will be provided for you to use as your dataset. I will also provide what the schedules look like in the 3rdparty software. We can also do a remote demo of the 3rd party application if necessary.