Wednesday, May 22, 2019

Research for a Database For a Travel Agents Essay

IntroductionI have been given a task to trifle things easier for a travel agent called typesetters case a Flight. Type a Flight is a travel agent which is situated in Warrington and it was established in 2005 and it in like manner has about 500 customers. The social club 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(prenominal) time consuming and due to this problem they could loose a fantastic amount of customers because they for rise get tired on the phone. Filing cabinets similarly go up a lot of space. This is getting very difficult and time consuming as the number of customers is rising on a daily basis. wizard of the problems is that it takes time writing garner by hand .For this problem I have come to conclusion that I will create template letters for the company and these can be sent out to customers to tell the customers that thei r ticket is ready or for any reasons.The conclusion I have come to is that I am exhalation to help the agency in every single delegacy. My main aim is to make the agency more professional and more groundbreaking and make things easier for them. For me to do my task, I will need a computer and a few important application softw atomic number 18s 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, call up 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 in that location 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 makes things easier and quicker now. This w as done by putting queries, forms and a switchboard.TasksTo do my task I have broke the task into the following five parts1. Getting data about the travel agency.2. frame a logo and a guideword for the travel agency.3. clear 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 can do this task by going on the internet but I will non do it this way because on the internet it will non 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 customers does the agency have?Less than 100 100-250 250-500 More than 5003. Ho w are the documents of the customers stored?Filing storage locker 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. ar your employees capable of employ 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 Word 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 preferably 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 theme 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 fashioning letterheads and letter templates as it gives a step by step way of making it.5. Writing repo rts 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 interpret 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 research 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 contain 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 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 = 1 solvent meets requirement = 1Ease of use = 1

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.