Research for a Database For a Travel Agents Essay Example for Free

Research for a Database For a Travel Agents EssayIntroductionI chip in been given a line to make things easier for a affect agent called Type a Flight. Type a Flight is a travel agent which is situated in Warrington and it was established in 2005 and it in all case has about 500 customers. The company does all its work manually. They keep their documents in filing cabinets. So when customers call in to book flights then they have to facial gesture in the cabinets for a document. This is very time consuming and due to this problem they could loose a fantastic amount of customers beca purpose they leave alone get tired on the phone. Filing cabinets also take up a lot of space. This is getting very difficult and time consuming as the number of customers is rising on a daily basis.One of the problems is that it takes time writing letters by hand .For this problem I have come to conclusion that I allow for create template letters for the company and these evoke be sent out t o customers to tell the customers that their ticket is ready or for any reasons.The conclusion I have come to is that I am going to help the manner in every single course. My main aim is to make the agency to a greater extent professional and more modern and make things easier for them. For me to do my labor movement, I bequeath need a computer and a few important application softw ars with which I shall make a database, logo and other things.ResearchI had a look at a database which I was shown by my class teacher. It was called Type of Flight. In the database it had things like name, ID, g closedowner, telephone number.Database Type a FlightComment The logo is located on the centre of the switchboard. The logo is got to do with holidays and other things which the agency offers. close to the logo there are the buttons which will be needed. The database has things like name, town, address, telephone numbers, date of birth, gender postcode and other few things. The database make s things easier and quicker now. This was done by putting queries, forms and a switchboard.TasksTo do my task I have broke the task into the following five parts1. Getting information about the travel agency.2. Design a logo and a slogan for the travel agency.3. Create a database, Queries, Forms and switchboard.4. Create a letterhead and design letter templates.5. Writing reports at the end (User Guides).1. Getting information about the travel agencya. I send away do this task by going on the internet but I will non do it this way because on the internet it will not tell you how the agency works.b. I can also do this task by going around and asking a few people but will not use it because people might not have the correct and up to date information.c. I will do this task this by Interviewing the agency manager because he will know the latest information and what problems there are in the agency.1. What problems do you have in the agency?2. How many another(prenominal) customers d oes the agency have?Less than 100 100-250 250-500 More than 5003. How are the documents of the customers stored?Filing Cabinet Other4. What do you think of a computerized way to remove your problems?5. Do your employees know how to use Microsoft Access?Yes No Do not know6. Are your employees capable of exploitation a switchboard?Yes No Do not know7. Does the agency have letter templates?Yes No8. Does the agency have a good logo?Yes No9. Do the employees need a user guide?Yes No10. What changes will the agency have if the computerized way was used?2. Design a logo and a slogan for the travel agencya. I can do this task by using Microsoft ledger but will not do it this way because it does not have many of the tools needed to make a logo but I can make the slogan on it.b. I can also do this task by using Adobe Photoshop but will not use it because the application is quite complicated for me.c. I will do this task this by using Paint because It offers a good amount of tools which can be used to make a good logo and a slogan.3. Create a database, Queries, Forms and switchboarda. I can do this task by using pen and paper but will not do it this way because it will be time consuming and many mistakes can be made. b. I can also do this task by using Open Office Base but will not use it because it is harder to use than Microsoft Access. c. I will do this task this by using Microsoft Access because I can make databases, Queries, Forms and switchboards more quicker because I have used it many times before.4. Create a letterhead and design letter templatesa. I can do this task by using Microsoft Publisher but will not do it this way because it is a little hard to create a letter template but a letterhead can be produced easily. b. I can also do this task by using Paint but will not use it because it is not suitable for large amount writing. c. I will do this task this by using Microsoft Word because this application is good for making letterheads and letter templates as it gives a measuring by step way of making it.5. Writing reports at the end (User Guides)a. I can do this task by using WordPad but will not do it this way because it is not possible to put in arrows to make things slanger to people. b. I can also do this task by doing it on paper and there after scan it but will not use it because it may not be neat and professional enough. c. I will do this task this by using Microsoft Word because I can take screen shots and then I can paste them onto the page. There after I will put in arrows and any other things if needed to label it clearly with information so that people fully understand.Input, Output, Process and StorageAfter my seek and looking at the various tasks, I can establish what the input, output and storage of the system is.Ease of useThe final product that I will make would consist of database, queries, forms and letterheads. It would be easy for the agency to use because I think the employees are more or less familiar with co mputers and using the applications needed. I will also supply them with a user guide. The user guide will be simple and very easy to use. It will have screenshots and clear labeling with arrows so if the employees get stuck any where then they could refer to the user guide which has clear instructions and easy step by step of using any application. After using the user guide the employees should have no doubt in using an application.Description of problem = 1Plan of solution = 1Methods = 1Solution meets requirement = 1Ease of use = 1