Re: Datebase needed for tracking of drugs for a fire department!
- From: Fred <Fred@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 24 Jun 2008 07:49:01 -0700
There ought to be a different (simple) place to go for people who decide that
they want to pay for help, knowing that they want to get a lot more help than
just a question answered. Maybe with the impramateur or vetting of having
some type of criteria for the providers. Some people really need that. Is
there such a place?
That would meet that need without polluting the concept of this for a free
forum.
"Pete D." wrote:
Steve is what is called in newsgroups as a troll trying to get money for.
what others believe should be provided free. Yes, if you could develop it
in Excel then Access is a good expansion of your skills. Hardest part is to
change how you view the data. Excel makes you think in math calculations.
In access you can save yourself a lot of time with table relationships. For
instance you no longer would create a new line for each drug of the same
type. Instead you create a table of all your drugs and then adjust the
quantities. Shelf life of the drug could be loaded once and then access
would calculate expieration dates from your inventory update dates using the
standard shelf life. This is simplified but many stock inventory programs
deal with shelf life, usage and automatic usage of product restocking
requirements. You could also easily add which unit has what and qty on the
unit. Add in a personnel file and you can track who used it and who
restocked. Now this could easily become part of a investigation so testing
and proving it is critical but as a backup you can print reports on stock,
restock and who did it weekly and have the station Chief master EMT sign the
report and file in a secure location. Access will save you much of the
repetitive work and help provide a good audit trail. Start by reading about
relationships and post back as you play, many will jump in with free help
with much more knowledge than myself or Steve. As you'll note, they don't
troll newsgroups for business as they can get enough on reputations. Start
with learning about relational databases. Check out
http://allenbrowne.com/casu-06.html
Pete D.
"Mark" <notmy@xxxxxxxxx> wrote in message
news:hPOdndeSMJ3wmv3VnZ2dnUVZ_umdnZ2d@xxxxxxxxxxxxxxxx
I provide help with Access applications for a very reasonable fee. If you
are interested in outside help, send me a copy your Excel workbook and a
brief desacription of how it works and what you want the database to do and
I will gladlt send you a quote to create the database you want.
Steve
"FIRESUPPORT" <FIRESUPPORT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BC77F924-07AF-46E5-A9D1-99B5BF4BBF69@xxxxxxxxxxxxxxxx
I work for a fire department and one of my job duties is keeping track of
drugs that we keep on Rescue's and Engines. Details of it is Date
received,
lot #, expiration date, and qty. We are using a excel program that i
developed but since then it has grown. What i am looking for other than
keeping track of them is that i have to make sure it is all seperated by
drug
so that way we can find out what's expiring, and how many, and when it
came
in. So we can order more.
Is there a database out there already? Or do i just keep it simple in
excel?
Any help would be appreciated.
Thankyou
Fire Support
- Follow-Ups:
- Re: Datebase needed for tracking of drugs for a fire department!
- From: Daniel Pineault
- Re: Datebase needed for tracking of drugs for a fire department!
- From: Mark
- Re: Datebase needed for tracking of drugs for a fire department!
- References:
- Prev by Date: Re: Limiting Dat base usage
- Next by Date: Re: does ms access use semicolon to terminate a statement
- Previous by thread: Re: Datebase needed for tracking of drugs for a fire department!
- Next by thread: Re: Datebase needed for tracking of drugs for a fire department!
- Index(es):
Relevant Pages
|
