Search results

I've got a question about forms design. I have a database that keeps track of isolated patients (infection purposes) and that gives the location, name, ID# of the patient etc. I'm brainstorming ways that I can design the forms. There is a master and child table, the master table...

I understand how to use subforms like this, this was my plan. I see my main form as somewhat of a search form that will either create a new master record and child record if it's a new patient, or create a new child record under an existing master record. I admit that I have no idea what a...

Hi there, Im building a database to keep track of Isolated patients in a hospital. I have a master table that keeps track of patients, and comments, and a child table that keeps track of individual isolation periods for statistical purposes. My question is, how should I go about setting...

Haha, Yes, I keep hearing how easy it is, does anyone know of a good resource when I can find out how to actually effectuate this easy project? -Z

I also have other factors that can change for each patient, like the type of isolation precautions they are on, or the type of infection they have, will one child table work for all of them? Or do I need three? I cant seem to find any info online about setting up a master-child table...

I understand how I could calculate the number of days spent in a certain location, but how are these linked back to the patient?

Im still not really grasping the concept of how MS access is going to keep track of when the location is changed without opening a separate record for each stay.

I have a crosstab query that tells me the number of records of each type per month per type. For example the number of falls for january - july broken down by month. I also have several locations, and I have built separate queries for each location (there are about 100). I really do not...

Anyone have ideas on how this might be accomplished???

I see, but how can I go about altering the location without losing the original location permanently?

Im still a bit confused here. How can a diesign this so that a user can open a patient's record and then change the location? How can I make it so that the number of days that a patient was on a certain location is measured even when the location can change helfway through a hospital stay...

Thanks alot! That gives me a quick run down of the total incidents per month. Any ideas on how to best drill down deeper into the data? For example : Specific Types of incidents per month, etc Also, what is a good way to illustrate this data in table or chart form quickly? -Z

This is all for access right? Kinda looks unfamiliar to the design view of queries to me. -Z

Sure, my primary key is a field called "ENCON" and there are fields called "Location", "Degree of Injury", "Type", "Specific Type" (a subset of type), "Person Affected", "Date", "Date Resolved" Things like that. I dont think Ill need stats beyond stuff like: -Number of records per location...

Hi there. I have an incidents database for a health facility. I want to create a little summary table or graph that summarizes of the type of incident, specific subtypes, and location for specific time periods, so that we can see whether there is improvement or deterioration over time...

I think I see what you mean, but I still have a few questions about how it would all work. For example: 1. How could a user change the location of a patient and still have records that keep track of total days for specific locations? 2. How could a user bring up a summary of a patients...

So that would mean pulling a form into a form (making it a subform) and having the controls that record locations inside the subform? -Z

In terms of having a form that will allow users to change the location of a patient, what you think a good way to set that up would be? -Z

Hi Hitech, thanks for the feedback, Im new to db design, can you elaborate on how I can implement the child table that you suggested? Im using Access 2003

Thanks HItech, can someone tell me a little bit more about how a child table works ?