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
|
|||
|
|||
Advice on setting up membership database
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 |
#2
|
|||
|
|||
Advice on setting up membership database
There is a memebership template in the gallery of databases at Microsoft.
You can find it he http://office.microsoft.com/en-us/te...s/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 -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Report based on rst in other database | swedbera | Setting Up & Running Reports | 5 | October 6th, 2005 11:41 AM |
Viescas membership database multiple member rates??? | tlyczko | Database Design | 7 | October 5th, 2005 10:48 PM |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
Access Error Message when opening database | eah | General Discussion | 3 | January 26th, 2005 10:04 AM |
Membership database | Graham | Database Design | 4 | December 15th, 2004 04:39 PM |