Greetings All,
I have been assigned a new project to revamp our quality systems. In particular, I need to create a new QA database in Access. This really would need to be it's own application entirely.
I'm looking for help brainstorming how to best create it. I want to use Access. I have no prior experience designing an application or using Access to do so, but I know it's possible because I've used one that works well before.
So, for the access experts out there, how hard would it be to create an application in access that does the following:
- Allows a user to print a test sheet for a certain product. *Note - this will need to be linked to a specification table or something somewhere, so the appropriate tests for each part print.
- Allows a user to enter / input lot testing data for each manufacturing run
- Create certificates of analysis, which would then be generated in PDF format
How would you approach this?