I want to create a database using ms access. The data base is to help with creating and storing quality inspection reports for small manufacturing line. The line consists of few production cells and I am thinking of having a 3 quality gates. At each gate the technician is able to open the product file and enter the inspection findings. I want to be able to generate reports, daily, weekly and monthly as well as other reports such as quality per product type.
It is also important for us that the database can be access and used by multiple users at the same time. Do you think you can help? If so how much you think it could cost