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

ICT: Long Project Design - Travel Agency

Extracts from this document...


Long Project - Design The database will be made in Microsoft Access. The other option is to use is to use Microsoft Excel to do the database but it wouldn't allow me to do a relational database. I need a relational database so that information doesn't need to be entered over and over again like what Michael has to do at the moment. I also looked at various advantages for using Access, which I've stated below. Furthermore, making a database will accomplish the criteria of being efficient and being able to be used over many years. To meet the needs of the user for an effective solution to his problems, I will need to make a database system that has forms, reports and queries. Additionally, I will also need to make mail merged letters for him. The forms are to solve his organisation problems and time wasting for editing, searching etc. The queries and reports are to solve his time wasting problem in finding things for himself and for customers. My solution will also have to fulfil all of Mr. Long's desires and all of the performance criteria. For my database, I will have the fields: ID, first name, surname, address, telephone number, and date of birth for the Customers table. This is so that it is clear and the different bits of information is organised. The logo will be given to me by Mr. Long. It represents the travel agency so people can easily recognise it. ...read more.


The run word and run excel button are just in case the user needs to access those programs for things such as calculating prices in excel or writing a simple letter in word. Furthermore, for the Destination form, I will also include a Print Destination Report button because Mr Long wants to be able to print a holiday list and I think the button will be able to save him time doing so. It will also solve the problem of photocopying flights to give to customers which is time consuming. Additionally, I will include a Print Hotels Report button on the Hotels form so it can be quickly printed and given to customers. I will also include Luxor Hotels, Cairo Hotels and Hong Kong Hotels buttons so that when a customer enquires about hotels in the countries that they're interested in, the user can pull up that information with ease. The buttons themselves will open hotel queries that I will make. I will put all the buttons and logo on the forms in the same place so there's a consistent design. I will make a hotels query for each country that is on offer so that the user can quickly get hotels for a particular country rather than going through a list and picking out the relevant ones that are wanted. I will also make a customers query template because Mr Long would like to be able to enter an area and all his customers in that area will come up. ...read more.


Long wants an easier and more efficient way of sending letters. For the mail merge letters, I am going to put: Lee's Holidays at the top of the letter. Then I am going to put the logo on the top left of the page. This is so that when the customers receive the letter; they will know who it's from straight away. I am then going to insert the date on the right hand side so that every time the letter is needed, the date on the letter is automatically changed. This is another automated process which makes it easier for the user to use. I will also make a margin on the left, running all the way down the page. In the margin, I will have the name of the owner, the address, the telephone number and the fax number. After that, I will include the fields: Customer ID, First Name, Surname, Address, Area and Telephone using the mail merge help feature. Then I will write up the contents of the letter talking about the special offer Mr. Long is offering. At the bottom of the letter, I will put Mr. Long's signature. He requested this. The font of the letter will be Papyrus and the font size will be 10. All of this will fulfil the performance criteria for the mail merge letters. These mail merge letters are reusable because the template can be used over and over again. The query just needs to be changed and then the mail merge letters will change. I will make a first draft of the database a show it to Mr Long so he can give me some feedback about it. ...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 Software 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 Software essays

  1. Analysis section for database project based on a hotel booking system

    other computer using removal medium like an external hard drive, a USB or CD-Writer. 4. There are currently lots of Cabinets occupying space at the offices of Luxury Hotel, replacing the contents of these cabinets into a PC will reduce and free these spaces and would present the company's image positively.

  2. Database design for a games shop.

    * Rentals: (client number (foreign key), game ID(FK), days kept, days returned. Mr. Walcott will also be two reports which will need to be printed out: * Overdue games: it will be sourced from the query, Mr. Walcott will print out the report and pass it to Ben, who will then chase the customer up.

  1. Reviewing different multimedia presentations.

    This makes it quite easy to do. What happened when you did this? When you do this it takes you to the page where you start to actually put I the body parts when and where you want to. The way you do this is you drag the body parts

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    surnames, forename, test results. The "Col_index_num" is the row number you want your answer to be within for example, if I was looking up surnames, and I wanted the forename, and the forenames where in column B, then I would type in 2; the reason I would type in 2,

  1. AQA GCSE ICT Specification B

    The system can be backed up. The system could be unnecessarily complicated making it difficult to use. The database could be expensive to set up. Staff will need to be trained to use it. Microsoft Access IBM Lotus approach Corel Paradox Apple works Final Choice of Solution.

  2. Project 1a. ICT

    This hits my specification point as I want them to use imagination. Alien Non ICT source: found in monthly magazine. Scan it in to my computer onto a word document them simply copy and paste. This also helps the child imagine what the situation involved in the story would look like.

  1. A04 Use Of ICT

    The Health Centre needs to attract as many people as possible, so if the information kiosk had more interactive features, which were specific to the needs of the general public, then the presentation would be more effective. 3. Jobs are very different now that ICT plays a major part in everyday tasks in the workplace.


    Pro is a great program for those who want to make a profitable online business and is overflowing with features to help you design your website. This program automatically creates and obtains a sitemap for your site which save you a lot if time.

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