Hello Gurus,
I need some help in designing a database for one of my applications. I am used to programming in Excel but never worked in combination with Access. And I am quite new to Database Designing process.
This is made for a small company which is into inventory management. They have products that are stored in the inventory. Before storing they got to do certain tasks (checking various things on the products, packing etc.,)
I prepared an excel application which has a status page to retrieve information about each Packing that is received. When PR Number is entered it retreives rest of the information. The page has the following displayed:
PR Number:
Product in the packing:
Company:
Barcode Number:
Checklist
Tasks Status Date/Time Person
Task-1
Task-2
Task-3
Task-4
Task-5
Comments:
Each of the task is a separate module with its own requirements and checks. For e.g. Task-1 has the queries about packing. Is the packing good? If bad what is the problem? Send an email to the person responsible.... etc. All the tasks should be reflected specific to the PR Number.
There might be atleast 5 more columns in each task.
How should I design an Access Database for this type of application? Should I work on a flat database, with all the information put in ONE table? Or should I opt to create multiple tables?
It would be a great help, if you can guide me through this stage.
Thanks in advance,
Regards,
RK.