• 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
  49. 49
    49
  50. 50
    50
  51. 51
    51
  52. 52
    52
  53. 53
    53
  54. 54
    54
  55. 55
    55
  56. 56
    56
  57. 57
    57
  58. 58
    58
  59. 59
    59
  60. 60
    60
  61. 61
    61
  62. 62
    62
  63. 63
    63
  64. 64
    64
  • Level: GCSE
  • Subject: ICT
  • Word count: 13682

Database Hajj&Umrah travel agency

Extracts from this document...

Introduction

DATABASE PROJECT ANALYSIS Identification THE PROBLEM In the past few weeks there have been a few complications and problems with the database in the Hajj & Umrah travel agency called Elkadi Tours. This is the problem that the manager at the agency in Central London has approached me with. These agency chains have been running for roughly fifteen years and this particular agency has been running for ten years, with hardly any complaints. The manager, Mr. Osman Yusuf has suggested that I make a database, which could hold all of the various parts of the information needed for everyday applications for various visas and tickets. There have been various problems concerning ticket and visa application. This is what I am here to try and sort out. The problem is becoming quite serious now and the respectable agency chain is starting to lose business because of the businesses faults. At the moment, the chain is using a filing cabinet, which is not a very good idea because people cannot read each other's writing and then the staff are trying to book tickets when that particular airline is fully booked or visas have been re-applied for this is becoming time-consuming for the respective company. This cannot keep going on as complaints have been now encountered. Another problem is that the file paper is easy to lose and the booking sheets often become dirty and then illegible. Drinks may often also be spilled over the booking sheet, which makes it unreadable, and all the booking information will be lost which is very serious. There are also so many bits of paper, nearly all different every week. By the end of the year there are hundreds of bits of paper, because staff assistants could not find the week's sheet and started a new one. EVIDENCE THE PROBLEM EXISTS The problem evidently exists because there have been certain problems and complaints. A few weeks ago, a family of 3 went to the agency, to all buy hajj packages. ...read more.

Middle

* Then I typed in the question under the "Class" field, [What Class?] * To check that the parameter value works which is the query I clicked on run on the top of the page and the parameter value popped up. I type in "First" all the available first class tickets came up. * Finally I saved and closed the query. PACKAGE QUERY * First I added "Name", "Accommodation", "Airliner" and "Price" from the "Package Table" fields and checked all boxes. * Then I typed in the question under the "Name" field, [What Class?] * To check that the parameter value works I closed the window and I re-opened it and the parameter value question came up. I type in "Gold" all the available "Gold" packages came up. * Finally I saved and closed the query. PRICE QUERY * First I added "Name", "Class", "Price", "Departure" and "Arrival" from the "Package Table" fields and checked all boxes. * Then I typed in the question under the "Price" field, "Between [Maximum Price:] and [Minimum Price:]. * To check that the parameter value works I closed the window and I re-opened it and the parameter value question came up. I type in "10000" and "4000" all the available tickets/packages between those prices popped up. * Finally I saved and closed the query. VISA (CLEARANCE) QUERY * First I added "Nationality", "Date of birth", "First name", "Surname" and "Visa" from the "Package Table" fields and checked all boxes. * Then I typed in the question under the "Nationality" field, "[What is your nationality?]. To check that the parameter value works I closed the window and I re-opened it and the parameter value question came up. I type in "Algerian" and all the Algerians whom have applied for visas pop-up. Alongside it would also be, whether their applications for the visas have been accepted or not. * Finally I saved and closed the query. ...read more.

Conclusion

Users can use the system to produce lists of reports, price, airliner, package, passport and visa. The system is also able to produce letters to customers who have bought cars. All information in the system can be viewed on screen or can be printed out onto an A4 paper. INSTALL * You must first insert the CD into the CD-ROM. * Then you must open the file "Hajj&Umrah". * Then save the database onto the computer. * The database will then prompt you to enter the password. * After entering the password, "elkaditours", the database then opens ready for use. The Customer Table To open the customer table and view all customer records: * Click tables * Double click the customer table * To close the customer table and return to the database window click on the (x) on the top hand right corner of the screen To delete a customer record * Open the customer table * Click the grey area next to the record you want to delete to highlight the whole column then right click and click on delete. * A pop up will open to delete it and click yes. The package table To open the product table and view all product records: * Click tables * Double click the product table * To close the product table and return to the database window click on the (x) on the top hand right corner of the screen To delete a package record: * Open the package table. * Click the grey area next to the record you want to delete, to highlight the whole column then right click and click on delete. The passport table To open the passport table and view all passport records: * Click tables * Double click the passport table * To close the passport table and return to the database window click on the (x) on the top hand right corner of the screen Other tables To open the other remaining tables, follow the same steps, with the required table. ?? ?? ?? ?? Page 1 of 64 ...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. Unit 4 Multimedia -Review for Product 1 KS3 Strategy Presentation

    In the text, the titles and sub-titles are in green, the normal writing has been written in black. The good features for this is that it does look professional and suitable for the target audience, it doesn't have too many colours.

  2. Documentation of a database for a sports centre.

    We use queries in our database to retrieve specific information from the database. It is important to calculate the data storage requirements of new databases because it is important to understand the requirements of the individual/customer. The quantity and the information that needs to be stored (in the database)

  1. Database design for a games shop.

    Also a bit of color to the database would be appreciated, they look to plain at the moment, and so could you make them look brighter. In regards to the game rented information, I would like you to add days hired and required return date to the letter, all in all, everything else seems perfect.

  2. Selecting the best software for a theatre business.

    Mail merge is better than just typing addresses into the word document individually; it is better this way because it saves time and effort. At the moment he sends out over 100 people a month that would take ages to type out, it also reduces the mistakes possible to make.

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

    I would be if my lookup wizard works. I expect my drop menu should work when I select different values Testing 3 In this screen shot I am checking if my menu works. The menu shows two values 0 and 1, 1 being instock and 0 being not Instock.

  2. Microsoft Word

    Mickey gets Linda pregnant so they think they best get married and they have lovely wedding. And Mickey is working so hard so that he can take his new wife out for dinner and to go dancing.

  1. What is a computer registry?

    This key is sometimes abbreviated as "HKLM." HKEY_CLASSES_ROOT Is a subkey of HKEY_LOCAL_MACHINE\Software. The information that is stored here makes sure that the correct program opens when you open a file by using Windows Explorer. This key is sometimes abbreviated as "HKCR."

  2. Database Review of Document

    There is no system of keeping old scores - they are not re-siteable. This means that you have to delete last year's data and so you need a system in place so you can have a regional record of previously recorded data.

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