VBA Coding For Inventory and POS

Hi Mr Excel

I’m doing a school project that requires quite some VBA programming. I understand you’re quite the expert on this. Could you teach me a thing or 2?

I need to do an inventory management prototype with VBA forms. Basically I have 3 forms. Pre inventory check before sales, sales and post sales inventory check. I know how to create the form but am not sure how to make the information load into a data base and update along the way.

Form 1 (4 controls)
Select item
Count number of items in inventory
hit submit
close button

Form 2 (7 controls)
select item
Label that shows the number of item selected left in stock
Label that shows price of item
Input for number of items to sell
Total price
Submit button
Close button

Note: Form should immediately update point 2 - label that shows the number of items left in stock

Form 3 (5 controls)
Select item
Count number of items in inventory
hit submit
close button
Label that shows discrepancies (e.g. missing stock after counting when sales from form 2 is less than difference of form1 and form2 count)

I uploaded the excel workbook below
http://http://www.mediafire.com/?cruhve2nu7llm2p