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

ICT: Long Project Analysis - Travel Agency

Extracts from this document...

Introduction

Analysis: GCSE AQA: Long Project My client, Michael Long, owns a travel agency called Lee's Holidays. This has been a long established business and as business continues to thrive, he is becoming increasingly more disorganised and is constantly losing some of his files, which causes him to lose customers resulting in a loss of money and a decrease in profits. Currently, he uses hand written documents and stores them away in filing cabinets which take up quite a bit of space. This is extremely inefficient as it takes him a long time to pull up files which makes his customers wait. Furthermore, the files sometimes get lost or misplaced which takes even more time to sort out. This isn't good as most travel agencies use computers to enable them provide a good service that is fast and efficient. He has a computer, which he doesn't use much so he has little knowledge with computers therefore, if my solution involves the use of ICT, it will have to be simple to use and user friendly. I have been asked to create a system to make his business easier to administrate. Also, it has to be easy to use so he will be able to use it quickly because he doesn't know much about computers and often finds it confusing. Current Problems and sub-problems: * Files and data are being stored in filing cabinets at the moment o Files from the filing cabinets are constantly lost o A lot of time is taken to check and see if a destination is still available because all ...read more.

Middle

Also, the spreadsheet will not be linked so bookings will be made by typing in the cells. The spreadsheet is a reusable solution because all the data can be deleted and sorted when ever it is needed to. This will keep the system always up to date and available. Another way of tackling the problem is by creating a database using a software package. In a relational database, when data on one table is changed, the same data on other tables and forms is also changed, therefore, they are reusable. The database could be set up to store information on destinations and customers etc. and be able to search selected ones. The end user, the staff of Mr Long's business, will also be able to run queries to pull up certain pieces of information. They can be adjusted so that wanted information will come up; therefore, the queries are a reusable aspect. They will also be able to add, delete and sort out all the records. This solution can be used over and over again unlike hand written files that have to be thrown away and written up again whenever there is a new change. The data in the database will just have to be altered whenever there is a change and have the changes saved so the tables are reusable. Alternatively, Mr Long could hire a new member of staff who will be in charge of sorting out the files. The person must be qualified and dedicated to their job and very organised to keep all the files in order. ...read more.

Conclusion

Also, print outs of destinations the customer is interested in will need to be made so the customer can take them away and decide which one they want to go to. Furthermore, booking confirmation will also need to be printed out and given to customers. Additionally, mail merged letters will need to be made. Information to be output: * Mail merged letters * Details of customers (Address, name etc.) * Destinations available with details (Airline companies etc.) * Hotels available with details (Country, grade etc.) * Bookings * Print out of reports Data needed to produce output: I will go through each piece of information in the filing cabinet and put it into the database system that I am going to make. I will put it into tables as I go along. * Address from the holiday guide * Addresses of hotels from brochures/internet * Descriptions of holidays from the travel brochures the business uses * Details of the current customers Lee's Holidays have in their filing cabinets. * The company logo from Mr. Long Testing: I will need to test the database to see if it works properly or not and if it doesn't; I will need to make a few adjustments. The buttons will need to be checked to see if they work. The validation should work with no problems. The mail merge letters should also give the correct information. All the results of the query need to be merged into the letters. ?? ?? ?? ?? 1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level ICT in Business 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 AS and A Level ICT in Business essays

  1. Apple Incorporation - Case Analysis

    (NA) Bulgaria 27 (NA) Iraq (NA) (NA) Romania 27 36 Canada 390 460 Ireland 365 391 Russia 43 50 Chile 85 107 Israel 254 246 Saudi Arabia 57 63 China 16 19 Italy 209 195 Singapore 483 508 Colombia 34 42 Jamaica 43 50 South Africa 62 70 Cuba 10 20 Japan 315 349 Spain 143 158

  2. Manchester Airport

    These are measure against the budgets for the period, with any variations analysed and explained. * Preparing Accounts - Each year the Manchester Airport Group produces an annual report which describes the main areas of activity during the previous financial year, its plans for the future, a breakdown of the accounts and a description of accounting methods used.

  1. Report - Long PEST Analysis of ASDA Superstores.

    ASDA collects and recycles 50% of all store waste. Approximately 80% of all cardboard used to pack products coming into store is recycled. To reduce waste sent to landfill sites. Also investing in food waste composting and plastic recycling. ASDA has 185 sites with glass banks, 160 sites with paper banks, 191 sites with can banks, 43 sites with plastic banks and 121 sites with textile/shoe banks.

  2. Business Report on Manchester Airport PLC.

    As a result there is limitless potential for transmitting, copying, sharing, storing and manipulating information. . The information looks to the future to decide what needs to be done, and the world is changing so fast that businesses must attempt to predict the future.

  1. Amazon Case Analysis

    A core competency is defined as something that a firm can do well and includes; providing customer benefits, it must be hard for competitors to imitate, and it can be leveraged widely to many products and markets. The core competency can include technical matter know how, the reliable process, and close relationships with customers and suppliers.

  2. Working in retail travel

    Advantage Travel Centres is the brand name of the National Association of Independent Travel Agent (NAITA), and has been going for over 25 years. They have a turnover in excess of �2 billion a year that enables them to negotiate better deals for their members, and results in great deals for their customers.

  1. ICT Coursework Two - Database Project

    Design and Field Definitions Field Name Data Type Field Size Validation Description ID Number Text 12 Input mask: L\-000\-0000\-L Video's ID number given by the store for easy search and classification. Title 50 -- Video title to recognise the video by the staff and customers.

  2. Spreadsheet project

    The table is accurate and neat and already created for you to use. It also prevents from time consuming in every area. Access is used for storing, sorting and being able to easily retrieve certain types of data, this type of software is used for compiling information on customers, items etc.

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