Simple Database Required

  • Thread starter Thread starter Saxman
  • Start date Start date
S

Saxman

I have been asked to build a simple database of customer records. Below
are the fields required.

My problem always seems to be deciding how many tables I will require.
Salutation and Product will require separate tables as I intend them to
be drop-down lists.

What I need to consider is that a customer could have maybe five
different orders.

Do you think the data should all be contained within one table?

Also, what would be best to use as a primary key? Customer or Order
Number? The customer is unlikely to change except maybe their
salutation if they married/remarried. The order number is unique.

The emphasis is on customer records rather than orders.

Order Number
Salutation
First Name
Last Name
Address 1
Address 2
Town
County
Postcode
Telephone
Email Address
Order Date
Order Number
Product
Order Cost
Salesperson
Notes

TIA
 
The northwind database that ships with Access is an order database. I'd
recommend you take a look at it and see if it meets your needs. If so,
modify it as needed and you will be all set!
 
Rick said:
The northwind database that ships with Access is an order database. I'd
recommend you take a look at it and see if it meets your needs. If so,
modify it as needed and you will be all set!

I did think about that, but then it might take more time deleting stuff
and modifying tables than building it?
 
Back
Top