A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

doctors office database



 
 
Thread Tools Display Modes
  #1  
Old November 14th, 2005, 07:09 PM
Pat
external usenet poster
 
Posts: n/a
Default doctors office database

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/comm...blesdbde sign
  #2  
Old November 14th, 2005, 08:01 PM
PC Datasheet
external usenet poster
 
Posts: n/a
Default doctors office database

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

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!


"Pat" wrote in message
...
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/comm...blesdbde sign



  #3  
Old November 14th, 2005, 08:13 PM
Ken Snell [MVP]
external usenet poster
 
Posts: n/a
Default doctors office database

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.

--

Ken Snell
MS ACCESS MVP



"Pat" wrote in message
...
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/comm...blesdbde sign



  #4  
Old November 14th, 2005, 08:15 PM
John Marshall, MVP
external usenet poster
 
Posts: n/a
Default doctors office database

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

"PC Datasheet" wrote in message
et...
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



  #5  
Old November 14th, 2005, 08:18 PM
StopThisAdvertising
external usenet poster
 
Posts: n/a
Default doctors office database


"PC Datasheet" schreef in bericht et...

snipped all the advertising stuff

To the OP: Beware of this guy!!

Steve just does *not* care about the newsgroups. He has *no ethics at all*.
Steve *only* cares about making *money*, and he acts as if the groups are his private hunting ground.

-- He abuses this group and others for job-hunting and advertising over and over again
-- He is insulting lots of people here when they ask him to stop this
-- He posted as Steve, Ron, Tom, Rachel, Kathy, Kristine, Heather and ??? while asking questions
(the latest 'star's': 'Access Resource' and Tom and Andy)
-- He tries to sell a CD ($125,--) with FREE code he gathered from these groups here
-- There even has been a 'Scam-alert' about him which has been explained recently in the thread 'To all':
http://groups.google.com/group/comp....954261f9?hl=en
-- Also recently it became clear that he has been spamming innocent people asking questions:
http://groups.google.com/group/comp....3e5f58ad?hl=en

So why would ANYBODY ever trust a person like him and hire him?
************************************************** ******

Explanation and more links on this answer:
http://home.tiscali.nl/arracom/stopsteve.html

Arno R

  #6  
Old November 15th, 2005, 05:04 AM
tina
external usenet poster
 
Posts: n/a
Default doctors office database

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


"Pat" wrote in message
...
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/comm...blesdbde sign


  #7  
Old November 15th, 2005, 01:52 PM
Rick Brandt
external usenet poster
 
Posts: n/a
Default doctors office database

tina wrote:
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.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


  #8  
Old February 1st, 2007, 09:31 AM posted to microsoft.public.access.tablesdbdesign
mikeinohio
external usenet poster
 
Posts: 58
Default HIPPA Standards

got to this link and download the PDF

http://www.cms.hhs.gov/EducationMate...Safeguards.pdf

"Rick Brandt" wrote:

tina wrote:
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.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com



  #9  
Old February 2nd, 2007, 04:53 AM posted to microsoft.public.access.tablesdbdesign
Smartin
external usenet poster
 
Posts: 192
Default HIPPA [i.e., HIPAA] Standards

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.


mikeinohio wrote:
got to this link and download the PDF

http://www.cms.hhs.gov/EducationMate...Safeguards.pdf

"Rick Brandt" wrote:

tina wrote:
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.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com





--
Smartin
  #10  
Old February 20th, 2010, 06:30 AM posted to microsoft.public.access.tablesdbdesign
Handgunner
external usenet poster
 
Posts: 1
Default doctors office database

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.
--
Johnson B.


"tina" wrote:

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


"Pat" wrote in message
...
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/comm...blesdbde sign



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Encrypt AccesS File? milest General Discussion 2 February 9th, 2005 08:58 PM
What is MDE Charlie General Discussion 4 August 24th, 2004 04:15 PM
Productkey problem when installing office 2003 on network Stefan Schreurs Setup, Installing & Configuration 1 June 1st, 2004 11:16 PM
Two versions again-language issue Otto Setup, Installing & Configuration 3 May 28th, 2004 04:57 AM
Office 2003 and Office 2000/97 coexist on same PC? John General Discussions 3 May 6th, 2004 12:36 PM


All times are GMT +1. The time now is 10:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.