Just a little bit of help with Access...
November 5, 2007 11:27 AM Subscribe
I've been asked to create a software facility through which a nurse can print medicine dosing cards for patients.
posted by dance to computers & internet (2 answers total)
At the moment, the nurse writes out these cards (templates sold by a big company) by hand. Fields are medicine name, dose, and when it should be taken. There can be more than one type of medicine needed to be taken.
They serve as an aide memoire for the patient and as general information about what the patient is taking for reference.
My thinking is that this could be done in Excel (perhaps not so pretty) or Access. My choice would be Access because I think it's a more natural fit than Excel. The forms the nurse would use would pull names of medicines and patients from tables and then feed that data into reports which would form the 'cards'.
Before I start, is this the right way to be going about this, and has anyone any tips on (for example) how to print precisely onto templates. In films somebody shoves a cheque into the printer, types an amount into a box, hits print and bam, there's the amount perfectly positioned on the cheque. When I try this I usually end up with a lot of wasted paper before I hit the jackpot. Is it just trial and error?