I currently have a fairly complex MS Access database that I use to track Issues, Returns and Sales of Magazines. I also use the database to forecast/project future supplies for each shop based on their history. Once forecasting is done for each magazine for each shop the data is amalgamated and an invoice created for each shop for all new supplies. Capturing of returned magazines is also entered into the database and a credit note generated. A text file is also generated for importing into our accounting software (Again the format is different in the various countries)
I also run a number of reports showing magazines credited, sales per title, sales per agent etc. The reports are printed on different printers and in different layouts in the various countries - I would like this facility to remain if possible.
I use the database in five different countries and have a few changes to each database to take into account different tax set-ups etc.
Whilst each country has different shops, we deliver the same magazines in each country as well as some magazines that are specific to only one country.
I would like a secure site that allows access to users by means of a username and password (which must be changed every 6 months at least). Also I need to be able to restrict users from different options on the site.
Whilst each country must be limited to their shops and data, I would like the option to compare data between countries if required. Also there must be the ability to add a new country to the database set-up in the future.
This is a very basic outline of what is required and I would like some educated guidance on what is and is not possible before I start. I would also like an idea of costs going forward for additional work in the future. A detailed requirement will be drawn up if all is possible.
Please also bear in mind that we are based in Africa and internet connections are on average around the 256Kb mark in some of the countries we are based in. I need to know if this will cause a problem to users. I will also need assurance that up to 15 users can work on the site concurrently without it slowing down or even crashing.
I have attached a blank copy of our current database for a brief idea of our current set-up. Lastly our current data (history) would have to be imported to the new web based database.
This is a long term project and time duration is not critical. I am prepared to work in stages over time to ensure everything is implemented gradually and properly if necessary. I am not looking for the best price but rather the best, and most informed, freelancer to work with long term.
I am more than willing to answer any questions and provide as much info as necessary.
68 freelancers are bidding on average $2391 for this job
We are experts in .NET and SQL DB and we can easily convert your Access db to SQL. We are into web based development since 2001 and We have been developing websites like [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view] More
We are expert in doing this sort of stuff... No upfront needed, all payments through GAF escrow.. Online 16 Hours a day, Can start right away.. Thanks
Hi, i am very interested to work on this project and can start immediately, please check pmb for the height of experience and quality of work. Regards, Tarun
Hi, We are a group of specialized asp.net, c#, sql server, xml, ajax, webservices,php,joomla, wordpress,mysql developer. Please check the PMB. Thanks Udal Kumar Bharti