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

Project 1-Database

Extracts from this document...

Introduction

Identify Background Mr Olusola is a pharmacist at Gbayomi Pharmacy. He sells and prescribes different drugs and keeps a record of all the prescriptions and when they need to renew their prescription. However, no matter how accurate and well organised his records are, he cannot easily get enough information out of the customers in time for their next prescription. For example, it would be useful if the renewal of their drug prescription was as a date as well as the day the drug should run out (providing that the customer has been taking his recommended daily dosage). Mr Olusola would then be able to send a letter to the customer whose next prescription is due using mail merge. It is often very time-consuming to manually write the letter and often unprofessional. Problems with the Current System 1. It is quite difficult to update a record using a manual system as the customer may change there phone number or move to a different address. Excel spreadsheets, user information is put into tables so the records are likely to lack consistency. It can also be quite problematic if there are several duplicates of people's details in our records if the person is on more than one prescription. 2. Another problem is that it takes to long to write a letter to the customer to remind them that they need to collect and pay for their next prescription. This is often too long too slow and often unprofessional. 3. Errors often occur when Mr Olusola is trying to calculate the cost of the transactions. This can cause inaccuracies and could cause problems for the transaction of the drugs. There is also the possibility that the customers will end up paying too much or too little for their prescription. 4. If someone has a very complicated name, there could many spelling errors this could cause embarrassment for Mr Olusola and could upset customers. ...read more.

Middle

Report: Supplier's Contact Details Test 8: Enter the number '01046291176' in the query 'Search for customers by post code' Test 9: Enter the name 'Trolovol' in the 'Prescription in Stock' Query Test 10: Enter the supplier name Equinox Ltd in the 'Stock over �15' Query Test 11: Open the report: Customer's Details Test 12: Open up the form 'Switchboard' Test 13: Macro: 'Forms' on the switchboard Test 14: Macro: 'Queries' on the switchboard Test 15: Macro: 'Reports' on the switchboard Test 16: Macro: 'Letters' on the switchboard Test 17: Macro: 'Close Menu' on the switchboard Test 18: Macro: 'Exit System' on the switchboard Analyse Hardware & Software Hardware- I am going to use the following hardware: * A PC (in terms of a computer, mouse, keyboard, monitor) - I am using this because as one is creating a database; one needs to use a computer if one wishes to create a sufficient database. A simple, hand drawn database would be inadequate and time consuming. The data, via the keyboard will be inputted using this system. * A colour laser printer- I am using a toner-based colour printer rather than an inkjet colour printer because inkjet printers are far slower than laser printers and have the disadvantage that pages must be allowed to dry before being aggressively handled; premature handling can cause inks (which are adhered to the page in the liquid form) run. * A black laser printer- Again I am using a toner-based printer rather than an inkjet printer because inkjet printers are far slower than laser printers and have the disadvantage that pages must be allowed to dry before being handled. Furthermore I am only using a black and white printer where colour is not mandatory. Software- I plan to use the following software: * Microsoft Access - Relational databases in access are far more efficient and are at a higher level of class than flat file databases in Excel as they allow you to store, edit, add, remove, search and sort data. ...read more.

Conclusion

IV. There are three reports to show the customer's address and contact details, supplier's contact details and the prescriptions which are overdue. V. There are five queries to search for customers by telephone no, to show overdue prescriptions, prescription in stock, stock that is over �15 (with a given supplier) and supplier's details (by entering their name) * IMPROVEMENTS: * The system could be developed to initiate a monthly warning system of which triggers the automatic updating of data to begin the month. The system would sort out customer and supplier details in case of changes in certain details which have not been currently recognized using another database as a source. There would also be a button to add and sort the details of new suppliers and customers who came during the month. * In the customer, prescription and supplier form the system would automatically reorder the records in numerical order with the details every time a new record is added. This would be unproblematic. Address: 12 Kologhial Way LONDON SW12 7JK Tel: 08007383773 Fax: 08009465787 E-mail:GbayomiPharmcy@hotmail.co.uk Monday, January 11, 2010 Mr Sean Okundaye 12 Kirtley House Thessaly Road London SW8 4XX Dear Mr Okundaye, Thank very much for your database. Because of you we at Gbayomi pharmacy can sort out our records with ease. However there are is a suggestion that I would like to give to you if that is ok: * The system could be developed to initiate a monthly warning system of which triggers the automatic updating of data to begin the month. The system could maybe sort out customer and supplier details in case of changes in certain details which have not been currently recognized using another database as a source. There could also possibly be a button to add and sort the details of new suppliers and customers who came during the month. I do hope you take this suggestion into account. Do not hesitate to contact me. Yours sincerely, Olusola Gbayomi ?? ?? ?? ?? Sean Okundaye Mr Graoui ICT Coursework ...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 ICT Systems and Application 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 ICT Systems and Application essays

  1. Different types of technology How I use ICT at home and at school

    The computers also are connected to a couple large multiple terabyte hard drives. One of these drives all store personal data and it has been divided to give a quota of 100MB per each computer. This gives enough to store all our work without needing to store unnecessary unrelated objects,

  2. ICT PROJECT

    Sheet 2-Enter Marks This system will contain list boxes, Vlookups and input boxes which will enable the user to choose each student personal details, enter assignment marks and maximum marks. The assignment and maximum marks will have an input box that will enable the user to enter the individual marks, which will be locate to a certain student.

  1. ICT Report 2b: ICT in Organisations

    However, Boots is not interested in this because the staff is not complaining. All in all, Microsoft Word helps Boot's because it allows for the paper work for the R&D Department to be handled easily.

  2. I will design a new video database for the video shop that will also ...

    Delphi Advantages * Allows participants to remain anonymous * Inexpensive * Free of social pressure, personality influence and individual dominance * A reliable judgment or forecast results * Allows sharing of information and reasoning among participants * Conducive to independent thinking and gradual formulation * A well-selected respondent panel -

  1. Database Analysis and Database Design Project - DVD library for moving images.

    RETURN DVD RETURN YES MESSAGE BOX COMES UP LOANS / RETURN DVD RENTED YES MESSAGE COMES UP LOANS / RETURN FIND RECORD YES MESSAGE BOX COMES UP LOANS / RETURNS MAIN MENU YES EXISTING LOANS NAVIGATION BUTTONS YES EXISTING LOANS DVD RETURN YES MESSAGE BOX COMES UP EXISTING LOANS DVD

  2. Computer project Alevels

    VGA - 64 MB Video Graphics Array Reason - Higher VGA memory is not needed for the proposed solution since graphics does not play a major part in the system. Enables the proposed system to work properly along with its applications. Healthy for eyes and also cheap.

  1. Datalogging project. Objectives 1. Measure temperature 2.Measure light intensity 3. ...

    You have approximately 4 working days. This time can't be exceeded. You should have done any necessary error checking before the system can be introduced. You are the person in charge for this project and the person responsible to make sure that the estimated time scale is not exceeded."

  2. Computer study project outline - library and book club database.

    Search a Book will solve the problems that a librarian face and also help students and teachers to share their knowledge about books. With this you can explore new territory, gather information, and expand your mind. As knowledge is power; and power is best shared among readers.

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