If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with design structure
i want to create a database for my makeup shop. I know i would have a table
for all the products but i want to also track customers who buys what product so that i can always inform them of new itmes. i want to now if i need just one table or i need more than than. my table will have fields for prices and total amount. this will be and invetory for the shop that should show what we have as orders and what is Purchase orders. |
#2
|
|||
|
|||
Help with design structure
Hi
Can I make a suggestion. If you go to the microft site you can download (free) databases that will just what you want. Much better than spending a long time createing a DB from the start - unless you want to spend some time learning DB creation You don't say what version of access you have so you could start your search from here http://office.microsoft.com/en-us/te...33.aspx?av=ZAC Good luck -- Wayne Manchester, England. "Amin" wrote: i want to create a database for my makeup shop. I know i would have a table for all the products but i want to also track customers who buys what product so that i can always inform them of new itmes. i want to now if i need just one table or i need more than than. my table will have fields for prices and total amount. this will be and invetory for the shop that should show what we have as orders and what is Purchase orders. |
#3
|
|||
|
|||
Help with design structure
On Thu, 29 Apr 2010 03:05:01 -0700, Amin
wrote: i want to create a database for my makeup shop. I know i would have a table for all the products but i want to also track customers who buys what product so that i can always inform them of new itmes. i want to now if i need just one table or i need more than than. my table will have fields for prices and total amount. this will be and invetory for the shop that should show what we have as orders and what is Purchase orders. You need at least four tables: 1. A table of Products, with current price, product name, other information about the product itself 2. A table of Customers, with a customerID, name, contact information 3. A table of Transactions, to keep track of your inventory: whenevery you buy more of a product you would record what ProductID, quantity purchased, etc. 4. A table of Sales, with ProductID, CustomerID, date sold, amount sold, etc. You may well need more. Wayne's suggestion of looking at Microsoft's "Point of Sale" templates is a good idea; you can find a lot more resources at Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html Roger Carlson's tutorials, samples and tips: http://www.rogersaccesslibrary.com/ A free tutorial written by Crystal: http://allenbrowne.com/casu-22.html A video how-to series by Crystal: http://www.YouTube.com/user/LearnAccessByCrystal MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|