New to Access 2002 Question

[Odie]

Hi

My employer sent me to school to learn acess 2002, I have started fast track
classes at a technical institute, although I'm learning alot, I seem to be
learning everything except what I need in access to allow me to do my job.
Based on the sophisticated Posts i read here i can see that my knowledge of
access is rudementary at best, I'm basically in the early stages of learning
, hopefully I can ask an intelligent understandable question. Basically this
is what I'm trying to do. I work for a Respitory supply company which rents
out Cpap Machines, nebulizers ect, These Cpap machines have servicable Parts
which need to be replaced on a Regular basis. Theses Basic Servicable Parts
are 1. Masks, 2.Tubing 3 Filters 4 Nasal Pillows 5. Chinstraps. The Masks
are usually replaced every 6 months, filters 2months, pillows 2months. My
task is to design a Database or query that will Tell me For Each Patient
When these various parts need to be replaced. So if I set up a patient
let's say John Doe today 10/21/2004, I would need a Query that will tell me
when Each of the servicable items needs to be Replaced, so that I would know
when joe does gets new filters (every two months) masks (every six months
ect, ect,. So far I am in the early stages of designing my database, I
have a Patients table, and a simple form to input patient information. I
haven't had much time to study as I work full time. I would greatly
appreciate anyone that could help me or guide me to information that would
set me on track to achieving my goals . thanks

[Allen Browne]

Hi Odie

Well, you do have quite a task ahead! If you are learning Access as you go,
and doing this in spare time around other work, it could take 12 months or
more to get something workable together.

At the simplest level you need these tables:

tblEquipType = one record for each kind of equipment.

tblPart = one record for each part.

tblEquipTypePart = one record for each part in each EquipType. Fields:
EquipTypePartID primary key (PK)
EquipTypeID foreign key (FK) to tblEquipType
PartID FK to tblPart.PartID
Duration Number (number of months between replacements
of this part in this equipment type).

tblEquip = one record for each machine (instance of an EquipType). Fields:
EquipID PK
EquipTypeID FK to tblEquipType.EquipTypeID
AcquireDate Date (when the machine was purchased)

tblMaint one record for each time a part is maintained in an
Equip.
MaintID PK
EquipID FK to tblEquip.EquipID
PartID FK to tblPart.PartID
MaintDate Date (when this part was replaced)
With that structure, you can find the last time the particular part was
replaced in any piece of equipment, add the number of months that the part
lasts in that type of equipment, and you have the date when it is next due.
If the part has never been replaced, then add the number of months to the
acquisition date. Do not try to store the date when it needs to be done
again.

If you do need commerical help to get a result, many of us have done this
kind of work.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Odie" <oh******@sbcglobal.net> wrote in message
news:EW*****************@newssvr11.news.prodigy.co m...

My employer sent me to school to learn acess 2002, I have started fast
track
classes at a technical institute, although I'm learning alot, I seem to be
learning everything except what I need in access to allow me to do my job.
Based on the sophisticated Posts i read here i can see that my knowledge
of
access is rudementary at best, I'm basically in the early stages of
learning
, hopefully I can ask an intelligent understandable question. Basically
this
is what I'm trying to do. I work for a Respitory supply company which
rents
out Cpap Machines, nebulizers ect, These Cpap machines have servicable
Parts
which need to be replaced on a Regular basis. Theses Basic Servicable
Parts
are 1. Masks, 2.Tubing 3 Filters 4 Nasal Pillows 5. Chinstraps. The
Masks
are usually replaced every 6 months, filters 2months, pillows 2months. My
task is to design a Database or query that will Tell me For Each Patient
When these various parts need to be replaced. So if I set up a patient
let's say John Doe today 10/21/2004, I would need a Query that will tell
me
when Each of the servicable items needs to be Replaced, so that I would
know
when joe does gets new filters (every two months) masks (every six months
ect, ect,. So far I am in the early stages of designing my database, I
have a Patients table, and a simple form to input patient information. I
haven't had much time to study as I work full time. I would greatly
appreciate anyone that could help me or guide me to information that would
set me on track to achieving my goals . thanks