Help!!!!!!!!!!!

Question

Hi Guys,

I need a help from our community in a project. Please help me

Topic: Data Entry for a patient.

I work in a hospital and I need to keep the record of the medicines which I dispense to a specific patient.

For Example:

Patient ID 1234 was dispensed 10 tablets of Amoxycillin, 20 Tablets of Paracetamol and 5 Tablets of levocetirizine.
Patient ID 5678 was dispensed 15 tablets of Amoxycillin, 5 Tablets of Dexamethasone and 2 Tablets of Albendazole.

And 500-700 patients per day like them.

Now I want to get a database at the end of the day which can tell me the patient wise consumption and specific drug consumption so that I can keep a record of the same at the end of the day.

I am not that much technically sound but I hope you guys will understand my pain and help me with an excel module or anything like data entry tool to get me out of this problem.

p.s. I have about 300 medicines in my hand.