• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Formula 1 Autocentre will require a computer based system to solve the problem within the organisation.

Extracts from this document...

Introduction

1.2.3 Alternative Solutions At the moment Formula 1 uses a manual filing system that consists of records stored onto paper and the filed. I have identified that Formula 1 Autocentre will require a computer based system to solve the problem within the organisation. The first possible method I have considered is another manual filing system. This would be a waste of time, as it will create further problems as the system becomes larger. However it would be the cheapest solution as there is no specialist software needed. Data would still have to be inputted manually, stored and onto non-carbon required paper. The second possible method I considered was a spreadsheet system, as this would give more precise calculations of invoices, stocks and labour costs. It may also help to provide a way to make estimates more accurate to a price of a repair. I can also use the built in functions of a spreadsheet program (formulas) to my advantage for the ease of calculations. Another feature that may help would be to create graphs and charts. However it will be very difficult to create a way to input data or design a data entry form. ...read more.

Middle

The link of common fields allow data from different tables to be easily combined so that reports and searches identified later, these can be created by a member of the team as and when required. I have researched into different types of database management systems. Microsoft Access version 2002 XP would offer a first time database user support for managing and analysing data to create a sophisticated database. The new Microsoft access has many new features that will help Mr Parker to have a more sufficient system. The computer program Microsoft Access has the ability to relate tables with common fields; it can allow three different possible degrees of relationship between the tables. Access also allows the user to customise the menus and forms these can be guided by wizards. Access automatically builds an index for a table using a key field. Validations and verifications can be inputted. Complex AND/OR queries can be performed these are multiple criteria's to find records. Access can enable the user to create their own data entry forms this can make data entry and editing easier. ...read more.

Conclusion

A finder assistant wizard lets the user create and store complex queries with step by step assistance. Quickly find top or lowest values, unique records, duplicates and more. Power click report writer allows the user to create professional reports designing them accurately by seeing how data will appear in print modes. Crosstabs queries can be used to perform sophisticated data analysis. Charts to present data can also be created in Approach. www.Lotus.com The Corel Paradox 9 is database that is designed for new users, experts and developers. Paradox 9 is an easy to use powerful relation database; it can allow amateur users to get started quickly with easy to use templates and online tutorial. Paradox 9 allows data to be shared across applications such as outside applications like Microsoft word and excel. Advanced Customisation of forms and reports to suit the users needs backed up by the use of specified toolbars. Paradox 9 enables the user to publish, retrieve and manage data on the web, and can redesign table structures to ease usability. Corel have still the traditional reports and charts to represent data. www.Corel.com A LEVEL ICT COURSEWORK INVESTIGATION AND ANALYSIS ALTERNATIVE SOLUTIONS 1 DIPEN SHAH BEAUCHAMP COLLEGE ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Management & Manipulation of Information section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Management & Manipulation of Information essays

  1. Marked by a teacher

    Capital Radio

    If they worked manually, they would be in chaos. Firstly, it would take along time to write everything and secondly, if they needed to send something to someone immediately it would arrive too late, next day. But with email that can't happen so if capital didn't use email they would be in shambles!.

  2. Designing a booking system for an Estate Agent.

    A double booking is likely to occur as the diary doesn't have a clear layout and a timetable. The diary does contain tables but this only sorts to date where they write information of the appointment. Writing information would be time consuming compared to if they were to use a computer system.

  1. ICT coursework: Designing and implementing a book rental system

    able to perform the following tasks: * Allow staff to add, delete, looked-up, edited and stored quickly and accurate things. * Allow books to be taken stored and taken out quick and easy my members and also staff. * Allow books to be searched to help the customer's problems.

  2. Database Design

    Testing This is how I will test the database: * Test each object (form, report, and query) to make sure it meets requirements. * Testing each menu item and command button under differing circumstances. * Testing the effects of invalid and extreme data.

  1. The purpose of this document is to provide a design for an electronic payment ...

    Mansfield, Paul et al. 2003 Electronic photo gallery <http://www.dur.ac.uk/cs.seg04/seg04_design.doc> (Accessed 01.12.2004). Gooch, Tom. 2000 What is UML? <http://pigseye.kennesaw.edu/~dbraun/csis4650/A&D/UML_tutorial/what_is_uml.htm> (Accessed 01.12.2004). Burd, Liz 2004. Software Engineering for the Internet notes <http://www.dur.ac.uk/liz.burd/local/SEI> (Accessed 01.12.2004). 1.5 Changes to S3G Requirements This section includes the alterations to the S3G group requirements for the original system and the requirements added for the new payment system.

  2. I have been asked by a General Sports shop using a manual system to ...

    Data structure Field Name Data Type Description Surname Text The persons last name Forename Text The persons first name DOB Date/Time The persons date of birth Deck Text The deck the person has Address Text The persons home address Length of membership Text The length of the membership Paid membership

  1. Planning a payroll system for a martial arts school.

    * Overtime is paid at the one and a quarter of the hourly rate. * The maximum number of hours that a worker should work is 60. If the number of hours goes above 60 the payroll should still be processed but an alert must be made to the manager for approval.

  2. I was hired by Mr Davies to create a website for a newly built ...

    navigation page on website * From Details from visitor of the website Make icons, menus tick boxes. Insert html Have right details from visitor page. Notice Board Page * Banner Write the companies Crop the banner to fit the page Have banner on website * Logo Companies logo Crop re-size to the correct size insert into html.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work