Database Question...Help!

[Styles]

Hi,
I'm currently writing a simple database, as my first step into the wonderful world of Microsoft Access. I know most other programs well but think I should learn more of databases.

I've all my tables sorted but am a little unsure of how to make calculations. For example I have an input form and want to be able to select a product and a quantity, but I'm unsure of where to put this data? Do I create a seperate table with the product details in?

And also once I have these in the database, how would I work out a total value when the quantity varies? So if I wanted 3xproduct A, how would it work this out as a value?

I hope that makes sense!

Thanks for any help i've been trying to work my way around this but I can't seem to do it.

 

[Styles]

Excellent this does help. I'm just trying to sort out the relashionships between the tables at the moment which is very difficult! If there is anyone I could e-mail off the forums that would be willing to help me that would be excellent because I find this very difficult.

Thanks

s7yl3s