We need a Microsoft Access database for storing patient information.
The form needs to be able to store:
**Patient Name**, **Telephone number, Address** and **Appointment date** and **Time**.
Also, the **Package** they have chosen and at which **Clinic** (we have 4) they are having their? appointment done at.
The package is basically an item they choose to buy with a price.
We have 11 packages(items) currently but we also need the ability to add more.
I also require the ability to generate customizable letters from the details put in the database.
This can be done say using the Microsoft Access forms, entering patients details and then with a click of a button generate the letter.
The letter needs to customizable. We already have the letters in Microsoft Word .doc format. Perhaps using the automated mail merge function could achieve this.
Note that we need to be able to access the database from at least two users running different PCs.