database structure

Question

Dear Members,

i am working in a railway contractor company, we contract with govt for repairing , overhauling the Locomotives. for this we import locomotive spare parts. i want to make a database in Access 2013 which keeps all the record of our purchases , in case we need the record for a specific part number , we can find that this part number when we bought, where we bought , how much we bought...etc. before all this i did in excel but i heard that access is more professional for this work , so l learned the access. kindly help me for 2 things........what fields i should add in table and what key i should select....

Thanks a lot

---

Tahir Mehmood

Answer 1

Hi Tahir,

If you're new to database designs, take a look at this page at UtterAccess: New Comer's Reading List

Answer 2

Will you be tracking individual part from manufacture to installation on the locomotive?   Will that include who installed, tested (Torque- which wrench and calibration date), and inspected?

---

Build a little, test a little

Answer 3

Dear Karl Dewey,

Thanks for your reply and interest in my question......

actually i am working in head office purchase department, and my job is, the inquiry i receive from the projects managers ( we have 4 locomotive repairing centers in different cities ), i get the confirmation from CEO and send inquiry to two  three different manufacturers , which offers is confirmed by CEO i import that one and sent to main warehouse then from warehouse they are sen to related project. mostly we buy from OEM and don't face any disparity but some cases it happens, and our engineering section in head office sent these parts to testing laboratory and with those tests reports we correspond to the Seller.

Best Regards

---

Tahir Mehmood

Answer 4

The reason I asked is that some Government contracts require 'full traceability' including product material batch information through failure analysis.

For instance on the torque wrench calibration, if when it goes in for re-calibration it is out of tolerance then it is unknown when it went out.  So all items that it was used on since the last time it was calibrated must be retested.

---

Build a little, test a little