making an asset Register/ stock taking database

hello everyone. i am a store keeper, taking care all IT equipments. i need help. i want to make a database where i can capture the name of the asset, the model number, the serial number and how many assets i have in the store room. as the assets are given to the customers the database should subtract.

May you kindly help me with the code to support these needs. I want to insert the information in the excel database using a form.


for example:

asset Name asset Number Asset model asset Serial Number taken by date total left

Hi and welcome to the board
Have a look at this page