MS Access Help

[av06]

I've never really used access before, so I'm a bit of a noob with it, but I told my uncle I'd make a database for him. He's a doctor so he needs a database for his patients. One thing he wants to be able to keep track of is medicines they've been prescribed, dates they were prescribed on, and so forth. I don't really see any "list" object under access so I was a little unsure about how to go about doing that. My thought was to create another table for medicines and then set up a relationship between the medicine table and the patient table. Would that be the best way to go about doing that?

 

[Remou]

You will need a third table for the medicine-patient set-up. However, for such an important database, I suggest you at least take several courses befor you even start.

 

[lespaul]

and read up on the HIPPA requirements for storing medical information....

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins