So I've decided to make the leap from Excel to Access. So much to learn, but in the long run it should be a better alternative. I keep bumping heads with myself in Excel as I expand the automation.
I have a small window business.
I have about 100 products, each one having up to 10 accessory options.
Each product's pricing is specific to a unique measurement (window size). Here is an example of something like what I have been using with Excel. The "rows" are priced from window sizes.
I'm plan on using irow and icol to find the coordinate value of the measurement to find my cost. Then calculating a mark up.
In regards to designing the database:
Am I better to break my products up into separate tables "Wood Windows" (QTY 25), "Vinyl Windows", (QTY 25), and "Aluminum Windows" (QTY 50)?
Also, the options of each window can be colors, gases, films, coatings, etc. Would I be best to include the options on the same product table?
My ultimate goal is to be able to compare pricing side by side and create a formal quote with different windows for different portions of the home or building.
Thank you to anyone who takes the time to read this and reply!