access module stock management

we need an module for access, which will manage our stock. Every article which is input in an existing form must get automatically an number by the module. The stock is separated in different areas (by different categories). Every shelf in the stock will have an number. In this shelf can be stored an maximum amount of the category-arcticle. So there must be a database with the free shelf-number-place and and table with the maximum amount in this shelf for a special category. This must be done in access and the source-code must be ours.