Project Description:
Need a database designed to handle customers and orders. The database needs to be accessed from several different location. A couple of scripts also need to be written to update database with data in dropbox folder. Also order forms need to be designed to gather data. several reports need to be developed. I have attached an excel file with a more detailed description of the database and what is needed. Two web pages need to be developed where customers and search and see their order status. Generic bids without mentioning any specific aspect of the project will be ignored. I prefer microsoft access as i am managed access databases before. However, other solutions also considered if more suitable.
script 1 Desktop script creates folder and database table entry
script 2 After order form filled prints reports and created folder and text file in dropbox
script 3 autoruns every set amount of time. analysis dropbox. Creates text file and updates database table
Key features of database
1) Runs on computers in different locations. Updates over web. Full functionality needed on one computer. Other must have read access and create/edit forms
2) script 3 creates/edits database
3) all tables have easy to edit/add data for admin
4) several reports available and printable
