Patient database

I am using Access 2003 for the first time and learning how to develop a 
patient database for a non-profit program.  

I've created a table that contains the names and personal information of 
each patient participating in our program.  My problem is this: I would like 
to create a subform for each patient that lists their appointment history but 
I don't know how to create a relationship between the patient and their 
appointment history (which at the same time will allow me to enter more than 
one entry).

Please help!
-- 
emarq
0
Utf
2/4/2010 11:02:11 PM
access 16762 articles. 2 followers. Follow

3 Replies
4266 Views

Similar Articles

[PageSpeed] 28

If "relational" and "normalization" are unfamiliar terms, plan to spend some 
time coming up to speed on them before expecting to get good use from 
Access.

It sounds like you are describing one entity ([Patient]) that can have 
zero-to-many records of [Appointment].  In a relational database, you'd need 
two tables, related one-to-many.  This would require that the Primary Key 
from the [Patient] table row be included in the record/row in the related 
[Appointment] table.

If that didn't make sense, go back to the first sentence and start your 
studies!

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

-- 
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"emarq" <emarq@discussions.microsoft.com> wrote in message 
news:021E635A-763A-4E24-AE45-FF2AAF993CA9@microsoft.com...
>I am using Access 2003 for the first time and learning how to develop a
> patient database for a non-profit program.
>
> I've created a table that contains the names and personal information of
> each patient participating in our program.  My problem is this: I would 
> like
> to create a subform for each patient that lists their appointment history 
> but
> I don't know how to create a relationship between the patient and their
> appointment history (which at the same time will allow me to enter more 
> than
> one entry).
>
> Please help!
> -- 
> emarq 


0
Jeff
2/4/2010 11:47:37 PM
Well, this should be a 1 to Many relationship.

Your patient Table should be something similar to
Patient_Id
Patient_FirstName
Patient_LastName
.....

So you would construct an appointment table similar to:
Appt_Id
Patient_Id
Appt_DateTime
.....

Linking your relationship between the 2 Patient_Id fields.
-- 
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"emarq" wrote:

> I am using Access 2003 for the first time and learning how to develop a 
> patient database for a non-profit program.  
> 
> I've created a table that contains the names and personal information of 
> each patient participating in our program.  My problem is this: I would like 
> to create a subform for each patient that lists their appointment history but 
> I don't know how to create a relationship between the patient and their 
> appointment history (which at the same time will allow me to enter more than 
> one entry).
> 
> Please help!
> -- 
> emarq
0
Utf
2/5/2010 12:23:01 AM
On Thu, 4 Feb 2010 15:02:11 -0800, emarq <emarq@discussions.microsoft.com>
wrote:

>I am using Access 2003 for the first time and learning how to develop a 
>patient database for a non-profit program.  
>
>I've created a table that contains the names and personal information of 
>each patient participating in our program.  My problem is this: I would like 
>to create a subform for each patient that lists their appointment history but 
>I don't know how to create a relationship between the patient and their 
>appointment history (which at the same time will allow me to enter more than 
>one entry).
>
>Please help!

Take a look at these resources, especially the tutorials:

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

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

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


Do note, however, that any database containing patient medical data is covered
by the extremely stringent HIPAA laws. You may want to read up on these;
$50,000 fines are not fun to deal with! Some would argue that Access simply
doesn't have good enough data security for ANY patient information database. 
-- 

             John W. Vinson [MVP]
0
John
2/5/2010 12:51:17 AM
Reply:

Similar Artilces:

Splitting Database
I have an Access Database whick I converted to 2003, using the Database Convert. I want to distribute the database and be able to upgrade the front end without changing the underlying tables. I now want to split. When I split, using the Database Splitter, the tables revert back to Acess 2000. Any help? ACCESS 2000 format is the format for ACCESS 2003 (and ACCESS 2002) tables. Nothing is wrong. -- Ken Snell <MS ACCESS MVP> "Sylvia D" <anonymous@discussions.microsoft.com> wrote in message news:c32401c43892$cd02f400$a401280a@phx.gbl... > I have an Acc...

database maintenance SQL 2005
At one time there was a knowledge base article on how to use the maintenance wizard on SQL server 2005, for scheduled maintenance on the Dynamics Databases, Does anyone know where that is? or have suggestions on what options to select when using the maintenance wizard? -- Doug ...

Copying over a database
I am about to open a new store, and I am looking for an easy way to copy over the item data without any of the sales or quantity info that exists already (since that is store specific). Does anyone know a good way to do this, or am I missing something obvious? Thanks! Scot Gerhardt Shuffle & Cut Games Anyone with an idea on this one? (Read: *bump*) Figured this one out on my own - will save anyone reply time. Thanks! ...

Excel as DataBase in Front Page
Has anyone successfully used Excel as a database in FRont Page, allowing users to make changes and update the spreadsheet? I am almost there I think but now am getting a "Data Type mismatch in criteria expression" error message from the ODBC Excel Driver. Any ideas???? Thank You ...

How to move CRM databases to different drive
I'm setting up CRM on Small Business Server 2000. The small business server had been originally installed without SQL, so I added SQL 2000 using the small business server installation wizard. I installed SQL in the default location on C:\. I wanted to put the SQL program files on C:\ and the data on D:\, but unfortunately the installation wizard didn't give the option of specifying a different location for the database files. I then ran the CRM installation, which didn't give a choice of database locations either. So I ended up with all the databases on C:\. How do I mo...

Patients forms
Hello Everybody: I started to look read your postings recently and it has been amazing what I have learned. For that I thank you all. I have this situation. I am a physician trying to put my patients clinical histories into excel. The reason being I want to use its capabilities for reporting, statistical analisis and data consolidation without having to import or export from and to other programs. I want it to be something that, by having dsigned it, I can understand to perfection. I though of doing it in Forms, in sequens, where in one I put the bios of the patient, next current illnes, ne...

How do i recover a database lost during compacting?
How do i recover a database lost during compacting? You could try looking for a file named db1 or some such thing in the same folder. However, the best way (the only reliable way, really) is to back up before compacting. Felix wrote: >How do i recover a database lost during compacting? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200912/1 Felix <Felix@discussions.microsoft.com> wrote: >How do i recover a database lost during compacting? Also *IMMIEDIATELY* download, preferably on another computer...

Exchange database size limit.
Hello all, other than running the eseutil is there any other way in which I can decrease the size of my exchange database? It is currntly to large to start the service. Any help is appreciated. Thank you. Kevin Hi Kevin, No, an offline defrag of the database is the only thing that will physcially reduce the size of the database. Kind Regards, Rob Wilcox Microsoft Exchange Specialist Support Engineer This posting is provided "AS IS" with no warranties, and confers no rights. Hey Kevin You can use Exmerge utility to backup your database to a pst, after which you w...

Designing a patient management
Being a newbie to access, I have been given a task of creating a db for the patient management and tracking. This DB will have around 50 patients per year. It will contain the history of patient's contact info, pediatrician, case manager,Genetic center info, Insurance info and so on. I have created the tables. pls review them and suggest me your ideas to improve the DB, as mine maynot be best. tblPatients RegID - PK PatientID,FirstName,LastName,DOB,Gender,Hospital,MA,CaseStatus,Diagnosis,Address,City,Zip,county,MFirstName(mom),MLastName,MAddress,MCity,MState,MZip,MHomePhone,...

how to copy acces database field into word document
I' l be very glad if someone could help me to learn, how could i insert the copy of access field into word document. I look for information regarding posibility of diferent way of clasical insert merge fields into document. For example I saw the word document with access fields inserted, but each field was delimited with sqare brackets. Thank you in advance. I would urge you to take a look at http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html Specifically the 'Super Easy Word Merge.' about half way down the page. It is relatively simple to implement and works...

Show One Record For Each Patient ID.
Hi I have a table that store data when a Patient visits a Medical Centre. I have setup a form to take information (Parameters) for a query to run and all works well except I don’t know how to show only 1 record per Patients ID (conpid), I don’t want all records to show for each Patient only 1 (last would be ideal) Any help would be appreciated. Regards Barry Existing SQL (so far):- SELECT tbl_consultations.conid, tbl_consultations.conpid, tbl_consultations.conpnf, tbl_consultations.conpnl, tbl_consultations.ConpDOB, tbl_consultations.conpfn, tbl_consultations.conts, ...

Can we have Advanced Find on database other than MSCRM Database
Hi, When the Advanced Find button is clicked in Microsoft CRM,is there any possibility that it can contact another database that is integrated with Microsoft CRM and retrieve the information? Kindly let me know if there are any inputs to this. Thanks Unfortunately not - the data has to come from CRM entities -- David Jennaway - Microsoft Dynamics CRM MVP Web: http://www.excitation.co.uk "KIRAN" wrote: > Hi, > > When the Advanced Find button is clicked in Microsoft CRM,is there any > possibility that it can contact another database that is integrated with &...

Access database created when opening Excel
Users are having a problem opening Excel within Access in that it creates a 'psuedo-database' (they are not importing). Access is creating a database with the same name as the Excel spreadsheet. The users then have to delete the 'psuedo database' (the one created with the Excel name) when they close the Access database. Is there a fix for this? Is there a setting that we are missing? Thanks, Bill How are they opening Excel within Access? Are you using the Shell function? -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/...

Overwrote Database
I hope some one can help with this. I accidently tried to name a new Access database the same as a database that I already had created. I was allowed to create the new database with the same name, but now the original database is gone. When I go the new database, none of my original objects are there and instead it looks like a new database. I have tried lookign in the recycling bin, but to no avail. Can any one help or am I stuck. Any assistance would be greatly appreciated. If you don't have a backup, I do believe you are out of luck. You didn't actively delete it but ...

Joins Across Servers/Databases
Hi there, Is there an easy way to use excel to create a single query that joins two different databases, such as an oracle db and a MS SQL db, and bring the data back into one excel worksheet. This is a complicated task that I'm trying to accomplish, but have not had any luck so far. Thanks in advance ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ Did you try Data>Get External Data>New Database Query? In the wizard, select a table and proceed to the las...

R&D database
I would like to create an R&D database with the following: I want to create a Tests table, PartNumbers table, PartNumberTests table and a Results table. We will enter tests in the tests table, and part numbers in the PartNumbers table. then we would like to assign tests to a partnumber in the partnumberTests table. Up to here I have no problem doing this via forms and creating whatever is necessary (relationships, queries, etc). Then We would like to call up a form that would display a part number and its related tests and empty fields so that results can be properly recorded (into t...

Determing the version/service pack of a database
Is it is possible to determine the version/service pack of a database without the corresponding DYNAMICS database? Thanks, Zack Zack, This is not possible. The current service pack (build numbers) level for each GP database are stored in the DB_UPGRADE table in the DYNAMICS database. select * from dynamics..db_upgrade On a second thought, if you know the version of GP where the database came from and if you take a pesimistic approach and restore the database to a shell company created with RTM version of GP, you can then proceed to apply service packs to bring it up to the level you...

Does Access 2007 corrupt 2000 database queries?
I have a database that I made a small edit to last night on my Vista machine running access 2007. The database is on a network shared drive (not ntfs). The query still opens fine on access 2007, but on my XP machine running office 2000, when I open or try to edit the query, Access 2000 just closes with no error message at all. There is also no entry made in the application event log. When I attach my debugger, Visual Studio reports an unhandled exception at 0x1b018900 in MSACCESS.EXE Access violation writing 0x00040ffc So, clearly the file's not working somehow. So, two questions...

Year end close with 1 database and 5 entities
I have one data base with 5 entities. Each entity has its own Retained Earnings account. MGP only allows one Retained Earnings account to be used when closing the year. I currently now must do a journal entry to reclass each entities Current Year activity out of that one Retained Earnings account and to its own Retained Earnings account. I have been using 12/31/yy as the date of the reclass entry. It however creates an out of balance for each entity's Balance Sheet. The out of balance amount is the Current Year's activity. So: 1. Does anyone else have this issue? If you...

Converting 97 database to 2000 database
We have been trying to convert a database over with resulting runtime errors and even one error during conversion that warned of a corrupted Visual Basic for Applications project. I noticed that the database would work in Office XP. (Although, we could not, and should not, make changes that db because we would lose Office 97 functionality). So I just made an experiment. I used Access 2002(XP) to convert the Database to Access 2000 file format. The conversion on this test copy of the database seemed to operate normally and I could now open the database in Office 2000. We have ...

Can't open Access database
Our Access database now resided on our Server. If one person opens the database from te folder it is in on the server, then no one else can go to the Access database from that shared folder on our server. Is that normal? ...

Database list vs pivot
Hallo everyone, I am following a tutorial to do a simple database list in excel. The tutorial suggest me to do Data>List but in Data menu in excel 2000 I don't have list!!!! Someone could tall me how to create a list with Excel 2000. If I select Pivot start a wizard that cover with a mask my data Tnx Data|List was added in xl2003 (IIRC). It doesn't exist in xl2k. Maybe you could use data|filter to see some of the features of data|list. "gabinettoski@supereva.it" wrote: > > Hallo everyone, > > I am following a tutorial to do a simple database list in ex...

Patient database
I am using Access 2003 for the first time and learning how to develop a patient database for a non-profit program. I've created a table that contains the names and personal information of each patient participating in our program. My problem is this: I would like to create a subform for each patient that lists their appointment history but I don't know how to create a relationship between the patient and their appointment history (which at the same time will allow me to enter more than one entry). Please help! -- emarq If "relational" and "norma...

wss3 database size limit
When our wss3 was setup, they used SQLExpress, which was free. Now about 1 year later I am noticinhg the database size is approaching the 4GB limit. What would be the best way to address this? I do have a licensed SQL standard 2008 server I could move to, but have read it is not a simple process to move the wss3 dataabases and still have a functioning sharepoint services. Im open to all options- what would be the least5 amount of work/risk to resolve? Many thanks Carlia ...

Patient Demand on X Day of the Month
I need to summarize and compare patient demand for appointments going back over three years. I can pull the data and display the days of the week. In Ms Excel, is there a way to line up the same days of each month - but not the dates? For instance, I need to line up and average all of the first Mondays in May, all of the first Tuesdays in May and so on. DOUG in Wichita You are going to run into problems with that. This year April has 5 Fridays. Last year it only had 4 Fridays. How would you like to deal with that type of situation? You may be better off matching 52 weeks ...