New Project for me - It should be simple

[aymanmb]

I need your ideas on the design and I will implement after studying.



I need to create a database for my pharmacy. We do blister pack (medication organizer) for the patients. We do them in batches every 4 weeks.

I want to design a simple database that will help me get organized with:

- which patients got thier medication, when, and when they are due next
- who prepared them, who checked them, dates associateded with preparation and checking
- I should be able to get a report of the history of a particular patients (summary of what he/she got within a date eange).
- I should be able to run a daily report or query to give me those patients that we need to get their next batch ready.
- I should be able to check off those we finsihed preparaion

Your ideas of the design is appreciated.

[June7]

See if this helps you get started http://www.rogersaccesslibrary.com/