This is my first time working with Access, and I'm finding it a little more difficult than I expected. I’m not sure what the best way is to organize these tables or even how many tables I want to make. I work for a company that sells goods to retailers, and this database is to keep track of special promotions (like 10% off for Father’s Day, for example).
I’m thinking of creating 3 tables- one “Customer” (ie, Wal-Mart, Meijer, etc), one “Promotion” (including event name, start and end dates, estimated cost, etc), and one for “Product” (including product line and model, retail price, promotional price, etc). However, the price of each product and the specifics of each promotion vary customer by customer- a promotion that lasts a week with Meijer might last two weeks with Wal-Mart. Is there any way I can organize this database so that my promotional and product data can change with each customer?
Any help you guys can offer will be much appreciated… I’ve been banging my head against this problem for a full day now and I’m getting sick of it.
I’m thinking of creating 3 tables- one “Customer” (ie, Wal-Mart, Meijer, etc), one “Promotion” (including event name, start and end dates, estimated cost, etc), and one for “Product” (including product line and model, retail price, promotional price, etc). However, the price of each product and the specifics of each promotion vary customer by customer- a promotion that lasts a week with Meijer might last two weeks with Wal-Mart. Is there any way I can organize this database so that my promotional and product data can change with each customer?
Any help you guys can offer will be much appreciated… I’ve been banging my head against this problem for a full day now and I’m getting sick of it.