Advice on setting up membership database

[Pete]

I wish to set up a membership database that will keep details about my
members and the equipment we install for them. I also wish to keep
track of all items we have in stock and out in the field. When we
create a new member, I wish to be able to dedicate pieces of hardware
to him e.g

Fred Bloggs
Address
etc etc

Hardware used etc

Access Point WAP011A
8db Panel Antenna
2m SWA extension lead
Wireless Radio Card
Date installed

I also need to be able to manage the number of the number of above
items we have in stock, so need an inventory that increases with new
stock and decreases when installed

Can anyone start me off, or help me with the layout of the tables &
relationships

Peter

 

[Albert D.Kallal]

There is a memebership template in the gallery of databases at Microsoft.

You can find it here:

http://office.microsoft.com/en-us/templates/default.aspx

There is a whole bunch of templates in the above. There is a also a contact
management one also....


And, if you don't want to start with one of the MANY templates in the
above...then here is a bunhc of table desings

http://www.databaseanswers.com/data_models/index.htm