Attendance part of a Database

[D. E. Martin]

I building a Database for Behavioral Health part of a Hospital. What I'm
Trying to do is Make a client builder. So when a person comes in to be
Registered than from that they get a Delagated to a Clinician, but what I
want the Clinician to be able to do is Record the dates someone comes with
Calendar that is presistent. So for example Client A came March 3, 18, 27 on
Calendar it's highlighted or Circled I don't know. Also when a person is
Discharged it can be transfered to a closed type database so that if the
person comes back some of the Registration info can be brought back up. Any
Ideas???

 

[John W. Vinson]

On Thu, 3 Apr 2008 07:41:01 -0700, D. E. Martin <D. E.

I building a Database for Behavioral Health part of a Hospital. What I'm
Trying to do is Make a client builder. So when a person comes in to be
Registered than from that they get a Delagated to a Clinician, but what I
want the Clinician to be able to do is Record the dates someone comes with
Calendar that is presistent. So for example Client A came March 3, 18, 27 on
Calendar it's highlighted or Circled I don't know. Also when a person is
Discharged it can be transfered to a closed type database so that if the
person comes back some of the Registration info can be brought back up. Any
Ideas???

Yes. Learn a little about databases!!!

You're thinking about Calendars and user interfaces and forms. That's like
installing the kitchen cabinets and plumbing before you've poured the house
foundations!

Get your Tables and Relationships designed *first*, using the principles of
normalization. YOu will need a table of Patients, of Clinicians, of
Appointments, and undoubtedly other tables. THEN you can start thinking about
the user interface.

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

Another issue is that medical records data is covered under the VERY stringent
HIPAA regulations covering patient privacy, data security and information
transfer laws. Unless you have $100,000 or so to spare for fines, you may want
to consider using a commercial (HIPAA-compliant!!) medical records
application, or hiring someone who's done such applications to build it for
you. I would suggest that Access by itself is not sufficiently secure to
*ever* be HIPAA compliant; you would at least want to store the data in a
secured SQL/Server instance.

 

[Evi]

I suspect that English is not your first language. It will help us all to
understand what you want to do, if you use simpler words.
I'll try and translate into those little words which I understand, so that
the really clever people here can help you with your design. Check if I
translate this correctly

When a person comes to your clinic they are assigned to a doctor.
Appointments are made for them.
You want to produce a Calendar report with the dates when the person
attended his appointment. You want those dates to be highlighted in some
way.

(or do you mean you want to highlight future appointments?)

When the patient is discharged, you want some way of archving his records
but in such a way that they can easily be brought back if that person
attends again.

Is this what you meant to say?

Evi