I.T. Project †Converting a Card Index System to a Database Essay

The present schema is based on the manual of arms card king remains so most of the work is done by hand, every(prenominal) the same due to the ever increasing g course of studyth of technology, and the internet, a wide wrap of resources ar now being make easily accessible.British Airways has recently introduced set asideing online, where guests can book a safety valve and accommodation all over the Internet. Being such a big company as British Airways, most of their bookings ar made through travel agents who book the flights and pass the information on to them.Question 1 Could you describe the underway system being used byQuestion 2 How argon these cards shop classd?Question3 What problems do you encounter at the moment?Software purchasableMICROSOFT OFFICE 2000WORD PROCESSOR MICROSOFT WORD 2000A word impact software product is a program or set of programs used to edit, format, store and print documents.Word processors consider many important unique features* ecstasy out and Grammar CheckerMisspelt words, or grammatical errors can be identified and rectify by the words in the computers dictionary. Correct words, identified by the spell check as wrong can be added to the dictionary.* Automatic asylum of index and table of contentsAny word in the textual matter can be marked for inclusion in an index. Headings and subheadings in a given style can be included automatically in a table of contents, which can be updated at any time.* here and now FilesTables, photographs, graphics, video and sound files can be imported from other sources and inserted in a document.* Mail mergeA document and a magnetic dip of names and addresses can be merged to produce personalised letters.* entry of templates with preset text styles. Margins, formatting, letterheading etc.* WYSIWYGThis stands for What You See Is What you Get, and refers to the index to display on the diffuse. And enables the user to see their work on the screen exactly as it will be p rinted.SPREADSHEET MICROSOFT EXCEL 2000Spreadsheet packages grant a user to create worksheets (spreadsheets) representing entropy in column and row form. Spreadsheets are used for any application that uses numerical data, such as budgets, cash flow forecasts, profit and loss statements, student marks or results of experiment.Spreadsheet features* order electric cells, rows and columns, specifying for example, the alignment of text, number of decimal points, height and width of cells.* Copy cell contents to other locations, with automatic adjustment of formulae from an area to another location.* situate the effect of several different hypothetical changes of data this facility is called what-if calculation.* Insert, shine or delete rows and columns.* Use functions such as sum, average, max, min in formulae* nominate a simple database and sort or query the data to produce a report of, say for example, all males gaining over a C grade, for a describe of students.* Write macros to automate common procedures* draw templates Spreadsheets with formats and formulae already entered, into which new figures whitethorn be inserted.* Create multi dimensional spreadsheets apply several sheets, and copy data from one sheet to another* Create many different types of chart and graphsDATABASE MICROSOFT ACCESS 2000A database is a arrangement of data. It whitethorn be something as simple as a list of names and addresses or details of the CDs in your personal collection, or it may contain details of all the customers, products, orders and payments in a large organisation. When made reference to, the word database is assumed to be data held on a computer, but manual databases also exist. Some smaller business (a garage) may hold a card index file with details more or less a customer and their car.The main difference between a manual and computerised databases is the speed at which data can be accessed.PRESENTATION artwork MICROSOFT POWERPOINT 2000Presentation graph ics software such as PowerPoint is useful for pose together a presentation which can be delivered using a computer attached to a projection device, using transparencies and an ordinary budget items projector or as a self-running presentation in, say a obtain centre or cinema. The software allows the user to quickly create slides corporate trust text, graphics and pictures and to create animation or sound effects and intonation effects between slides. run SYSTEM MICROSOFT WINDOWS 98Hardware forthcomingThese are the specifications of the PC I am using at menageOPERATING SYSTEMWINDOWS(r) 98 PLUSCPUINTEL(r) CELERONTM / 333MHZRAM64MB FOR WINDOWS(r) 98SCREEN show800 BY 600 PIXELSTRUE COLOUR (32 BIT)CD-ROM travel32-SPEED forthcoming SPACE ON HARD DRIVE2.4GBAUDIO16-BIT overweight beakOTHERLOUDSPEAKERSThese are the system specifications for the systems at schoolOPERATING SYSTEMWINDOWS(r) 98CPU433MHZRAM32MB FOR WINDOWS(r) 98SCREEN DISPLAY640 BY 480 PIXELS256 COLOURSCD-ROM SPEED24 S PEEDAVAILABLE SPACE ON HARD DRIVE10MBAUDIO8-BIT SOUND CARDPRINTERHP LASERJET either systems should draw Microsoft Office 97/2000.All systems must turn over Microsoft stand out 97/2000.End Users IT LiteracyThe end user of my system will already have introductory IT skills and will have already had experience with the Microsoft Office Package. As they are working for a big trans-national company, they would have already undergone learn in the secretarial sector, of which IT skills are a key part. To even have the job, they would have to be able to type quickly, answer calls and transmit data efficiently. Therefore, training costs will be kept to a minimum.Final superiorHaving looked at the catamenia system and the software and hardware available, I have decided to use Microsoft outmatch, a spreadsheet program to design my booking system. Spreadsheet packages allow a user to create worksheets (spreadsheets) representing data in column and row form. Spreadsheets are used for any application that uses numerical data, such as budgets, cash flow forecasts, profit and loss statements, student marks or results of experiments. Spreadsheets offer a wide range of facilities making the task easier to perform.SKILLS accepted/To be acquiredI have a good understanding of the Microsoft Excel package. I have done quite a few calculations and performed grassroots macros. Having looked through the coursework of former students, and reading through the coursework guide, I realise that I need to improve my knowledge of Excel. Excel is a powerful package and can carry out many tasks easily if instructed correctly. I have already started to go through sample projects display me how to go roughly certain tasks with a book titled Successful I.T. Projects in Excel, written by P.M Heathcote.End User Requirements stomach detailed reports showing customer booking for every working day. Produce summary reports for flight bookings in order of popularity. Allow data entry for new customers. Provide easy access for amendments to customer details and flight details. Automatic easement for all centralised evinces daily and weekly. Provide an exception report for nifty customer debts or extreme bank credit limits. The system should record financial details concerning money in/outstanding. Allow queries on the current flight availability.Quantitative Criteria Printed tickets are to be generated within 15 minutes. Accessing and amending customer/Fight/Airport details should be instantaneous. Queries are processed right away on customer request. Backup should occur automatically every 24 hours. Flight details processed every Friday (1 hour max) Exception reports are produced quickly on demand within a minute.Qualitative Criteria The system should provide a workable Human Computer Interface system according to different users, i.e. simple menu selections or buttons The company logotype is consistent on all forms and reports. Amount of available screen data is kept to a minimum (increase usability) Help systems are easily accessible.