Well to get started I should inform you that I do not have any experience with Microsoft Access at all and I may be jumping into the deep end here a little bit.
However I have been reading tutorials and guides all day about how to navigate and use the software and I'm somewhat confident I can find my way around, at least for what I need to accomplish.
So I work in a candle and home decor store and I need to organize all the items and their prices in a database. I attempt to sketch out a rough draft of how I should lay everything out, but I am still unsure as to how I should organize this, and perhaps this is not the right place to be asking this question. If so, please kindly tell me and dismiss this question all together, guidance to the appropriate forum would be greatly appreciated though.
Here's what I've got:
We have lines of candles that have multiple styles and sizes all with different prices.
an example of a line would be:
>Root
->Pillars
-->Grecian
--->3in diameter
---->3in tall
---->6in tall
---->9in tall
-->Timberline
--->3in diameter
---->3in tall
---->6in tall
---->9in tall
--->4in diameter
---->4in tall
---->6in tall
---->9in tall
-->Smooth
--->2in diameter
---->3in tall
---->6in tall
---->9in tall
->Collenettes
-->Grecian
-->Timberline
... so on and so forth
and then more lines all with respective sub categories
>Candles in the Wind
>Beeswax
>etc.
So my question here is: What should my tables be titled and where should my relationships be?
Should I have a table for each line and list every item with the sizes listed as fields? Or should I make a table for the subcategories (Timberline and Grecian, for example) and have a general table with a relation connecting them to specific records?
I'm sure my questions are very broad and I'm likely asking for too much. But any suggestions would be very much appreciated.
Thank you in advance.