Noob seeking help with Database [Access]

I'm fairly new at access and I have no clue how to handle this situation. I dont even know where to start so any help would be greatly appreciated.

So I have to design this data base that has items such as "audio board X.xx" When a customer orders lets say "audio board 2.4", the database will know that the board requires 2x4K Resisters and 4x2uf Capacitors and 2X440开发者_JS百科1 BJTs. And it would automatically pull them from the inventory when processing this order so later on I can just look at the inventory list lets say at the end of the week and will know what parts i would need to order to restock.

now, i looked for help online, the only thing i could find similar was something called "Bill of Materials" AKA "BOM" sheets or something... but none of them told me how to make one or anything like that.

I'm really new at this, and am a total noob. I'm using Access 2010. Any Help would be appreciated.

---

First, read http://r937.com/relational.html

You will need a design on the lines of:

Parts
ID -->Primary key
Description
Etc

Components
ID -->Primary key
Description
Etc

PartsComponents --> Junction table
PartID ---) ??
ComponentID ---)

If a part can have only one of each component, life is simple enough and PartID + ComponentID is your primary key, if a part can only have a set number of a particular component, it may be possible to treat the set as a single item, if the part can have a variable number of a component, things get a little more complicated. A quantity field in the junction table would probably work, though.

You then have a fairly standard set of tables for customers and orders, including an order detail table, which gets updated by an append query from the junction table information when a customer selects a part.