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

A.C Travel Computing Project

Extracts from this document...

Introduction

ANALYSIS Andrew Clement Computing Project Introduction A.C Travel is a small travel company privately run business owned and run Mr. Davies and his son. They run their business together, selling holidays and travel insurance mainly to American destinations. They try to focus on keeping customers for more than one holiday, so they have a good customer list that is increasing every year. Sales are not good because, their prices are cheaper to be competitive with the bigger travel like Thomas Cook, Going Places and the other bigger travel agents. Although the Davies have do hold a list of customers on DOS-based filing system, they have no means of targeting the customers who might be looking to go on holiday soon. They also have no easy way of advertising, like mail merge or sending information out to potential customers or original customers. The also have a filing system for the places to go in America and no easy way to access them, they have to sort through files even to phone certain plane companies and hotels. Mr. Davis has decide to invest in a comprehensive customer system to hold the details of who their customers are he also need a easy to access database to access places to go in America and how much it costs to go profit levels on each flight. Mr. Davis would also like some sort of accounting system as well as an easy way to advertise. ...read more.

Middle

He also has a large database of previous customers who can be sent new information and adds. He would also like a website which can help him bring in more business. He would like some sort of mapping software, to know where in America everything is including large city airports and main tourist attractions. Problems With Current System Sending previous customers new information With the system the already have, when a customers phones in to book a holiday or to make a enquiry, there details are written down and filed in a cabinet if it is just a booking then it is put in a easy access cabinet but if it is a sell then it is put anyway for storage. This then means that it is hard to find the documents again, if they are needed and you cannot send out any other information on new holidays or special deals. Even if they did want to send information out to customers they would have a lengthy job looking for names and address through the files. Tracing previous orders placed by a customer Each time a customer phones in, they are automatically asked for name and address, this information is then stored for long-term reference in storage cabinets, taking up valuable space and time storing them. Then when you need to access the information. It is very complicated and laborious task, to look through and gather the information. ...read more.

Conclusion

Mr. Davis already has a Pentium 200 8Mb, which will be suitable for some basic work, so it can still be used. User's level of information technology skills Mr. Davis son has some good keyboard skills, although he not the fastest for data need to be inputted they will need a professional reception how can input all the data at an efficient rate. Consideration Of Possible Solutions A database package would be the best software for this problem, Mr. Davis has not requested anything for it to be done on but think we should go for the whole Microsoft Office package because it would work out cheaper and give better recourses, for the whole company. Anther reason for using Microsoft is that is easy to get hold of and runs on windows. Access is very easy to pick up on with some basic instructions here are some of the good points on why I have chosen access and Microsoft Offices Package. Using the Microsoft Access, it will be possible to: > Set up the necessary table and relationships > You can use Macros to run tasks quicker > Use Visual Basics modules to enable fast searches for a particular customer and past jobs > Design reports as needed > Make and save queries to select certain customers for mail merge > Link with Microsoft Word to enable new letters to be composed and to perform mail merges to select customers > Has a massive space for databases Andrew Clement Computing Project 4 ...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. Business Aims and Objectives.

    * Financial service centre - in the financial service centre the team make sure all the employees in Tesco are being paid their wages. Their wages must be correct as they send over �1 billion a month to process about 1 million people.

  2. Working in retail travel

    For example 'Holiday Cybermarket', the Cheshire Oaks shop has installed three computers with Internet access, allowing holidaymakers to book car hire or holiday insurance and browse any other holidays available on view data. Alternatively, they can print out the details and book on an adjacent video phone linked up to

  1. ICT Coursework Two - Database Project

    and Field Definitions Table Field name Data type Field size Validation Description Video ID Text 12 Input mask: L\-000\-0000\-L The video's ID number given by the store Video Name 50 -- The video's title VHS or DVD 3 Input mask: LLL The video's format Loan ID 5 Input mask: LL000

  2. Spreadsheet project

    The Formulas entered in a spreadsheet can refer to absolute data (fixed data) e.g. the price of a can drink is fixed at any time or relative data e.g. the time taken to drink 1 can will vary from time to time.

  1. The purpose of this document is to define the Context of Cain Motors Information ...

    no available funds to contract Mrs Frisby to develop a new version of the database. Time constraints applied by the project board to complete any approved request for change do allow sufficient time for this change further at the present time.

  2. An I.T. System for Estate Agents

    if anything was to ever be lost or if the computer was to ever break down there would always be a back up copy of all the records and work stored onto the computer. This system would not keep the estate agents well organised as they would always be looking

  1. Business studies project on Microsoft

    However Xerox did not see the point or the potential in this (fools) and thus sold it to Steve Jobs then Bill Gates came along and negotiates a deal with Steve Jobs to 'supposedly' make software for the new machine.

  2. The Use of Geographical Information Systems (GIS) And International Technology Transfer by Non-Governmental ...

    assessment of how Africa is often viewed as a laboratory with unique opportunities to do something correctly from the beginning. The second concern relates to the emphasis by GIS experts on rational planning. This is the feature of the technology that has made it extremely attractive to development agencies and their emphasis on the importance of participation.

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