from where do I get a database designed in access for my hospital

[Guest]

I need a database program, for my hospital to keep hospital records and
patient records, billing, discharge summaries. I guess it will be in access.
Can you guide me as to from where do I get such a database program?

 

[Jeff Boyce]

You may need to review local, regional, and national requirements pertaining
to collection, storage and dissemination of patient information before
implementing a database program, of any kind.

Have you searched at Google.com? A system (in Access or any other
development environment) is designed to a specific set of requirements. In
most cases, you'll either have to modify the program to fit your situation,
or modify how you do business to fit how the program works...

How is it that you've already settled on Access as the tool for such a
database?

 

[Guest]

You may need to review local, regional, and national requirements pertaining
to collection, storage and dissemination of patient information before
implementing a database program, of any kind.

Have you searched at Google.com? A system (in Access or any other
development environment) is designed to a specific set of requirements. In
most cases, you'll either have to modify the program to fit your situation,
or modify how you do business to fit how the program works...

How is it that you've already settled on Access as the tool for such a
database?

--
Good luck

Jeff Boyce
<Access MVP>

Hi Jeff
I see that you are a MVP that is a "microsoft valued professional". Its been
a long ride, I started with filemaker, could make some small databases then
got reinterested in access, have bought lots of books on access including
access inside out by John Viescas, who is also a MVP with microsft, and
access 2003 bible by Cary Prague, et al. I realised that I also need to know
visual basic to work smoothly with access. I have been learning both from
the last one year by reading books, but I realise that as I have taken 6
years to work in a proper professional medical school to become an
intensivist ( ICU Specialist) I cannot reach that level of expertise on my
own by reading books. There is a lot to learn and more than learn there is a
lot to learn to implement. I know till the "if and then " kind of loops in
visual basic v 6.0, but I am far from designing a huge database for myself in
access or flemaker or alpha five. It started as a hobby, I know certain
people in the alpha five community who are seasoned database programmers I
thought I could also learn , but I have failed. I wish I could find a book or
a professional on the net under whom I could design databases and work my
way up. Eventually I am full of hopes to design my own one day for my
hospital, but at present I would need one soon .

Thanks for replying Jeff and if you could guide me I would be grateful.

Sincerely

Dr Alok Modi MD

 

[Jeff Boyce]

You will find these newsgroups to be quite helpful, as there are many folks
(whether or not they are MVPs) who have had experience on a variety of
topics.

Generally, these 'groups serve as a place folks can post specific questions
and get specific answers. I'm not aware of anyone who is paid to
review/respond in these groups, so all postings and responses are voluntary.

For example, I have a full time job, and help out in the newsgroups in my
"copious free time" (<g>).

I am more than willing to offer specific suggestions to specific questions
(provided I have experience on the topic). I cannot devote extensive "free"
time to designing a system. If you need a system designed, you may wish to
seek out a professional business analysis, designer, developer.

I believe your self-taught experience would serve you quite well in
understanding the process, but I also understand that you need to focus on
your primary responsibilities.

Best of luck on your project

Jeff Boyce

 

[John Vinson]

I need a database program, for my hospital to keep hospital records and
patient records, billing, discharge summaries. I guess it will be in access.
Can you guide me as to from where do I get such a database program?

As Jeff suggests, that's not typically how the business oprerations
work in Access. Access is a toolkit from which you, or a professional
developer, can custom-build a database for your needs.

If you want an off-the-shelf hospital records program, there are many
on the market. Some may be built in Access but that will not be
obvious, typically! There are hospital supply magazines and trade
journals which will have ads for such programs, or you can use google
to search for them, or both.

If you want to build your own, get the help of a good professional
developer, one who is familiar with the complexities involved in this
field. In the US the HIPAA patient-privacy requirements are very
stringent and require a lot of attention. It will be expensive
whichever way you do it: the *most* expensive way will be to try to do
it "on the cheap", as you'll end up paying lawyers instead of
developers.

John W. Vinson[MVP]