For Online Computer Support, Ask a Computer Technician
Hi there and welcome
For sure you will want to use Access for this. It handles record locking so multiple people can access and input / reference data, and it provides automatic ID creation so you can use ID references for records. It generates these automatically for you when setup to do so.
I would recommend looking at this guide to get you started
If you would like any additional information or assistance, please do not hesitate to let me know.
Else if you can take a second to rate my service by clicking one of the stars at the top of the screen then submit, that would be greatly appreciated.