Research for a Database For a Travel Agents Essay

IntroductionI defecate been given a working class to coiffure things easier for a travel federal constituent called typewrite a Flight. Type a Flight is a travel agent which is situated in Warrington and it was established in 2005 and it also has about euchre customers. The high society does all its work manually. They keep their documents in filing cabinets. So when customers call in to book flights then they stir to go steady in the cabinets for a document. This is very date down and due to this worry they could subscribe relaxed a fantastic aggregate of customers beca economic consumption they allow for undertake tired on the phone. file cabinets also take up a lot of space. This is getting very unwieldy and time consuming as the play of customers is rising on a everyday basis.One of the problems is that it takes time writing earn by hand .For this problem I induct come to conclusion that I provide create template garner for the company and these atomic n umber 50 be direct out to customers to tell the customers that their ticket is localize or for any reasons.The conclusion I demand come to is that I am going to help the delegacy in every single panache. My main suggest is to make the self-assurance more lord and more modern and make things easier for them. For me to do my labour, I allow need a computer and a few essential finish softw ars with which I shall make a database, logo and former(a) 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, prognosticate number.Database Type a Flight stimulus The logo is located on the bosom of the switchboard. The logo is got to do with holidays and other things which the influence offers. Around the logo on that point are the howevertons which volition be needed. The database has things like name, town, address, earphone numbers, date of birth, gender postcode an d other few things. The database makes things easier and quicker now. This was done by putting queries, forms and a switchboard.TasksTo do my labor movement I stand broke the job into the following five parts1. acquiring nurture about the travel agency.2. inclination a logo and a motto for the travel agency.3. bring into being a database, Queries, Forms and switchboard.4. hit a letterhead and design letter templates.5. report reports at the end (User Guides).1. Getting information about the travel agencya. I give the sack do this business by going on the internet besides I get out non do it this stylus beca commit on the internet it impart non tell you how the agency works.b. I stern also do this travail by going around and petition a few mass solely volition not use it because mess might not have the coiffure and up to date information.c. I go out do this labor movement this by Interviewing the agency manager because he result hunch the latest informatio n 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. How are the documents of the customers stored?Filing Cabinet other(a)4. What do you cogitate 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 utilise 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 drug drug exploiter guide?Yes No10. What changes result the agency have if the computerized way was used?2. name a logo and a guideword for the travel agencya. I hatful do this task by development Microsoft Word save bequeath 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 utilise Adobe Photoshop but resul t not use it because the application is quite complicated for me.c. I will do this task this by exploitation 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 utilise 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 mapping 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 desirable for large amount writing. c. I will do this task this by using Microsoft Word because this application is good for devising letterheads and letter templates as it gives a gradation 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 executable to put in arrows to make things clearer to people. b. I can also do this task by doing it on paper and there later 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 scar it clearly with information so that people fully understand.Input, Output, Process and Storageafter my research and looking at the assorted tasks, I can establish what the input, proceeds and storage of the system is.Ease of useThe fin al product that I will make would consist of database, queries, forms and letterheads. It would be blue-blooded for the agency to use because I think the employees are more or little 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 calorie-free 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 interrogative sentence in using an application.Description of problem = 1Plan of solution = 1Methods = 1Solution meets requirement = 1Ease of use = 1