doctors office database

[Pat]

a database program that keeps track of patients, and their records. It would
have all the required fields with appointments, and all the necessary
requirements for that record that a doctors office would require ie;
insurance, referrals, address, telephone number, account number, social
security number, etc.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...772&dg=microsoft.public.access.tablesdbdesign

 

[PC Datasheet]

Pat,

I can create this database for you for a very reasonable fee. Not too long
ago I created a similar database for a large medical facility in a large
city. It has a very nice appointment scheduling module that I would
incorporate into your database. Contact me at my email address below after
the beginning of the year if you would like my help.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!

 

[Ken Snell [MVP]]

Good suggestion, although it might be difficult to make a single,
one-size-fits-all database template, as each office's requirements may
differ in many respects. The newsgroups have many posts about exactly these
types of databases that people are building for their offices' use.

But if you can post some questions about what you're seeking that goes
beyond the templates that ship with ACCESS, I'm sure we can provide *free*
sugggestions to you.

 

[John Marshall, MVP]

So if you were so successful in the petroleum industry, why do you have to
annoy the users of these newsgroups for handouts?

These newsgroups are for FREE support, not a vehicle for solicitation.

John... Visio MVP

 

[tina]

keep in mind the HIPAA privacy and security requirements, Pat. an Access
database cannot be completely secured, so you have to consider whether it
will satisfy HIPAA regulations, and the potential ramifications to the
doctor, his practice, and his patients, if it does not.

hth

a database program that keeps track of patients, and their records. It would
have all the required fields with appointments, and all the necessary
requirements for that record that a doctors office would require ie;
insurance, referrals, address, telephone number, account number, social
security number, etc.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...772&dg=microsoft.public.access.tablesdbdesign

 

[Rick Brandt]

keep in mind the HIPAA privacy and security requirements, Pat. an
Access database cannot be completely secured, so you have to consider
whether it will satisfy HIPAA regulations, and the potential
ramifications to the doctor, his practice, and his patients, if it
does not.

We see this a lot and I wonder if anyone has actually researched the
requirements. The weaknesses in Access security are only a factor when you are
trying to secure the data from *authorized users* of the application. If access
to the application file (mdb) is controlled with network security then it is
just as secure from *unauthorized users* as any other file.

Would HIPAA regulations dictate that NO electronic file can contain patient data
unless there is air-tight security actually built into the file itself or only
that appropriate steps are taken to prevent unauthorized access to the file? I
mean most medical records are still in plain old fashioned paper folders. Are
medical organizations required to use a secret code when writing on medical
charts or are they only required to take steps so that only authorized people
get their hands on them? I assume it is the latter. I fail to see why the bar
should be any higher for electronic versions of that same data.

 

[mikeinohio]

got to this link and download the PDF

http://www.cms.hhs.gov/EducationMaterials/Downloads/SecurityStandardsTechnicalSafeguards.pdf

 

[Smartin]

Thanks for the link.

From a bystander with a casual interest in HIPAA issues it seems from
this reading "reasonable" and sufficient safeguards fit the bill, as it
were, and Rick's take on the matter is spot on, especially as regards
authorization and network security.

 

[Handgunner]

I work for the DoD supporting Military medical software and am required to
take multiple certification courses relating to PHI (Personal Health
Information) and PII (Personally Identifiable Information). The rules are
fairly stringent, but necessary. Anyone working in a medical facility who
has access to medical information (PHI or PII) is required to be HIPAA
(Health Insurance Portability and Accountability Act) certified. Requiring
everyone who works in such a facility to be HIPAA Certified limits the
problem of security, as far as employees, etc. Other that that, normal
computer security measures should be implemented (secure passwords, etc.).
Therefore, building a database would be adequately secure if these measures
are followed.

That being said, I also am looking for a template (at least for starting
ideas) for a doctor's office.