How can i make this database

[novice_programer]

Hello
I am new to MS Access and so to this forum, the reason for which i got interested in MS Access is that I wanted to make a database for a auto spare parts shop which could also work like total accounts management of the shop.



Now here is the scenario, my database would contain one main table with fields like Part ID, Name, Purchase Price, Sale Price, Stock Present, Min Stock, Location etc. Now on the other hand i want to maintain records of bill also, like say on a day a customer comes and buys some certain items, i want to save his purchase through saving his bill, further more no of item sold in bill should automatically subtracted from my "stock present" field of parts table. The bill should be save like if today i entertained ten customers there should be 10 bills saved in my database, and then each bill saved should have record of how many item purchased, quantity/price of each item, total amount etc.

Now as i am new to this, i have very little idea how to do this , kindly guide me how i can successful in my goal , thanks in advance.

[RayMilhon]

Check out Microsofts Northwind Database. That has a lot of the structure your looking for.

[RuralGuy]

If I were you I would also examine all of the Templates that come with Access as well as the tons on line at MS Office.

[novice_programer]

thanks i will look into northwind and see how it can help me.