Excel to Access

[JayX]

I am trying to build an inventory control system for a small local business. What I have done is built an excel spreadsheet which looks like so...

Column A: Product ID, Column B: Product Description, Column C: Inventory Shipment (Command buttons), Column D: Inventory Received (command buttons), Column E: Inventory Taken (command buttons), and column
F: Quantity on hand

So column C: are command buttons of all the inventory in the warehouse. Lets say I click on the command button 'soap' located in Column C, Row 2 which I then have a text box message that says enter a number, which I then do and it puts the number I type in into Column F, row 2 which is what I want.

Then in column D i have a command button which will increment by 1 to the quantity on hand to the appropriate cell and in column E it will decrease by 1 if the button is clicked into the appropriate cell.



So with all that being said can something like this be done in Microsoft access and how, due to the fact i am unfamiliar with access.

[June7]

You need to get an understanding of the difference between a spreadsheet and a relational database, which is what Access is.

What you describe can be done with Access. However, ideally, in a relational database, you would not maintain aggregate totals. You would enter transactions into tables that document incoming and outgoing inventory. Then queries would manipulate the records to summarize net balance.

You might want to examine some Access inventory database templates and see if any will meet your needs or can be adapted.