I have to build a database now for my sister, and need (obviously-cause I keep trying and not doing it correctly for a few weeks now) to learn quickly how to do it.
Do you have a suggestion for the best way to learn fast for a fast learner who needs to start at the beginning but has already read a few "How to" books and obviously still does not see how to build a database with these elements:
1. The Vending Company staff members, (about 20) (this is my sister's place of employment)
2. The Vending Company staff members connected to their roles (4: PM, Inside sales, outside sales, engineers, and contact information assigned to the different clients and different client facilities (multiple company staff/roles assigned to client and/or facility)
3. The Client Companies/Org's (contact info) about 600 of them (some private companies, some government)
4. The Client Companies/Orgs' facilities - name and location (some client companies/orgs have only one location, some have main offices and facilities, of those with different locations, some have key staff unique to each facility, some have one set of purchasing/engineer staff for all facilities)
5. The client companies' staff members (2 to 6 for each company) and contact info including two phone numbers and an e-mail address
6. The client companies' staff members' roles (4: buyers, engineers, procurement managers, QAs) and their contact information (usually several per client and client facility, someitmes same for client and facility, sometimes unique groups for each facility)
7, A lessons learned long text field for passing along lessons learned for each client and or client facility
It will be used by people in the vending company to
1. Look up people in the vending company and in the client companies (salespersons, buyers, PMs, QAs, engineers, etc.) and how to contact them for each client/facility, as in ...
Record, store, and retrieve all the contact info for all staff related to certain clients and client facilities (in house and client staff, main offices and facilities)
(such as "I need a quick way to see all the buyers for Client A and all the phone numbers to reach them" or "I need to quickly see which in house engineer handles that client" or "I need a quick way to get the names and e-mails for all the in house salespeople and client buyers for Client A" or "I need to see and print out all the clients and fcailities that salesperson A handles" ...."I need all buyers in Canada and their contact info/client company name" these might be quick looks or for printouts...
3. Record, store, and retrieve all lessons learned for one certain client or groups of clients...or all lessons learned.....for quick review...and for training handouts..
I am not being paid. I offered to do it for my sister because she needs it, was "assigned" it as an "extra curricular PD endeavor"...but has no time to learn to do it, works 70 hours a week just trying to hold onto her job till retirement (I am already retired) and I owe her big time and I thought I could do it.
(she seriously gave up her life years ago to move interstate and take two jobs to support me and nurse me back from a near death crash and paralysis)
Any help appreciated.
Synthia