Where do I start?

[fattony]

I think I need to start with some tutorials if anyone has any links?

What Im trying to create is a stock management database, I need a table to hold product codes and their prices - we have a price for singular items but a discounted price if 10 or more are purchased.

I then need another table to hold product codes which are in stock, a form where I can input an order - the order form would consist of entering product codes and quantities, from this the total order value would need to be displayed.

I would then need to run a report which will analyse what is in stock against the orders placed and display what needs to be ordered in to fulfil the order.

So on a difficulty scale of 1 - 5 (5 = hardest) how easy is the above to achieve for a novice?

Thanks

 

[fattony]

Update

Just to update

I think I may have found a solution, I have downloaded this:

http ://office.microsoft. com/en-gb/templates/CL102529721.aspx?AxInstalled=1&c=0#ai:TC102483123|

(Note 2 x Spaces in link)

It seems to have everything I need but I cant seem to remove the sample data, are these templates just to show you what Access can do rather than let you use it?

 

[gemma-the-husky]

I have used this one

http://office.microsoft.com/en-us/t...ase-TC001018458.aspx?CTT=5&origin=HA001234159


this seems to be an updated version of the one I used - it's not bad at all - certainly better than starting from scratch


----
I think the one you referred to seems to be Northwind - which is a standard all purpose database that ships with Access. You should still be able to get at the tables, etc.

 

[SteveF]

The tutorials on the Microsoft site are good, they will get you started.