GCSE Database Project ICT

Management)

Print speed

Black text A4 Up to 37 ppm (Fastest), 25 ppm (Business quality)*

Colour text A4 Up to 20 ppm (Fastest), 11 ppm (Business quality)*

Photo 10x15 cm Approx. 49 secs*

I recommend this computer as all of the specifications noted are relevant as the surgery has a large amount of files to manage mange and handle which would depend on the processor, Hard Drive and RAM. The RAM and Processor are suitable for running Microsoft office suite. The processor is apt for handling many applications at once; The Hard Drive is sufficient to store many files (patient’s records, etc.) ; The RAM is necessary as it aids to quicker use of the computer. I have chosen to use Windows XP OS as it runs efficiently without any known major bugs or errors but, if necessary, the computer could be updated. The monitor, which comes with the computer, is a Widescreen and will be able to display all relevant program information. The printer is suitable as it is quick easy and efficient which is paramount for outputting data for the patients.

Data collection (Source data and identifiers, with details of input method, validation and key identifiers)

Patient’s data

The patients Data will be retrieved from the hard-copy format of the patients records. The Secretary then manually adds them (or scans them in). Data can be edited by word of mouth where the patient is informing the secretary that there is a change of address she could tell the secretary the new address. When the receptionist inputs the data, she visually checks the record for any spelling errors (such as a misspelt road name) the she then asks the patient directly if this is the correct address.

Staff Data

The staff’s data can be inputted from their information sheet also, it can be imported from DENlist, which has all of the local dentist’s information. Nurse’s information can be in hard copy format or inputted from the referring University (where the nurse dentist or technician studied). This is checked by referencing with the member of staff and validating that the inputted data entered about the person is completely correct else legal implications may arise.

Data Flow Diagrams showing data sources, processes and destinations

Add/Edit Data

The User wants to add, edit and manage data to be able to put into the database file. Access will be opened and the database file will be opened. The input form will be opened and the data will be entered as written on the form. The data is entered via two ways typing and mouse drop down menu select. The data is then checked on the screen via the form and re-checked with the patient and any corrections made. Then it is saved (to be later backed up on a memory pen drive). If the data is to be edited the secretary writes down (on a piece of paper) the data that has to be edited, such as a telephone number. The secretary then runs a search query of the patients name and to edit the field allocated to change it. The edited data is then to be checked on paper and with the patient.

Mail Merge

The file will be manipulated before it gets send into a mail merge. First a Query search will be formed where the specifications of this query are that the patient has the last appointment more than 6 months ago, The query will be run, checked with the query fields being Patient Name and forename date of last appointment (including a sub-form which calculates the exact amount of days the patient has not had an appointment) the query will be run and search results found these are then inserted in to a report to which the receptionist can ‘tick‛ off then the secretary will save both the report and the query. The report will be printed out and the required fields checked for any errors then Word will be opened. A letter template will be made for the reminder letter which contains spaces for the data of the patients name(s) the date of last appointment (including sub-form) and contact details and then link the previous query to the word document, input the fields and check the valid fields have been inputted. The links are inserted and checked (using print preview or any other means) and then the letters are printed off to be sent.

Multiple Table Search Criteria

The secretary needs to do a cross table search to find people who have had a filling and search dates of 3-5 years ago who have had a gold filling the database file will be opened and a multiple search criteria will be started and a report is made with the relevant fields on. The report is saved and printed and the Mail Merge is created and the query results linked with word (having the template already completed) the relevant information.

---

Fields Required, searches, sorts and reports that will be needed

Fields

Searches

The searches needed for this will be the search for patients who have not booked within the designated time so a query will be needed to enable the search I will need to search upon the appointments table, under the appointment date and as I want to search for dates which are not stationary I shall use an algorithm that uses data from today’s date (“Now()”) I think that “>Now()-365 And <Now()-180” would be suitable to find all people who have booked between 6-12 months.

Another search enables the user to search for specific patient detail, as this is not a fixed value; (naturally, as people do not have the same name) I assume a query with variable parameters would be adequate and should cover the patient forename and patient surname and the user should type in the value and the search will bring up the patients details

The last search will look for children of a specific age and will do a search within the Date of Birth field to search for patients and I assume the best search would be “<#01/01/1995# And >#01/01/1986#” as it would pull up people aged 12 to 21 this is the suggested age for children to have braces.

Report

The only report needed is the report for the secretary to tick of people who have rebooked. It consists of the patient’s title, Patient’s forename, patients surname and telephone number, as it only needs these fields. The receptionist will tick off the patient’s name after he/she has rebooked to the surgery’s standards. The telephone number is required for if the person does not rebook, by means unknown (e.g., letter sent to old address) then the receptionist calls the number that the patient provided and can ask directly if they want to rebook over the phone.

Alternative methods of output considered (e.g. screen print, speakers)

Display (on Screen)

There are many alternate methods of how the data on screen can be displayed to the user and the secondary user. The information can be displayed on screen, e.g. the patient needs to check when multiple appointments are due and what time the appointments are. The secretary then searches the criteria of the patient and then can show the report of appointments to the patient who then will know when his/her appointment is.

Spoken (Word Of Mouth)

The Patient is telling the secretary that there is a change of address and that instead of living at ‛12 Honey Bourne Way, Willenhall, WH1 9BP‛ he now live at ‛44 Manor Road, Walsall, WS2 9PU‛ this information is inputted as the patient speaks.

Printed

The information can be displayed in a hard copy printed format, as the secretary needs to print out a report for the mail merge information. Therefore, the secretary does the query for the patients due for a check up and prints out a report, which has all of the information on where the secretary has the ability to check to see if the patient has booked and / or replied.

Choice of output method justified

My preferred and most used method of output will be printed as many appointment slips will be printed out for the patients to refer to and many reports will be in use for the Mail Merge information also queries will be run in which, the file will be printed out to check the information is correct and valid. Also in printing, the file out it makes it easier for people to view and edit data as having a hard copy of the information people can add information, which can then be added on the file itself.

Backup strategy identified

The Patient’s records will be backed up onto a set of six memory sticks, which will be carried and stored in separate places.

Memory Stick 1 – Monday – Kept in the office in a safe box.

Memory Stick 2 – Tuesday - Kept on the Dentists person.

Memory Stick 3 – Wednesday – Kept On the Secretary’s person.

Memory Stick 4 – Thursday - Kept next to the computer for immediate backup.

Memory Stick 5 – Friday – Kept at Dentist’s house

Memory Stick 6 – Saturday – Kept at secretary’s house

The memory sticks will have a paper label covered in plastic (to prevent wear.) and will be dated for the allocated day. This prevents precious data being lost in accidental damage (e.g. fire, flood). The file will be backed up using the facility found in the office suite under File>Backup this will prevent any compatibility issues which can arise within the constraints of the system.

Security strategy (e.g. password) explained

The computer will be marked physically with ‘Property of the NSDAP‛ in both visible and invisible markers to prevent theft. The computer itself will be bolted to the table and the table bolted to the floor. The Computer will have password encryption and encryption on the ‘hidden‛ administrator’s account (accessible through safe mode).

The file will have its own encryption (a.k.a. a password) which will increase the security. The computer will be situated in a room with barred windows and the only entry into the door is a code locked however, there is another door, which is alarmed, as it is a fire door needed for safety reasons.

Design (9 marks)

Initial designs of input forms

Situated after this page.

Menu Structure diagram

User feedback on initial designs (comments, letter or questionnaire results)

Situated after this page.

User feedback on initial designs (comments)

1. On the first design of the ‘Menu’ form the user commented that on the command buttons the text within was inappropriate and should be changed to ‘Go to Patients Form’ (A change of the word Table to Form).
2. On the same design, the user wanted the two buttons entitled ‘Go to appointments Table’ and ‘Got to Treatment Table’, To be removed as they would be incorporated within the other two forms.
3. There was an issue to the title of the form as the initial ‘Menu’ was updated to ‘NSDAP Menu’.
4. Buttons were missing to enable the user to edit patient details and other requests quoted within the quantitative objectives.
5. On the patients form the fields were not spaced out making use difficult.
6. Missing fields ‘ID’, ‘County’, ‘Telephone’.
7. Missing Command Buttons
8. Sub-form missing.
9. Staff Form Gaps necessary.
10. Missing ‘Staff ID’, ‘Title’.
11. The field ‘Telephone #’ was incorrectly named, re-name to ‘Emergency Telephone Contact’
12. Sub-form Table.Patient Information Missing
13. Inappropriate field names: (Staff) Forename, (Staff) Surname, (Job) Title. (Note: text in brackets is the correct addition to it.)

Final design considers user comments

The final designs are situated after this page.

---

Table structures and relationships defined

---

Relationships

The above diagram shows the relationships of the tables, which spawns from the Staff Information Table as one Member of Staff, can have many patients, which in turn can have many appointments. The treatments can have more than one appointment attached to it, this enable the use of the same treatment on a different appointment.

Form designs sketched in detail

Menu

 

The boxes in red are the buttons, which are featured in the initial design.

Patient Information

At the bottom is the sub-form, which contains the appointments of the patient allocated.

Staff Information

At the bottom is the patient table, it lists all the patients each member of staff has to deal with.

Queries explained in detail

Appointment Query

Query 1 will be to search on the appointments table, under the appointment date and as I want to search for dates which are not stationary I shall use an algorithm that uses data from today’s date (“Now()”) I think that “>Now()-365 And <Now()-180” would be suitable to find all people who have booked between 6-12 months as access treats dates as a mathematical figure not as the standard calendar.

Patient Query

Another search enables the user to search for specific patient detail, as this is not a fixed value; I assume a query with variable parameters would be adequate and should cover the patient forename and patient surname and the user should type in the value and the search will bring up the patients details. So, square brackets [] will be used to tell access that a parameter query is required within the brackets is the text you wish to appear in the parameter entry box. (E.g., [Please Enter Value])

Patient Query1

The last search will look for children of a specific age and will do a search within the Date of Birth field to search for patients and I assume the best search would be “<#01/01/1995# And >#01/01/1986#” as it would pull up people aged 12 to 21 this is the suggested age for children to have braces.

Subtasks identified

Open .accdb file (Access)

Create Table

Enter Fields         Enter Field Variables         Save

Open Table         Enter Data and Check

Construct tables

Create relationships         Check relationships        Save

Create forms

Link to tables

Construct queries         Test queries                 Save

Create Report for Query        Test        

Link queries to forms

Mail Merge For appointment Query         Create        Save

Mail Merge For Children Braces        Create        Save        

                        Save

                Check Save

Completed

---

Test plan of up to 20 tests and expected results

---

Implement (12 marks)

Brief description of how the design was implemented explaining any changes that were made to the design

First, the tables must be designed first we create a table so first we click ‘Create table in design view’ like this:

Then a new window opens where you input field names and types:

Then the fields described on the initial designs and reinforced again in the final design. First, we select the primary key, which has to be an auto number, as it must not replicate figures within the same table, as it is a reference field.

This is a screenshot of changing the field type to an auto number.

Select the primary key, as it is the reference point of the relationships

Then we need to create a lookup field, we do this using the ‘lookup wizard’. At the bottom of the drop down list is Lookup wizard, once clicked brings up this wizard menu box.

First, click the second value ‘I will type in the values I want’. Then click ‘next’.

Type in the variable drop down choices.

The final page is just informing you that you can name the drop down box; however, this will not be necessary, as we not be using macros, which reference to the drop down box.

Then click finish and the lookup will be completed.

Then we will create a text field, which will need the field length changing.

Changing this value increases or decreases the length of the field.

Then a date field will be inserted and an input mask will be inserted, we use the ‘input mask wizard to make/generate these lookup restrictions.

First, select the type of field, which, for date of birth, will be a short date field.

Then the wizard informs you the mask, allows you to be able to edit the mask to your specifications, and allows you to test your new input mask.

After the input mask you have entered is validated and checked, you click next and this page appears:

Then click ‘finish’

Repeat again for the other tables, as the other fields are not too dissimilar

The table fields are then constructed and they look like this:

This is the appointment table with the field types on display.

This is the Patient table with the field types on display.

This is the Staff table with the field types on display.

This is the Treatment table with the field types on display.

The data then has to be entered into the tables inserting all of the relevant data the tables will then look like this in datasheet view:

Patient Table

Staff Table

Appointment Table

Treatment Table

Relationship Creation

First, click the relationships button under the ‘Database Tools’ tab.

Upon clicking it, you then are taken to this page, where the table previously made are shown in a concise way.

Now, referencing back to the table initially drawn up of the relationships (shown below)...

... we want to create a link from the ‘treatment’ table to the staff table making the ‘Treatment ID’ on the ‘Treatment’ table the reference and the ‘Treatment ID’ on the ‘Appointments’ Table the referee, which has to source from the treatment table as it is the Primary Key. To make this we click on the reference (‘Treatment ID’ on the ‘Treatment’ table) and drag onto the field we want to create a relationship with (‘Treatment ID’ on the ‘Appointments’ Table) this will cause a system generated pop-up box to be generated, in which we specify the type of relationship.

 

We want to have referential integrity, as it prohibits incorrect values not found in the reference field, so after the ‘Enforce Referential Integrity’ Checkbox is selected the ‘Edit Relationships box look like this:

We then want to click ‘Cascade Update Related Fields’ as that allows other fields to be updated from related counterparts then create is selected:

Then our relationships page is updated with a new link:

We then check to see if the link is correct and in this case, it is, as one treatment can have many appointments attributed to it, and each appointment can only have one treatment, which is logically correct.

This is repeated for all of the above making sure the tables are joined in the direction displayed in the design and the final product will look like this:

This is then checked to see if the relationships are logical: One member of staff can have many patients, one patient can have multiple appointments, and each appointment can only have one treatment.

Menu Form

First, I selected the create tab, and then selected ‘Form’, which took me to a screen such as this:

Then, on the home tab, I selected to go into ‘Design View’, which took me to a screen like this:

I then pulled the ‘Form Footer’ down to enable me to draw button functions:

I then selected the Title, and edited to ‘NSDAP Menu’

Then the buttons are drawn in. When the buttons are drawn in, Microsoft Command Button Wizard appears and you select the buttons purpose, this button shall open a form:

After selecting the specifics, click Next and we are taken to this page where you select the form you are going to link to:

Click next again and you will be taken to this page, select ‘Open the Form and Show all The Records’ as the other option tries to create another relationship.

We then select the button’s name, or select some system graphics; here I am going to label it ‘Go to Patient Form’:

Final step to making the button is naming the command; however, this is not compulsory, so I am leaving the text allocated by Microsoft.

This shall bring you to your form with the newly created buttons as thus:

Repeat the previous process of adding the buttons until all of your chosen links are added. Then it will look like this:

Then view the menu form in ‘Form View’ and it is completed.

Patient Information & Staff Information

The Patient and staff information forms are alike in construction,  so I am going to show you how the patient form was created with the assumption that you can relate the same functions with the Staff Information Form.

Select Split Form.

As Microsoft 2007 is updated, a new feature it has is to display a table, which is linked via the relationships, and so it brings you to this page:

As you can see, most of the laborious work has been automatically generated within the wizard however, some editions must be made.

First, we go into design view, which is documented prior, and you will be returned with a screen like this:

We then change the height of the boxes to make them uniform:

In addition, the width of the boxes covers the page so they should be shortened to look aesthetically pleasing:

Then we move the sub form at the bottom upwards, flush against the Staff ID field and check the borders of the form.

Finally add control facilities to the form to enable inexperienced users to partake in the facilities.

Now view the form into ‘Form View’ this will enable you to ascertain a view of how it will look to the user. Like this:

Screenshots of forms and menus

The menu, where all sections of the database can be accessed.

This is the patient information ‘form’ where the patient’s details can be stored viewed and edited.

The Staff information Form, stores details of the staff and details patients the member of staff is directly affiliated to.

Now we must check to see if the form created are linked to the tables and the only way is to reference it from the data table for this test I shall use Patient ID 3 and Staff ID 2 for this test.

Patient ID 3

First, we check the value on the datasheet:

Here, we can clearly see that the data inserted into Patient ID 3 belongs to:

Patient ID: 3

Title: Mr.

Patient Forename: Martyn

Patient Surname: Johnson

Gender: Male

Patient Address 1: 27 Walsall Road

Patient Address 2: (BLANK)

Date of Birth: 07/10/1992

In addition, his appointments are:

Appointment ID’s: 15, 14

Treatment ID’s: 3, 2

This will be sufficient enough to see if the data found in the form is accurate.

We open the form and check Patient ID 3:

Moreover, the values match up exactly.

Staff ID 2

Again, we check Staff ID 2 and the results are:

Staff ID: 2

Title: Mr.

Staff Forename: Bob

Staff Surname: Jones

Job title: Dentist

His patient list goes as such:

Patient ID: 4, 7

This shall be enough information to justify the link.

We open the staff information form and check the values:

These values are correct, this is justifiable proof that the table have full linked to the form.

Queries

Now, to make the queries. First, click ‘query wizard’ upon the create tab:

It could be created via the ‘query design’ button however; the wizard is much easier as it performs the laborious tasks quickly and easily. After the button has been pressed a system generated wizard box appears, we only want to create a simple query so the top choice is selected and OK is clicked:

Now you are brought to this page where the query fields have to be inputted:

Now appropriate fields are chosen, following the guidelines set in the design section, and then the fields are inputted. I have chosen the fields necessary to identify a person and send them a letter referring them to their dentist, which leaves the form looking like this:

Then click next.

We then enter a name for the query (Appointment Table Query is suffice) and click finish.

Then, under the ‘appointment Date’ field, change the Total tab from its initial value, (Group By) to Max, this will show the last value given in that query/field.

Then in the criteria tab enter the value: >Now()-365 And <Now()-180

This is a formula where the value “Now()” is today’s date, fortunately as dates are stored as mathematical functions you can perform equations upon it, and thus manage to create searches which search for dates ‘X’ amount of months ago.

The query that checks the age of the patient to see if they a valid for braces, which is the same but instead it checks the ‘Date of Birth’ Field on the ‘Patient Information Field’. However, a screenshot has been included to enable you to view the specifications:

However, the query which searches patients information specifically to enable the user to edit the patient information. For this, a parameter query must be created.

Firstly, we create the query and insert the fields none too dissimilar to the previous query, giving you this screen:

Then in the patient forename field and the patient surname field we shall put in parameter searches, to do this the use of the square [] brackets is necessary. Within the brackets, you enter the text you wish to appear within the value input boxes in the patient forename field “[Enter Patient Forename]” and in the patient Surname Field “[Enter Patient Surname]”, leaving the fields looking like this:

When the query is run, it produces data entry boxes:

When the data is inserted, it checks the value within the table and brings up the relevant record.

Reports

As the secretary wishes to have a check sheet to see which patients have re-booked, a form must be created.

Firstly, click ‘Report Wizard’ under the reports tab:

Then a system generated pop-up box shall appear enabling the user to select the fields the secretary can use from the query.

I have selected fields from the appointment table Query, which are:

Patient Information_Title

(MaxOF)Patient Forename

Patient Surname

Telephone

Staff Information_Title

Staff Surname

(MaxOF)Appointment Date

These fields have been chosen as they provide sufficient information for the receptionist to telephone the patient and request a booking and the staff name has been inserted to enable the receptionist to inform the member of staff of any relevant information. The Appointment date field has been inserted to allow the receptionist visual data to be able to see how long the patients has not re-booked.

After selecting the fields of the report, you are taken to a page where you can edit the order of the fields.

However, the aesthetics of the report will be modified later. Upon clicking next, you are taken to this page:

However, no changes need to be made at this point.

Upon clicking next, you are taken to the next page where you can modify the layout of the report; tabular has been chosen as it is only a list the receptionist wishes to tick off. Portrait, to enable all of the overdue patients to be visible and the final checkbox checked to make sure that the maximum space is used efficiently:

Next, you choose the font scheme, for this report I want something plain and simple so the Office 2007 scheme has been selected:

The final page allows you to name the report, I chose to use the name provided automatically and selected that I wanted to edit the reports design:

Once finish has been clicked, you are taken to this page:

After the fields have been resized, we then check to see if the data is displayed correctly within the report in ‘Report View’.

On the following page is the printout of the report for the secretary.

Mail Merge

The mail merge was created using a wizard:

Then, on the right, we then select the options given to use by Microsoft Word’s wizard:

After clicking next, you are taken to step two where Word can implement its templates:

We then select a template provided in word:

Then click ‘OK’.

The document is then updated to this state:

We then choose the data source by clicking browse...

...and selecting the directory of where the database is situated:

After selecting the database file, all the objects that can be merged appear:

 

We then select the Appointment Table query, as it is the query we wish to merge.

Check the fields within the SQL connection:

 Then the letter is written, leaving the document looking like this:

Then we must attach the database fields into the address block and the other standard letter merge fields, we attribute the Access field to the Word Merge field and click ok:

Then the address block is checked to see if the allocated fields are correct:

After the address block has been allocated, you need to do some formatting and left justify the address block it would look like this:

After this page is a printout of the letter with the raw merge fields and following it, is the letter with the merge fields inserted and formatted.

<<_FIRST0_>><< _LAST0_>><< _SUFFIX0_>> <<_COMPANY_ >><<_STREET1_ >><<_STREET2_ >><<_CITY_ >><<_STATE_ >><<_POSTAL_>><< _COUNTRY_>>

{DATE \@ “dddd, dd MMMM yyyy” }

Dear <<Patient_Information_Title>> <<Patient_Surname>>,

I am writing this letter to remind you that you have not booked an appointment with the NSDAP for 6 months; we recommend that bookings must be kept at regular 4-month intervals. Our records show that the last time you booked was on <<MaxOfAppointment_Date>> please update your appointment with <<Staff_Information_Title>> <<Staff_Surname>> as soon as possible.  

Many thanks,

Jack Bate        

NSDAP

        Karen Bate

34 Camp Hill

Walsall

WS28 4NG

West Midlands

3/27/2009

Dear Mrs. Bate,

I am writing this letter to remind you that you have not booked an appointment with the NSDAP for 6 months; we recommend that bookings must be kept at regular 4-month intervals. Our records show that the last time you booked was on 26/9/2008 please update your appointment with Ms. Brown as soon as possible.  

Many thanks,

Jack Bate        

NSDAP

Kids Brace Mail Merge

The kids brace Mail Merge, is constructed identically as the previous mail merge. After this page is a printout of the letter with the raw merge fields and following it, is the letter with the merge fields inserted and formatted.

<<_FIRST0_>><< _LAST0_>><< _SUFFIX0_>> <<_COMPANY_ >><<_STREET1_ >><<_STREET2_ >><<_CITY_ >><<_STATE_ >><<_POSTAL_>><< _COUNTRY_>>

{DATE \@ “dddd, dd MMMM yyyy” }

Hey! <<Patient_Forename >>!

According to our computers, you are eligible for the fitment of braces. Please can you come down to the surgery and chat to Dr. Bragg, our orthodontist to start the initial proceedings of the fitment of braces.

Dr. Bragg will be available for appointments from 3/6/2009 and we look forward to seeing you!

See you Soon!

Dr. Jack Bate

NSDAP

Martyn Johnson

27 Walsall Road

Walsall

WS2 8YT

West Midlands

Friday, 24 April 2009

Hey! Martyn!

According to our computers, you are eligible for the fitment of braces. Please can you come down to the surgery and chat to Dr. Bragg, our orthodontist to start the initial proceedings of the fitment of braces.

Dr. Bragg will be available for appointments from 3/6/2009 and we look forward to seeing you!

See you Soon!

Dr. Karen Bate

NSDAP

---

Evidence that each test in the test plan was carried out comparing actual results with expected results

---

When errors occurred, explain how they were corrected

A link within the database could not find the source as it was on external device.

Change the directory and encapsulate it within “” marks.

The relationships between two tables will not work, as the two fields that I am attempting to create a relationship with, are both autonumbers.

Change the field type from Autonumber to number.

Re-make the relationships without any hassle.

Evaluate (5 marks)

Each original objective fully evaluated. Comments on how well the objectives are fulfilled.

The user needs to search and print patient information for a reminder letter to be sent out to remind patients who have not booked for 5 to 6 months prior.  This task has been successfully fulfilled. In the letter, it contains the patient’s reminder date, Title, Past Treatment Description, Forename, Surname, Address (Town and Postcode) and to print out a report to enable the user to ‘tick‛ off the people who have re-booked. However, the only problem that I have is the query brings up all of the previous appointments.

The user needs to search for specific patient’s details to be able to add, edit or delete the information for the one record and to be able to search the patient’s details easily. This is fulfilled as the query contains two parameter values.

The final quantitative objective runs well with no errors, as it is a simple value search query and brings the wanted results.

A critical Comment on anything that you think could be improved

The query results in objective 1 clearly does not work efficiently as it brings up previous appointments both completed and un-booked.

The forms do not have the logo of the surgery, which is still to be generated.

The interface the user uses is too large for the screen and the user has to constantly keep scrolling down to relevant data.

User feedback in the form of a letter or questionnaire.

Letter Enclosed After This Page.

Jack Jones

44 Manor Road

Walsall

West Midlands

WS2 9PU

Friday, 24 April 2009

Dear Jack,

I am writing this letter to thank you for your expert construction of the surgery’s database. However, a few more additions would make the database as efficient as possible for the Surgery. Firstly, a friend of ours, who is also a sign writer, has offered to construct a sign with a logo, can you please insert the logo into the forms, to embellish the company within the database. In addition, have you found a way to correct the error with regards the 6-month reminder, as staff have found it slightly annoying to be sifting through all previous appointments.

Those are the only additions I feel are necessary at this stage.

Many Thanks in Advance,

Dr. Jack Bate

NSDAP

Evidence that you understand the user’s comments by making suggestions for future improvement

The logo will be inputted in place of the system-generated image, the query will be rectified to only display the last result.

A calendar will be inserted to enable the secretary to be able the receptionist to view all sections of the appointment field.

All previous data entries (in terms of appointments) will be saved to a separate database labelled ‘Archive’.