• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  32. 32
  33. 33
  34. 34
  35. 35
  36. 36
  37. 37
  38. 38
  39. 39
  40. 40
  41. 41
  42. 42
  43. 43
  44. 44
  45. 45
  46. 46
  • Level: GCSE
  • Subject: ICT
  • Word count: 4155


Extracts from this document...


Sukhjeevan Basra Centre Number - 20603 Candidate ID - 1016 GCSE ICT Database Project Part 1 - Introduction Statement of the problem Mr Gudi is a doctor who runs his own doctors firm. All the records for the patients are kept on manually. Looking for all the notes is time consuming and difficult to look for the notes. Also the notes take up a lot of space. Mr Gudi would like a system, which wouldn't take much space and would make it easier to find the records. Also Mr Gudi finds it hard to add new patients to the system through word processor, as it would take a long time. He would like it to be easier to find patient records; currently he must manually look through the database himself to find records for patients. Consideration of alternative solutions * The manual option is to keep the paper based system that Mr Gudi has at the moment. This leads to taking more time but is not very complicated. * A relational database created in Microsoft Access. This would allow me to create a database with relations between the data in different records. Queries would be simple. Chosen Solution The manual solution is not an option as Mr Gudi is not happy with he's existing manual system. The relational database would make the day to day running of the database far easier compared with a flat-file. I have decided to use Microsoft Access to create a relational database. In Microsoft Access you can run queries and generate reports easily. It is also possible to create a user-friendly Visual interface; this would be very good for Mr Gudi who has Poor Computer skills. User requirements 1 The database must be user friendly, with a user interface including Main Menus and Data Entry Forms. 2 The Database must be able to generate Reports and Mail Merge Documents. ...read more.


and ID 8 Report to show the patients in the database I expect to see a report produced showing all the patients in the database 9 Report to show the patients born before 1980 I expect to see a report produced showing all the patients born before 1980. Part 4 - Implementing List of printouts Design view of Table One Design view of Table Two Design view of Table Three Screen prints of Relationships I have enclosed 1 A printout of search for patients showing data I have entered 2 A printout of patients found showing data I have entered 3 A printout of medical information showing data I have entered 4 A printout of medical information after it has been sorted 5 A printout of one table where a record has been added 6 A printout of one table where a record has been deleted 7 A printout of one table where a record has been updated 8 A printout of the results of my simple query 9 A printout of a complex query to find Last check ups made by patients for 01/02/2006 10 A printout of a Linked query to show all patients visited after 22/01/2006 11 A printout of a report based on general check up on 1st February 12 A print out of a report based on patients born before 1980 13 A printout of a general report of every patient 14 A printout of the form based on search for patients 15 A printout of the form based on patients found 16 A Printout of the form based on medical information Step by step guide To put my data structure on to the pc I used a piece of software called Microsoft Access. I will describe to you step by step how I have done the coursework. Task 1 - Creating the Search for patient's database The first step towards designing the system was to create a table, which contained the patient's data. ...read more.


Describe any problems you had when creating & testing the database When I was creating the database I did come across certain errors. One problem I had was mail merging the letters from the database. I found it hard to find the data and to insert it in to the letter. But came over this problem and I mail merged the letters without a problem after. Another problem I came across when I was creating the database was when I entered the wrong data type for my 'Gender' column, I had choose 'Number' instead of 'Text'. To correct this mistake I had to go back to my design view and change the data type to 'Text'. User Feedback Mr Gudi had sent me a letter talking about the features of the database, I have enclosed the letter: Understanding Feedback I have read and understood the letter that I have received from Dr. Gudi. I agree with Dr. Gudi that I should have inserted another column name 'Phone numbers', which would have listed the entire patient's numbers. Also Mr. Gudi is having troubles understanding the report for 'patients born before 1980', I will have to go back and help Mr. Gudi understand the report. Mr. Gudi has also asked for a new column called 'diseases' this column will show if patients are suffering from any diseases. Part 7 - User Guide First thing we have to do is open up Microsoft Access from the start menu and selecting Microsoft Access: From here this should open up a new window, from this window I select the doctor's database: From this we double click on the Doctors Database and the database should appear: Pages Introduction - 1 and 2 Analysis - 2 and 3 Design - 4 to 11 Implementation - 12 to 64 Testing - 65 to 75 Evaluation - 75 to 78 User Guide - 79 to 81 Sukhjeevan Basra Centre Number - 20603 Candidate Number - 1016 AQA Database Project ?? ?? ?? ?? Sukhjeevan Basra ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Software essays

  1. Formal Report for Task3

    and having a suitable picture entered. The last document to be edited is the presentation which went from having one slide to having the rest of the information inputted. How I adapted the presentations I changed the background themes to make it more child friendly.

  2. Creating a Database Coursework

    Changing a record List some good reasons why Phones Your Way need to be able to make changes to customer records? Show a screen shot before changing the record Show a screen shot after changing the record Explain what you did to change the record Phones your Way will on some occasions will have to change records of their customers.

  1. Unit 4 Multimedia -Review for Product 1 KS3 Strategy Presentation

    seen as something little children do, it looks unprofessional and so there's change again for the parents to actually loose concentration. Colour, text and information The colours used in this presentation is very limited. In this presentation, the background colour is a pale green patterned colour.

  2. Documentation of a database for a sports centre.

    , Number * Member on Site - Text Field name Example Data type Length/ Properties Validation Description Title Miss Text - Can either be "Miss", "Master", "Mr" or "Mrs" Forename Julie Text - Member forename Surname Smith Text - Member surname Membership number 4720 Auto number 4 unique Key field

  1. Database design for a games shop.

    Lastly I think having foreign keys is not enough in the rentals form. It would be more helpful if you could insert the name of the customer from the members table into the rentals, this will help me verify customers information.

  2. Testing database. Test plan 1 I am going to check my data restriction. ...

    relationship created In this screen shot I have also checked my relationship and it also shows that emirates have only bought on product from external table Test plan 10 In this testing I would be adding in a invalid data, this would show If added an invalid the system wont recognize the system.

  1. Reviewing different multimedia presentations.

    people who are using it and some sound effects would help this. The second not so good feature with this Multimedia Presentation is that some of the links don't work from the section where you are putting in the body parts in her is a section which says for example

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    Step 11 Following that, I copied and pasted the two tables and pasted them next to the "reading" table; these two new tables were for "Writing." I then changed the scores for each term; fortunately all my functions were correct so they changed the values automatically.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work