Create A Patient Database
Patient Attendance Database - Dates specific for one patient shows up for all of them
I am trying to create a database for a clinic, and am severely stuck on how to input appointment dates for individual patients.
I have been using the 'student' database from office.com as a template for how to save the dates (given that appointments and attendance are exactly the same!), however, even afterfollowing what has been set up in the 'student' template database, I can't seem to replicate it.
Every time I add multiple visit dates for a specific patient, these exact dates show up for every other patient in the database. I need to be able to add different dates for all the different patients.
one to many, analyze each medical encounter
I have a one to many database set up. Primary table contains patient demographics, and the encounter table contains each medical visit. When there are two medical encounters, there will be two records of that same patient.
One of the analyses is find out which encounter of the patient meets certain criteria and guidelines set out by this provincial authority. The analysis can be.of the total number of patients coming to this hospital, how many of them have evidence of a specific test in a given period. (say in the month of july and august)
So the calculation is patient-specific as you can see.
Now given that the database can actually store multiple encounters for each patient, how do I essentially base my calculation on each encounter rather than patient? I am told that each encounter needs to be looked at and we would like to find out if every encounter for that patient meets the criteria, etc.
How should I go about doing the analysis this way
Single Record Reports
2. I'm using Access 2007.
3. I'm trying to create a patient database (think medical records)
Can I create a report for a single record (I.e., patient)? I would like to be able to create several single-record reports. For instance, one would be a kind of summary page withdemographics for this one particular patient, etc.
Copying from non-null field in table to the next records below
An excel file with lab tests grouped by patient code. I've imported this into Access 2010. However, the records for the labs do not repeat the patient code in each line.
I've tried to create a macro that will use the "sendKeys" command to copy, then paste, the patient code in the field (field #1) for each record (stopping when reaching the next patient code).
It seems like this should be very doable, but I've been unsuccessful. There are many hundreds of labs (about 7 per patient), so I need to automate this.
Print Service Memo
I'm working on patient database by access 2003. I want each patient to be given a service memo from the counter at the time of registration and also if the patient seek any service from any department he/she will be issued a memo prior to service rendering.
Report Pagination Situation
I am running a report that is grouped by a field (in this case, patient name). Data for multiple patients will be printed at a time, with each new patient starting on a new page and a patient possibly filling 2 or 3 pages or more.
I would like to use page numbers specific to the patient grouping--for each new patient the page numbers would restart with "1 of # pages."
Is there a way to do this that doesn't take master coding? I can do some coding but wouldn't know where to start.
Designing a medical database
I am designing a database for patient vital signs (height, weight, BP, etc). The closer I come to finishing, the more complicated the project gets.
1. Store patient identifying data (name, med record, date of birth, etc.)
2. Store multiple sets of vital signs for each patient
3. Show a patient record with:
- patient ID data
- All his/her vital signs data
1. Table: "tbl_patientData"
2. Table: "tbl_vitalsData" (linked to "tbl_patientData" by [medRec] field)
3. Form: frm_patientRecord with
a. Fields from "tbl_patientData"
b. Subform "frm_vitalsData subform" (linked to main form by [medRec])
I am very very VERY new to microsoft access. I'm wondering how I would go about creating a patient database. I want to be able to have a create a list of patients and when you click their name I would like a spreadsheet from excel that I have created to pop up! I want to be able to make it save as well, so if you make changes to the spreadsheet, it will automatically save. I'm not really familiar with any programming. Any help will be greatly appreciated!
Using command button to carry data into a form
I currently have an Access database with two tables, one with a list of patients and another with a list of admissions for each patient. Basically what I'm trying to do is select a patient from my current list and add information for a new admission for that patient. I was able to do this using a subform within my main form pretty easily, but the size of the form has become cumbersome.
What I'm trying to accomplish is to select a patient from a combo box, and then open a "New Admission" form using a command button, which will carry forward the Patient ID from the combo box and allow me to enter data for a new admission. Right now, the command button works to bring up the form with the existing admissions for that patient, but when I try to add a new record the Patient ID is lost within the form and it won't let me add any new records.
I'm obviously missing something, but I can't figure out what it is. If anyone is willing to help me out, I'd greatly appreciate it
Creating table using data from linked ODBC connection
I am creating a database to track patient case loads for individual providers. Some patients are seen by multiple providers. The goal is to have the patient in the database only once, buthave the option to list multiple providers within the record.
I have created a Select Query that links to an ODBC table to pull patient demographic information from the electronic medical record system. The query pulls all of the data that I need correctly.
I have created a Form titled "Home". The "Home" Form has buttons that run different Macros. I want to be able to click one button on the "Home" Form to run the demographic query and search for a specific patient ID.
on click, I could enter the patient ID and it wouldsearch the linked ODBC connection for that patient's demographics and then automatically add that patient to the patient list table, along with of their demographic information that Ineed.
Like I said, I've been beating my head against the wall trying to figure this out and I just can't do it on my own.
Split Text From Excel To Access Then Recombine
My database has a seperate table for comments. The Excel s/s I want to import has a single column for comments eg '28/10 Phoned Patient, 29/10 Patient confirmed appointment, 30/10 Saw Patient'.
I want to convert this column into my table as seperate records eg
PK: 1016 Ref: 11293 Date: 28/10/10 Action: Phoned Patient
PK: 1017 Ref: 11293 Date: 29/10/10 Action: Patient confirmed appointment
where Ref: is the patient Number.
I then want to add records to my database eg
PK: 1018 Ref: 11293 Date: 30/10/10 Action: Saw Patient
At the end of the week, I want to export all of the comments in my table to an Excel spreadsheet, with all of them in one column, then send it to the carers.
When the s/s comes back with any new comments, I need to be able to upload the new comments into my table. I am thinking, get the carers to update a 'New Comments' column, which I can then import into my table?
Any help most appreciated.
PS What are tags
Multiple Subforms - Can't assign value error
Can someone give me some ideas?
I have a form with 3 subforms. My main form is based on a table of patient data, and the subforms are based on this data plus different tables connected to that main table. I have patient & followup, patient & diagnosis, and patient & doctor.
It opens to the Patient (main) and followup (subform). Here, I can assign the patient id in the subform to match the patient id of the main form. However, if I go to the other 2 subforms, I can only enter data by manually entering that patient id - if I assign it in the form I get the error msg, "you can't assign a value to this object
Applying a parameter query to several queries to create a report.
I am currently working on a database system and I am trying to figure out a way to allow a user to create a report based on two values: a patient's unique identifier and their date of visit to the hospital.
The purpose of this report will allow to view all patient data for that particular date.
I already created a report that consists of several subreports that were generated by queries. However, not all queries function the same. For example, I created three queries that display the 4 most recent entries prior to a date value submitted by the user.
For another query, I programmed it to return all entries for a specified date and beyond.
My solution was to create a parameter query that will instruct the database to create a report based on the patient's identifier and specified date value. I just need to know how I can apply one date value in a query to several queries at the same time.
Synchronization between forms
I am currently working on a database and I am having issues with form synchronization.
The forms that I have created consist of a main form that displays "Patient" data (Last Name, First Name, MRN - unique identifier), and a subform that displays a specific kind of data related to that "Patient" (Discharges, Resources, Vitals, etc.). When I switch between forms, I want the information being displayed in the second form to be related to the same patient from the first form (the patient info. listed in the main form should not change).
I have tried using Macros and Modules to accomplish this but I am totally confused at this point. Does anyone have
How to create relationships between tables for this situation
I am new to access and am having problems understanding relationships between tables. I tried my best to read help articles but I could not fit them into my situation.
I thank the reader for his/her patience and time.
I am trying to create a database for a hospital. Patients get admitted to the hospital, get monitored every day and then get discharged. To collect their data I made 3 tables.
1) Patient entry table - Has background details of the patient when he comes first to the hospital
2) Daily monitoring table - For entry of daily parameters (heart rate, temperature, blood pressure, etc.)
3) Patient discharge (exit) table - Has certain other parameters which are checked at his exit
Of these Tables 1 & 3 are filled only once I.e. at entry and exit while table 2 is filled daily for a patient.
Each patient is given an unique hospital ID.
I had made 3 separate forms (for each table) with the fields from the tables for data entry (as the fields will require labels to explain certain details for an inexperienced user who tries to enter data). Forms are meant for data entry. Am I right?
Inserting records in multiple tables
I began to make a simple db for my patients (I m a doctor).
I have a central table with the patient's data and others regarding their history, their visits etc
I ve made a form where I put fields from all the tables in the same form. I need to be able to type in the each new patient's data, with his significant history and then to type in each new visit for each patient.
For this reason I've put the Social Security Number in every table. It's the primary key in Patient's data and in patient's history and it's common but not primary key in the Visit's table.So I've made One-2-One relationships with patient's data and patient's history tables (I need 1 record for each patient) and One-2-Many relationship between patient's data and patients'visits' (many patients, many visits for each one).
The problem is that when I insert the patient's data in the form, and I go further to insert info in the fields of his history and visits, Access say "cannot find the value in the "SocialSecurityNumber" field of Patient's History table".
Is there any way to insert one time the SS number in the patient's data table and then automatically be inserted in all SSN fields,
Pull value from one field to a specific record
Without going into all of the filed in my tables the following pertain to my (simple?
Table 1 Patient Registration
Patient ID (Prime Key)
Table 2- Clinical Out Come Data
Outcome ID (Prime Key)
Patient ID (as a foreign key)
Date of appointment
Here’s what I would like to do.
After data is entered into the Patient Registrant form I would like the Surname to automatically appear in the Surname field on the related record in next table (Table2). I know data should not be duplicated like this, but for efficiency and accuracy the user needs to physically see the name of the patient on every form as they are entering the data. retyping or cut and pasting is a real pain.
Let's say: I've got 100 patients. They are in one table.
Let's also say: I've got 50 patient rooms with beds A & B set up in another table.like 1A, 1B, 2A, 2B, and so on.
I want to assign the first patient to bed 1A. 2nd patient to 1B (don't want 1A to be available if it's in use).and so on.
At the end of the day, I want to print one report by patient that says:
Angelina Jolie - 1A
Brad Pitt - 1B
And.I want to print another report that tells me what beds are vacant. I don't know if I'm brain dead.or just not smart enough to figure this out, but would appreciate any help anyone could give.
I have a table with the fields Starting_Date and Finishing_Date. I need to create a query that asks the user to input a date and if the date is in between the Starting_Date and Finishing_Date the necessary rows will be displayed.
This is what I have so far, but it doesn't work.
SELECT PATIENT.[First Name], PATIENT.[Last Name], PATIENT_ADMISSION.Starting_Admission_Date, PATIENT_ADMISSION.Finsihing_Admission_Date
FROM PATIENT INNER JOIN PATIENT_ADMISSION ON PATIENT.Patient_ID = PATIENT_ADMISSION.Patient_ID
WHERE (((PATIENT_ADMISSION.Starting_Admission_Date)>=[Please enter a date]) AND ((PATIENT_ADMISSION.Finsihing_Admission_Date)<=[Please enter a date]));
How do I make the [Please enter a date] value be used as a comparison for the two fields
Need button on report to open other page in navigation with details
I have a navigation form with a patient data entry section with tabbed pages within it for visits, procedures, history, etc. The second navigation tab is a report center with tabs for different forms that will show patients with a specific disease in a list form (these reports only show patient names).
I want to add a button alongside each patient name to view details that will refresh the main form to the details page with the corresponding patient information loaded.
I don't want it to open another form window but jump back to the first tab in the navigation form with that patient's information pulled up.