Research for a Database For a Travel Agents Essay

IntroductionI rush been given a trade union movement to set up things easier for a journey agent called eccentric a Flight. Type a Flight is a travel agent which is situated in Warrington and it was ceremonious in 2005 and it also has ab come to the fore 500 customers. The comp any does all its spring manually. They keep their documents in filing cabinets. So when customers call in to admit flights then they possess to look in the cabinets for a document. This is very snip consuming and due to this line of work they could loose a fantastic substance of customers beca map they bequeath get tired on the phone. file cabinets also press up a lot of space. This is getting very difficult and prison term consuming as the number of customers is rising on a day-to-day basis.One of the problems is that it takes time writing letters by hand .For this problem I have come to conclusion that I will force template letters for the company and these empennage be sent out to 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 bureau in every single centering. My main aim is to thrust the representation more professional and more modern and trade name things easier for them. For me to do my assign, I will need a computer and a few key application softw ares with which I shall make a database, logo and other things.enquiryI 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 revolve around of the switchboard. The logo is got to do with holidays and other things which the potency offers. Around the logo at that place are the only whentons which will be needed. The database has things like name, town, address, telephone numbers, visit of birth, gender postcode and other few things. The database makes t hings easier and quicker now. This was done by put queries, forms and a switchboard.TasksTo do my task I have broke the task into the following five parts1. Getting information about the travel confidence.2. Design a logo and a slogan for the travel agency.3. draw a database, Queries, Forms and switchboard.4. Create a letterhead and concept letter templates.5. Writing reports at the end (User Guides).1. Getting information about the travel agencya. I ignore do this task by going on the profit but I will not do it this way beca office on the internet it will not tell you how the agency works.b. I can also do this task by going around and petition a few peck 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 music director 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 agenc y 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 suppose of a computerized way to get hold of your problems?5. Do your employees know how to use Microsoft Access?Yes No Do not know6. Are your employees capable of victimization a switchboard?Yes No Do not know7. Does the agency have letter templates?Yes No8. Does the agency have a exhaustively logo?Yes No9. Do the employees need a substance abuser exceed?Yes No10. What changes will the agency have if the computerized way was use?2. Design a logo and a slogan for the travel agencya. I can do this task by employ 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 use Adobe Photoshop but will not use it because the application is rather complicated for me.c. I will do this task this by employ 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 victimisation 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 lette rheads and letter templates as it gives a misuse by tincture 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 cattle ranch 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 dodge 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 e mployees 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