• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20

Tod's Tyres is a small business that supplies new car tyres to company car fleets and car hire firms. I have been asked to create a computer application, either programmed or using a database, to replace the current manual record-keeping system.

Extracts from this document...

Introduction

Contents Contents 1 Design 2 Definition of data requirements 2 User interface design including output, forms and reports 3 Method of data entry, including validation 5 Record structure, file organisation and processing 5 System design 11 Security and integrity of data 12 Implementation/Testing 13 Design Background Tod's Tyres is a small business that supplies new car tyres to company car fleets and car hire firms. I have been asked to create a computer application, either programmed or using a database, to replace the current manual record-keeping system. Definition of data requirements When a car is brought to Tod, the following information is recorded on the card "CARDTBL": (invoice number), (car registration number), (company name), (type of tyre), (date), (car mileage), (number of new tyres fitted), (comment) and (total price). The next time the company books in a recorded car for new tyres, Tod checks the cars file to see what type of tyre that car has fitted; he then ensures hat he has the required tyres in stock: "PRICELISTTBL" (type of tyres), (manufacturers code) and (customer's price ex VAT). Tod gets his tyres from one supplier only. ...read more.

Middle

Query used to determine those whose cars have not been fitted with new tyres for over 12 months I have named this particular query overdue and it basically calculates which customer has not had any tyres fitted for over a year since their last fitting. The formula used here is entered under the criteria for the field date. "<Date()-365" Design of mail-merged document - a letter is sent to people who have not had their tyres checked on their vehicle for a period of over twelve months... Create and print form letters 1. On the Tools menu, point to Letters and Mailings, and then click Mail Merge Wizard. 2. Under Select document type, click Letters. The active document becomes the main document. 3. Click Next: Starting document. 4. Click Use the current document. You can then either type the letter in the document window, or wait until the wizard prompts you to do so in a later step. 5. Under Select recipients, click Use an existing list. 6. Click Browse. 7. In the Select Data Source dialog box, locate and click the data source you want. ...read more.

Conclusion

Add validation text, to make error box appear 15 Test validation Check field size for street address is 50 Message box No message box appears and invalid data is not accepted. Add validation text, to make error box appear Evidence Test 1 - To check the system only allows Car Registration numbers of the post-2001 format. Test 2 - To check invoice is produced with all specified information. Test 3 - To check standard reminder letter is correctly produced. Test 5 - check security (Type correct password). Test 6 - check security (Type incorrect password). Test 7 - check security (Leave password blank). Test 8 - test formula (Check discount is subtracted correctly). Test 9 - test formula (Check VAT is added correctly). Test 10 - test formula (Check query "overdue" calculates customers who have not had new tyres replaced over 12 months). Test 11 - test validation (Check number of tyres fitted does not exceed 5). Test 12 - test validation (Check if input mask used for post code is correct). Test 13 - test validation (Check discount only allows either 0% or 5%). Test 14 - test validation (Check field size for company name is 25). Corrective action: Tod's Tyres - The Practical Exercise 2004 1 Steven Duong ...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 Computer Science 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 Computer Science essays

  1. Marked by a teacher

    Designing a data system for a vintage clothes business.

    3 star(s)

    If not in stock she tells client its unavailable. Luki takes payment by cash then hands over item OR Luki gets sent cheque/cash and sends order off in post Luki then writes down what she has sold, how much it cost, who the person was who order it.

  2. Peer reviewed

    HCI shortened for Human Computer Interaction is the study of the human and computer ...

    3 star(s)

    o Geon's and Gross 3D shapes; Geon's and Gross 3D shapes enable the consistency when images are being reproduced. Geon's are made up of a property that allows viewers to see the images from almost any angles. It has less complexity when in the stage of being designed.

  1. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    in the form of wage types for other important amounts (statutory net pay or transfer amount). The organizational assignments valid for all periods are also created within Payroll as well as special cost assignments, and the wage types are assigned to this information.

  2. Stace &amp;amp; Dunphy (2001) identify five dilemmas of change

    A wide range of program and policy sectors use empowerment evaluation, including substance abuse prevention, HIV prevention, crime prevention, environmental protection, welfare reform, battered women's shelters, agriculture and rural development, adult probation, adolescent pregnancy prevention, tribal partnership for substance abuse, self-determination and individuals with disabilities, doctoral programs, and educational reform (the Accelerated Schools Project - a national educational reform movement).

  1. I have been given the task to design a database for a company called ...

    a flat file database so you can also create relationships between tables of data. * It has a query language, which means it can perform advanced searches. * You can hide certain forms out of view. * You can put a password on the system to prevent people tampering with it.

  2. With diagrams compare and contrast the relative advantages and disadvantages of digital transmission over ...

    (See diagram below) The original signal can then be reconstructed exactly. However, we must remember that the information is transmitted by digital methods. This can only approximate the original analogue sound. There are two of the reasons for this. Firstly, as we have mentioned, the level of the audio signal

  1. Spare Parts Database Project

    OK 3 Click on 'Exit' The program must close. OK Module: Main Menu TEST NO. TEST EXPECTED RESULT REMARKS 1 Click on 'Customer File' command button. Customer File must appear on the screen. OK 2 Click on 'Item File' command button. Item File must appear on the screen. OK 3 Click on 'Transaction File' command button.

  2. ict implementation

    should open The "homepage" worksheet should open 8 Click the command button "invoice" To check the "Invoice" opens The overall Invoice" should open The "Invoice" worksheet opens 9 Click the command button "hide grid lines " To check if the gridlines disappear when clicked The grid lines should disappear The

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