How to desing a database

A

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.
 
W

Wayne-I-M

Hi Amin

Have a look at the answer I gave to this question in the General Questions
section
 
D

Dorian

I would look for some prebuilt software. Unless you are familiar with
database development you cannot appreciate the complexity of this task or how
long it will take to build.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with design structure 2
Fill in multiple fields with one lookup 0
Can I use just one database to track both inventory AND cust. orde 3
updating data from one table to insert into a scond table 6
A complicate database 1
Access Inventory Calculation 0
MS ACCESS INVENTORY CALCULATION 0
query for one product only 4

Top