• 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. Analysis section for database project based on a hotel booking system

    The database application package I will use for this project is Microsoft Access. This is because I have had lots of experience using this application package and also, it is the one available for me to use in school to carry out this project.

  2. 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.

  1. The aim of my project is to make the task of the allocation of ...

    Also the use of cell protection on the cells which contain the data for the calculations, such as the prices for the various shows, are protected with cell protection which prevents the user from incorrectly editing the data inside the cells.

  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.

    much information such as the title of a customer, it would be very easy if I had just three choices to make which are Mr., Mrs. And Miss. Also field lengths are too long, you can see where I am going so I would appreciate if you could make appropriate measures.

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

    Then I hit enter my results could be seen below. My result show that 1 record in customers table now I need to be cross checking from the customers y results from my external table. I would be checking it from the external table as it would also display my

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