• 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


    number in all three tables, also I have added a surname column in the find patient's column and I have surname and Address - 1st Line column in the medical History column. I did this because I had to make relationships between each database Table 1 Records Validation Validation Key

  2. AQA GCSE ICT Specification B

    We would like to be able to create a complete new order on one sheet. We would like to be able to access ready made delivery notes and receipts from the new order screen. We would like to be able to search for old orders and information easily by order number.

  1. spreadsheet project

    For my font I chose verdana which is a clear format and easy to read, I decided to have no background pictures or colours as this just puts people of the actual spread sheet. After I put in the customers information I added the title of the spread sheet and

  2. Evaluating a relational database solution

    This was easy as all I had to do was 'tick' or 'untick' the 'show' row in the query 'design view'. These made my output results clearer and contain only the information that I was searching for. It was easy to see what the table looked like by simply clicking

  1. The aim of my project is to make the task of the allocation of ...

    It will allow the staff to know where everyone is sitting, where there are free seats, and the cost of each of the seating arrangements according to whether the person is an adult, child or concession, and will allow quick and easy calculation of the overall price.

  2. Project 1a. ICT

    Boolean searches are a form of finding different images and webpages throughout the internet. I have used two different search engines so that a can find different results on a search of 'zoo animals'. Now, on dogpile, I used the search type of 'zoo animals'.

  1. Setting up a database in microsoft access.

    clouds, colourful, colourful 2, dusk etc. I then clicked 'Next' where I could now title my record e.g. 'Record 2' and then I clicked finish and my report was complete. I could see the design form of my record in design view. I could see what the actual record looked like in form view.

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

    for information and if a computer is used, information stored in it can be searched very quickly, saving time and reducing stress. 3. The problem of loss of information logged in paper is avoided by having this information saved in a computer and also having a backup of it in

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