Thursday, 28 October 2010

DataBase Trial and Error

Even though we had out Half Term holidays, our client wanted to have the database trialed and tested as soon as possible so we started some tutorial.
After following our client's advice, (
he recommended us to use the local libraries for useful information
), and after I researched it, I've found it was pretty straight forward. We followed a couple of tutorials online and produced samples for:

We created 4 databases for:

1. Customer information; with their file number, personal information (DOB, name, gender and etc), their address, medical history and more.
2. Finances; to help the nurses keep a record of how many patients came and how much they spent.
3. Sick note; to help the Doctor in writing these notes, making it easier for him to do so by allowing database to generate it for him.
4. Referral letters; the same principle as above but this is to refer patients to specialists when needed.

We had some difficulties with the databases such as no being able to create an either female or male option due to the limit of "Open Office Database Software" which our client specified us to use being he uses it at his office, however we improvised with a separate tick box for female and male. But overall we've created the main features successfully and is now waiting for our client's response and feedback.

Ada and I have finished photoshop tutorials, to try and help our skills in making the leaflet. We use a great site www.photoshopstar.com

Ada has collaborated all the emails that we had with our client into one document, the brief copyright exercise that we had to have completed and did a project planner on a week-by-week basis and completed our mind-map.

No comments:

Post a Comment