Answered by:
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
Thursday, December 3, 2015 6:07 PM
Answers
-
Hi Tahir,
If you're new to database designs, take a look at this page at UtterAccess: New Comer's Reading List
- Marked as answer by Tahir-Mehmood Friday, December 4, 2015 5:55 AM
Thursday, December 3, 2015 11:03 PM -
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
- Marked as answer by Tahir-Mehmood Friday, December 4, 2015 5:51 AM
Friday, December 4, 2015 1:15 AM -
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
- Marked as answer by Tahir-Mehmood Friday, December 4, 2015 5:51 AM
Friday, December 4, 2015 2:17 AM
All replies
-
Hi Tahir,
If you're new to database designs, take a look at this page at UtterAccess: New Comer's Reading List
- Marked as answer by Tahir-Mehmood Friday, December 4, 2015 5:55 AM
Thursday, December 3, 2015 11:03 PM -
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
Friday, December 4, 2015 12:20 AM -
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
- Marked as answer by Tahir-Mehmood Friday, December 4, 2015 5:51 AM
Friday, December 4, 2015 1:15 AM -
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
- Marked as answer by Tahir-Mehmood Friday, December 4, 2015 5:51 AM
Friday, December 4, 2015 2:17 AM