We have successfully finished over 520 projects in last 18 years.
ID : 27306847
Greetings,
We are interested to work on this project, please find my comments inline with yours,
1)Build a sales management system similar to MS Access NorthWind on mySQL
=>Ok, Do you want to separate backend database from Front-end Access database? Desktop database of how many users may want to use Application?
- What version of MS Access you want used ? Access 2013/2016 ? We can use MySQL as backend, what version of MySQL you want to use ?
2)Systems shall include:
Customer list
Product list
Sales order
Inventory
Delivery note form
PI form
invoice
Back order report
=>Ok, do you have your own designed database tables or you want to refer same designs of tables from NorthWind database and only you want to separate it from Front end? We can have MS Access ODBC DSN Less linked tables of MySQL.
Please confirm that MySQL is on the same server where you are going to run Microsoft Access. In such case you will get a good performance. Even if the MySQL is in Local Area Network(LAN), you can expect good performance. But for hosted internet server it slows down.
Waiting for Favorable Response
Regards,
[Sham Yemul]