You have chosen to sponsor your bid up to a maximum amount of .
I need an Inventory and Customer Sales database in MS Access. I only have Access 2000 so need it to be edited by me on Access 2000, and work on newer versions when I get it.
I buy raw products, then manufacture and sell a finished fashion product. I need a database to enable tracking and inventory control, including customers.
I want the raw products to be moved into completed products when I have made it, and the stock levels to adjust accordingly. I have an excel spreadsheet listing with many of the things I want to have included as elements of the tables.
Each product can be made of many other raw products. eg. White Fabric + Gold Wire + Gold Felt = Flower Shirt I will be very specific so you wont need to guess what is to be included :)
I can populate the database, but need you to create the tables and relationships.
The basic Inventory Template available for free from microsoft is fine to use, and then modify with some extra tables and fields. This means it wouldn't take as long as if you had to start from scratch.
Over time, I want to have you add extra parts to the database, but I will always be doing the data entry.