Access or Excel?

macropod · #12 04-11-2011, 04:24 PM

Quote:

Originally Posted by hektisk

Details of what? I apologize - I don't mean to be obtuse. We would store no data except for their name on the hospitals and doctors in this database. So we wouldn't, for example, store the doctor's address or the hospital's phone number. I'd plan on creating a lookup with fixed values (drop-down box) to ensure consistency. If I were to create new tables for hospitals and doctors, why would I not create tables for every other column which has a pre-set number of options (such as the wounds or infections columns)?

Well, if you're planning "on creating a lookup with fixed values (drop-down box) to ensure consistency", that's a definite candidate for a table in its own right. I imagine your 'catchment' in this regard is for the most part fairly limited, so the number of entries to go into and be maintained in the table would be relatively small.

And, yes, you could create another look-up table for 'conditions' but I imagine there'd be so many variations compared to the number of patients that the effort in creating and maintaining it would outweigh the potential benefits.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel to lookup Access Database	PeterP	Excel	1	06-11-2009 12:33 PM
Should I uses Access or Excel?	tinkertron	Office	5	03-29-2009 08:30 PM
Excel or Access ?	inferno	Excel	0	10-03-2008 03:42 AM
Delete excel files by code in Access	Barry Richardson	Office	0	06-13-2005 06:26 AM
MS ACCESS - Import from Excel problem	Gregory_in_Montauk	Office	6	05-06-2005 08:50 AM