Help with design structure

[Amin]

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.

 

[Wayne-I-M]

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/templates/CT101527321033.aspx?av=ZAC

Good luck

 

[John W. Vinson]

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/accessjunkie/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