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

Research for a Database For a Travel Agents assayIntroductionI have been given a task to make things easier for a hold up federal 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 as well 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 look in the cabinets for a document. This is very time consuming and due to this problem they could loose a fantastic amount of customers because they forget get tired on the phone. Filing cabinets also take up a lot of space. This is get very difficult and time consuming as the number of customers is rising on a insouciant basis.One of the problems is that it takes time writing letters by hand .For this problem I have suffice to conclusion that I allow create template letters for the company and these hatful be displace out to customers to tell the customers that their ticket is ready or for any reasons.The conclusion I have convey to is that I am going to help the potency in every single personal manner. My main steer is to make the agency more professional and more modern and make things easier for them. For me to do my task, I forget need a computer and a fewer important application softwares with which I shall make a database, logotype 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, gender, 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. Around the logo thither are the neverthelesstons which go out be needed. The database has things like name, town, address, telephone numbers, date of birth, gender postcode and other few things. The database makes things ea sier and quicker now. This was done by putting queries, forms and a switchboard.TasksTo do my task I have stony-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. cook 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 back do this task by going on the internet but I entrust non do it this way because on the internet it will not tell you how the agency works.b. I bed also do this task by going around and asking a few hatful 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 does 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 feeler?Yes No Do not know6. Are your employees capable of utilize a switchboard?Yes No Do not know7. Does the agency have letter templates?Yes No8. Does the agency have a reliable logo?Yes No9. Do the employees need a user choke?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 cornerstone do this task by exploitation Microsoft Word but will not do it this way because it does not have many of the tools needed to make a logo but I net 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 an complicated for me.c. I will do this task this by using Paint because It offers a good amount o f 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 root 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 feed 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 step 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 clearer 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. in that respect after I will put in arrows and any other things if needed to label it understandably with information so that people fully understand.Input, Output, Process and StorageAfter my research and looking at the various tasks, I can establish what the input, output and storage of the system is.Ease of useThe final exam product that I will make would consist of database, queries, forms and letterheads. It would be well-fixed for the agency to use because I think t he employees are more or less familiar with computers 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