• 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 group is responsible for checking that legal requirements have been met. Tesco would also have safety representatives who attend meeting of the safety committee. They provide risk assessments and set up Health and safety rules. If an accident at work takes place, it is recorded down in an accident book.

  2. Working in retail travel

    centers Telephone Telephone Telephone Telephone There are different types of travel agents but they all offer the same products and services. However they all use different methods in order to sell their products to the public. Trade associations The Advantage Travel Centres Advantage Travel Centres is the largest and most progressive consortia group in the travel industry.

  1. Business planning

    time in order for me to create special food for my customers. I'll make sure warning to my staff to dress neatly by wearing a hair net and gloves at all time. I will also carry out a regular hygiene inspection in the kitchen, bathroom and toilet for health and safety of the premises.

  2. ICT Coursework Two - Database Project

    Overdue Cost -- Overdue cost: [Days Overdue]*[Cost of rental] Date of Birth Form Design and Query Design Table Description Table Name Field Name Search Criteria Automatically searches for members born after 1st January 1980 Member Information Customer ID -- Surname Forename Date of Birth >#01/01/1980# Video Rental Information Form Design

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

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

    Change request Number 5 The request to redevelop/redefine the MOT search history Query within the application. The project board have rejected this request for change for a number of reasons: The defect to be resolved requires the application software vendor to develop an update version of the Cain Motors

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

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