• 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. Peer reviewed

    How to use a database

    3 star(s)

    A finished Report Queries Queries are used to find particular data you don't know all of the information for. E.g. you want to find customer number 25 but you don't know their name. Or you want to find a Mr.


    Both of these packages seem to be built to make it easier for you and these fantastic packages are: * Adobe Dreamweaver CS3 * Xsite Pro The only thing I would say lets it down for Adobe Dreamweaver is its price at the minimum of �399 which is hardly a

  1. AQA GCSE ICT Specification B

    Many people can use the system at once. The system is cheap to set up. Little space is needed. The system can be backed up. Data is difficult to move around and alter. Human error could ruin the system by altering a formula. Microsoft Excel Apple works Corel Quattro pro Linux Planmaker Solution 3 - Database Software Solution Pros Cons Software Imputing and exporting data is very easy.

  2. In the following report, I will describe, using screenshots, the advanced features of Microsoft ...

    I would simply click on the auto filter in the 'Full/Part Time' column and select 'F/T' to hide all the part time employees and the data would then be displayed as shown below. I created this feature by selecting 'Filter' from the 'Data' menu and then clicking on 'AutoFilter' (shown below)

  1. Youth Club Database Solution

    database, and also good for inexperienced Users of the program to be able to use the database, and get to grips with more complicated aspects of the database. These next screen dumps show how I set the Front End up and how it works The first stage is to bring

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

    However the not so good features is that suitable animations could actually help parents to lose concentration. They might be too colourful and inaproppriate, in other words, too childish.There were no drawn or computer graphics, the good side for this is that computer graphics, whatever the information might be, is

  1. Documentation of a database for a sports centre.

    11 numerals) , Number * Medical Problems (e.g. asthma) , Text * Date Member Joined - Validation (e.g. should fill in the following with only numerals _ _/_ _/_ _) , Number * Expiry Date - Validation (e.g. should fill in the following with only numerals _ _/_ _/_ _)

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

    To check If my query works I have crossed referenced from the external product table and in the screen shot below it shows that only two products lie within the range Testing plan 8 Now I would be carrying out my testing on my criteria which I have set upped.

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