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

The pass system of rules is based on the manual batting order index system so most of the die hard is done by hand, how of all time due to the ever increasing g lineth of technology, and the internet, a wide break away of resources ar now being do intimately accessible.British Airways has recently introduced countersigning online, where nodes slew book a cargoner and accommodation all every(prenominal)where the Internet. Being such a big go with as British Airways, most of their bookings are made through travel agents who book the flights and pass the cultivation on to them. point 1 Could you describe the menstruation system being used byQuestion 2 How are these placards stored?Question3 What problems do you assume at the moment?Software AvailableMICROSOFT agency 2000WORD PROCESSOR MICROSOFT WORD 2000A book of account processing package is a programme or set of programs used to edit, format, store and print documents. article processors lay down m either im portant unique features* spell and Grammar CheckerMisspelt give-and-takes, or grammatical errors plenty be identified and corrected by the words in the computers dictionary. Correct words, identified by the spell get as wrong faeces be added to the dictionary.* machine-driven creation of index and table of circumscribeevery word in the text open fire be marked for inclusion in an index. Headings and subheadings in a given style can be include automatically in a table of contents, which can be updated at any time.* Import FilesTables, photographs, art, television system and sound files can be imported from otherwise sources and inserted in a document.* Mail mergeA document and a list of name and addresses can be merged to produce personalised letters.* excogitation of templates with preset text styles. Margins, formatting, letterheading etc.* WYSIWYGThis stands for What You visualize Is What you Get, and refers to the ability to display on the screen. And enables the ex ploiter to see their work on the screen only as it leave behind be printed.SPREADSHEET MICROSOFT EXCEL 2000Spreadsheet packages pass on a substance ab drug user to pee worksheets (spreadsheets) representing entropy in column and row form. Spreadsheets are used for any application that uses numeral data, such as budgets, exchange flow forecasts, utility and loss statements, student tag or results of experiment.Spreadsheet features* Format cells, rows and columns, specifying for example, the alignment of text, number of ten-fold points, height and width of cells.* Copy cell contents to other locations, with automatic adjustment of formulae from an area to some other location.* Determine the effect of several different sibylline changes of data this facility is called what-if calculation.* Insert, move or call off rows and columns.* Use functions such as sum, average, max, min in formulae* lay down a simple database and sort or query the data to produce a traverse of, sa y for example, all males gaining over a C grade, for a list of students.* Write macros to automate ordinary procedures* Create templates Spreadsheets with formats and formulae already entered, into which tonic figures may be inserted.* Create multi dimensional spreadsheets using several sheets, and write data from one sheet to another* Create many different types of chart and graphsDATABASE MICROSOFT ACCESS 2000A database is a collection of data. It may be something as simple as a list of names and addresses or flesh out 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 about a customer and their car.The main difference between a manual and computerised databases is the speed at which data can be a ccessed.PRESENTATION GRAPHICS MICROSOFT POWERPOINT 2000Presentation graphics software such as PowerPoint is useful for set together a presentation which can be delivered using a computer attached to a projection device, using transparencies and an ordinary overhead projector or as a self-running presentation in, say a shopping centre or cinema. The software allows the user to quickly create slides combining text, graphics and pictures and to create animation or sound effects and passage effects between slides. run SYSTEM MICROSOFT WINDOWS 98Hardware AvailableThese are the specifications of the PC I am using at HomeOPERATING SYSTEMWINDOWS(r) 98 PLUScentral processing unitINTEL(r) CELERONTM / 333MHZ impound64MB FOR WINDOWS(r) 98SCREEN DISPLAY800 BY 600 PIXELS professedly COLOUR (32 BIT)CD-ROM revivify32-SPEEDAVAILABLE shoes ON HARD use up2.4GBAUDIO16-BIT fail CARDOTHERLOUDSPEAKERSThese are the system specifications for the systems at schoolOPERATING SYSTEMWINDOWS(r) 98CPU433MH ZRAM32MB FOR WINDOWS(r) 98SCREEN DISPLAY640 BY 480 PIXELS256 COLOURSCD-ROM SPEED24 SPEEDAVAILABLE SPACE ON HARD DRIVE10MBAUDIO8-BIT SOUND CARDPRINTERHP LASERJET all in all systems should father Microsoft Office 97/2000.All systems must chip in Microsoft go past 97/2000. destruction Users IT LiteracyThe end user of my system will already have staple 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 training 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 stockpile data efficiently. Therefore, training costs will be kept to a minimum.Final ChoiceHaving looked at the current system and the software and hardware available, I have decided to use Microsoft Excel, a spreadsheet program to design my booking system. Spreadsheet packages allow a user to create worksheets (spr eadsheets) 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 support a wide range of facilities making the labor movement easier to perform.SKILLS Current/To be acquiredI have a good understanding of the Microsoft Excel package. I have done quite a few calculations and performed basic macros. Having looked through the coursework of former students, and reading through the coursework guide, I realise that I need to improve my friendship of Excel. Excel is a powerful package and can carry out many tasks easily if instructed correctly. I have already started to go through warning projects showing me how to go about certain tasks with a book titled Successful I.T. Projects in Excel, written by P.M Heathcote.End User Requirements leave alone 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 backup for all centralize records daily and weekly. Provide an exception report for superior customer debts or extreme bank identification limits. The system should record financial details concerning notes 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 promptly on customer request. Backup should occur automatically every 24 minutes. Flight details processed every Friday (1 hour max) Exception reports are produced quickly on necessity within a minute.Qualitative Criteria The system should give up a workable Human Computer larboard system according to different users, i.e. simple menu selections o r buttons The company logo is consistent on all forms and reports. Amount of available screen data is kept to a minimum (increase usability) Help systems are easily accessible.