Type a Flight is a Warrington based travel agency which was established in 1995. It has approximately 500 customers and 10 employees. Type a Flight has a small shop which is situated in the center of Warrington in the midst of other small stores. Inside the shop the workers sit behind one long desk in a straight row. They have a phone line system which they use to communicate with the customers. Behind them are around 6 filing cabinets containing the details of all 500 or so customers which are arranged in alphabetical order. Every time a customer phones the member of staff taking the call gets out of his chair and looks through the cabinet to find the customers details. This procedure requires a lot of man work and is also very time consuming.
My task is to help Type a Flight travel agency to make their things easier, for example to make a computerized database for them so it will be easier for them to find customer records/details. A database would also be easier to make a booking because if they had filing cabinets then it would be very time consuming in finding the person’s flight or details. This could result in upsetting the customer or even losing the customer. Furthermore if they had a database they will have more customers because they will be able to work more efficiently.
Currently all the letters are being written by hand. This takes a lot of time and the employers find it really difficult. The solution I had to this problem was that to make templates letters so that they don’t lose any time and they can post it to the customers house so that it saves their time and also doesn’t waste the staff time in writing the letters by hand.
I have looked at one database which is called Type of Flight. It has things like if you already signed up or if not then you can register but only staff can use this database. Also it has things such as if you are recommended by a friend and if you want to recommend a friend.
Database: Type a flight
I looked at a switchboard called “Type of flight” and the logo is situated in the middle of the page. It has various buttons such as Enter ID, Search ID, Gender, D.O.B, Name etc. This makes the database faster and sufficient. When you press any button there should be a query box will appear so it will be easier to get to the detail. Also in this there are forms and queries. Forms are based on queries and the queries are based on the database.
These are my five task that I have been appointed to do.
* Getting information about the travel agency
* Design a logo and a slogan for the travel agency
* Create a database + Queries + Forms and final Switchboard
* Create a letterhead and design letter templates
* Writing reports at the end (User Guides)
1. Getting information about the travel agency
I can get information from the travel agency by looking for their leaflets but I will not because it will waste too much time by looking for their leaflets. I can also get the information from the internet by going in their website but I will not do this because this will also waste time and if I do get the information this might not be reliable source. I will get information from the actual agency by going to their shop and I will do this because it will be sufficient and I could ask those questions as well and the information I will get will be reliable.
The questionnaire I will use to interview the agency is given below:
1. Does your agency know how to use a computer?
2. Does your company know how to create a letterhead?
3. How do you think your company will cope with the new system?
4. Is your company trained properly?
5. How do you feel with the new system?
6. Do you think there is a better way to improve the system?
7. What are your opinions?
8. Does your company know how to create a template letter?
9. Do you think your company prefers the old system or the new system?
10. Why do you think this?
2. Create a database + Queries and Forms
I can create a database by Microsoft Access but I will not because it is not made for that. I will create a database by Microsoft Excel because it easy to make databases and it is sufficient.
3. Design a logo and a slogan for the travel agency
I can design a logo for the travel agency by various ways, I design the logo by hand but I will not because it will be drawn inaccurate and it might just waste too much time. I can also use Adobe Photoshop but this application is too complex. I will design the logo for the travel agency by using the application Paint.
4. Create a letterhead and design letter templates
I can create a letterhead by hand but I will not because it doesn’t look professional and it also time consuming. I can create a letterhead by notepad but I will not because it
I cannot do some things, which are vital for me. I will use Microsoft word because this is the most sufficient application for me.
5. Writing reports at the end (User Guides)
I can write a report at the end with my hand but I will not because I can make mistake. It will also be more time consuming. I can create my report at the by using an application called notepad but I will not because it also doesn’t have things which are I need. I will write my report on the application Microsoft word because it has everything I need to write my report.
Create a database + Queries + Forms and final Switchboard
I can create this by using the application Microsoft Excel but I will not because it is not suitable for making switchboards and also it is not professional. I will create the database on Microsoft access because it is suitable for making switchboard.
Create a letterhead and design letter templates
I can create this by doing on hand because it doesn’t look professional. I will create a letterhead on Microsoft Word because it will look professional and it will be much easier.
Writing reports at the end (User Guides)
I will create a user guide for people who do not know how to use a computer properly and in that user guide I will put pictures so the people who are reading it will find it easy.
Input, Output, Process and Storage
Now that I have researched hardware and I know what they are I can put them into different groups.
Create Template Letters
Ease of use
The final product that I will make is going to be easy because I have explained how I am going to get my information also the manual is going to easy to read and finally the manual will have a user guide with pictures so the person will have ease to read and understand and the user should have no difficulties to use the user guide. Also the final product that I will make will be easy for the company because it will have everything step by step also if the company employees do not still know how to use it then there will be pictures so the company will know how to use it.