Could you please tell me how to create an hospital software in msa

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am very intrested to know how to create an msaccess software for hospital
to handle patients. Please give me information about how can I do that.

Would appreciate.
 
The most important aspect of creating any database is to get the data
structure right, so here's a starting point:
http://www.databaseanswers.org/data_models/hospital_admissions/index.htm

Once you have understood the one-to-many relations, creating the tables with
primary keys and foreign keys, and created the relationships between them,
you can then go on to creating the forms as the interface to add, edit and
delete the data stored in those tables, and the code to validate and respond
to the data, followed by the queries and reports that produce meaningful
hard copies for everyone.

Then comes the process of documenting how it works, testing, and final
debugging, followed by a period where your system is run in parallel with
whatever procedures the hospital currently has in place until it is all
verified as working correctly.

Before you begin any of that process, you will need to complete an analysis
of what the software needs to do, so that you do not get part way through
the development process and discover there is a gaping black hole in your
design.
 
Thanks a lot for your immediate response about hospital softwre. Please help
me for the following also.

Every week I have to arrange a meeting letter for my department and have to
inform more than 10 staff to attend in scheduled time before one day of
meeting and before 1 hour of meeting. In my idea I need access software as
below :

1) I have to maintain a list of staff participating in regular meeting.
Some times
one will not attend and other will attend. So I have to select those
I need each
time.
2) I will select the staff who have to participate for the meeting. I
have prepared
an email with details of meeting venue, date, time, topic. After
selecting the
staff name from the msaccess list all those staff's email address have
to insert
in the email address automatically. Then I can send the email.
3) Can I create a facility for sending email to send in scheduled time too?

Please let me know how can I do this? I have basic knowlege in msaccess.
--------------------------------------------------------------------------------------------
 
You will need at least these tables:
1. Employee (one record for each employee)

2. MeetingType (one record for each kind of meeting, where "meeting type" is
defined by who is expected to attend.)

3. MeetingTypeEmployee table (junction between above 2 tables):
MeetingTypeID
EmployeeID

4. Meeting table (one record for each proposed meeting):
MeetingID
MeetingDate
MeetingTypeID

5. MeetingAttendee (junction between Metting and Employee):
MeetingID
EmployeeID

6. MeetingAttendeeNotification (one record for each notification message
sent):
MeetingID
EmployeeID
NotificationDate (Date/Time)
NotificationMessage (Memo)

When you create a new Meeting, you can execute an INSERT query statement to
populate MeetingAttendee with the people expected (from
MeetingTypeEmployee), and then manually remove known apologies or add known
guests.

You can then create the notifications programmatically, using SendObject in
a loop to send the emails.
 
Back
Top