• 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.

    This consists of letters which have been received into the business, memos, faxes and reports e.g. financial reports. Tesco also keep most of their reports on computers. The computer records may contain customer emails and also important documents. Computer records are easy to find because it is easy to organise all the records.

  2. Working in retail travel

    Hypermarkets offer a tailor-made service in a relaxed atmosphere. They cater for all holiday needs and there experienced staff can help with an extensive range of holidays and short breaks from all of the major holiday companies, as well as foreign exchange, car hire, airport parking, airport hotels and insurance.

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

    > The system will be password protected to stop unauthorised use, all employees will be able to update records and delete them, but no one except Mr Cain will have access to the staff records. > It has been agreed that the system will be finished and installed by the

  2. ICT Coursework Two - Database Project

    Member Information Customer ID -- Yes -- Video Rental Information Video ID -- Video Name -- Loan ID -- Cost of Rental -- Issue Date -- Returned "No" No -- Date Due -- Yes Date Due: [Issue Date]+2 Days Overdue -- Days Overdue: DateDiff("d",[Date Due],Date())

  1. Business planning

    Mortgage on premises 54,000 Loan for production machinery 15,000 Overdraft for working capital 30,000 Contribution from my own resources 92,000 Total 191,000 Quantity to be produced: one of the most important decisions I have to make is to identify the most appropriate scale of production to provide foods or services for my customers.

  2. Spreadsheet project

    This is an example of how a spreadsheet is set out: - A B C D E F G H I 1 2 3 4 D4 Each cell in a spreadsheet has its own address. For instance the intersection with column D with row 4 will give a cell with the address D4.

  1. An I.T. System for Estate Agents

    This would be so much quicker on computer as the computer would automatically match up what you are looking for by using a query or a filter instead of having to look up all the individual records of the different houses.

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

    According to Ferguson (1990) the mid-1990s rural development practice and thinking had no claim to objectivity and rational planning and that the experience of rural development since the late 1960's showed that 'development' is a profoundly political process. Projects were considered to fail because local leaders were not involved in

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