• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Research for a database for a travel agents.

Extracts from this document...

Introduction

Introduction I have been given a task to make things easier for a travel agent called Type a Flight. Type a Flight is a travel agent which is situated in Warrington and it was established in 2005 and it also has about 500 customers. The company does all its work manually. They keep their documents in filing cabinets. So when customers call in to book flights then they have to look in the cabinets for a document. This is very time consuming and due to this problem they could loose a fantastic amount of customers because they will get tired on the phone. Filing cabinets also take up a lot of space. This is getting very difficult and time consuming as the number of customers is rising on a daily basis. One of the problems is that it takes time writing letters by hand .For this problem I have come to conclusion that I will create template letters for the company and these can be sent out to customers to tell the customers that their ticket is ready or for any reasons. The conclusion I have come to is that I am going to help the agency in every single way. ...read more.

Middle

1. What problems do you have in the agency? _________________________________________________________________________________________________________________________________________________________________________________________________________________________________ 2. How many customers does the agency have? Less than 100 100-250 250-500 More than 500 3. How are the documents of the customers stored? Filing Cabinet Other 4. What do you think of a computerized way to remove your problems? _________________________________________________________________________________________________________________________________________________________________________________________________________________________________ 5. Do your employees know how to use Microsoft Access? Yes No Do not know 6. Are your employees capable of using a switchboard? Yes No Do not know 7. Does the agency have letter templates? Yes No 8. Does the agency have a good logo? Yes No 9. Do the employees need a user guide? Yes No 10. What changes will the agency have if the computerized way was used? ______________________________________________________________________________________________________________________________________________________________________________________________________________________________ 2. Design a logo and a slogan for the travel agency a. I can do this task by using Microsoft Word but will not do it this way because it does not have many of the tools needed to make a logo but I can make the slogan on it. b. I can also do this task by using Adobe Photoshop but will not use it because the application is quite complicated for me. ...read more.

Conclusion

c. I will do this task this by using 'Microsoft Word' because I can take screen shots and then I can paste them onto the page. There after I will put in arrows and any other things if needed to label it clearly with information so that people fully understand. Input, Output, Process and Storage After my research and looking at the various tasks, I can establish what the input, output and storage of the system is. Ease of use The final product that I will make would consist of database, queries, forms and letterheads. It would be easy for the agency to use because I think the employees are more or less familiar with computers and using the applications needed. I will also supply them with a user guide. The user guide will be simple and very easy to use. It will have screenshots and clear labeling with arrows so if the employees get stuck any where then they could refer to the user guide which has clear instructions and easy step by step of using any application. After using the user guide the employees should have no doubt in using an application. Description of problem = 1 Plan of solution = 1 Methods = 1 Solution meets requirement = 1 Ease of use = 1 ?? ?? ?? ?? Type A Flight AO2a ...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. Peer reviewed

    Designing a database for Type a Flight Travel Agent.

    3 star(s)

    It contained a multiple choice of buttons like Search ID, Enter Gender, Date of Birth, Name, Enter ID etc. This made the database more beneficial. When you pressed a button there will be a query box so you can get the detail, plus there are queries and forms.

  2. Normalisation.Normalisation is a process used to come up with the best possible design for ...

    This has access to all you will need to do. As you will see there are three buttons, 'Students', 'Tutors' and 'Bookings'. Each will link you to the part of the database you need. For example if you wanted to make a booking then you will need to click on the bookings button.

  1. Benefits of using my IT system in the Travel Agents.

    Benefits and Drawbacks of the System My system has certain advantages and certain disadvantages which are stated below: Advantages Disadvantages The advantage of using a computer is that it will save money in long term cases. The disadvantage of using a computer is that if you get a virus then

  2. Planning a website for a travel agent.

    the manager and letting him do it and extracting information from it because it is very reliable and saves time. Design a logo and a slogan for the travel agency I can do this task by getting some coloring pencils and paper and drawing it but I won't do it

  1. Designing a database and logo for a travel agent.

    time and therefore more sales could be made within the working day. One of his customers in the questionnaire mentioned that overnight, Mr Jones should leave a voicemail service for any customers that were booking after the closing time. I decided to design a logo for First Travel as this helps their customers to immediately identify with the company.

  2. Statistics Study Guide

    that amount from each lower class limit to find the lower class boundaries. Class midpoints- are the midpoints of the classes. Each class midpoint can be found by adding the lower class limit to the upper class limit and dividing the sum by 2.

  1. Creating a travel planning ICT system

    will all help me to decide which would be the best method of working out these costs. I have chosen these two programs because in each one I can create tables. Different methods of tackling the problem In Microsoft word I can * Create a table * Merge cells * Change the page layout (portrait and landscape)

  2. Excel user guide

    Then select Next. Second step - The second step will illustrate the chart source data within the bar chart. This will allow you to arrange or edit your data. This will also allow you to change the format in which you would like your data to be presented.

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