• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 1147

Testing database. Test plan 1 I am going to check my data restriction. To do so I am going to add a invalid data in the field price, whish is set in currency data type.

Extracts from this document...

Introduction

Testing Test plan 1 I am going to check my data restriction. To do so I am going to add a invalid data in the field price, whish is set in currency data type. The expected result that I am hoping for is that the system would prompt out a warning message. Testing 1 in this screen shot above I have opened my external product table where in price I have added a data restriction in price field. I have selected the field where I am going to add an ivalid data type In the screen shot I have change the data type. As soon as I did this the system prompted out that I have inserted an invalid data. This means I have got my resulted result thus meaning that my system works Test plan 2 I am going to check my data restriction. To do so I am going to add a invalid data in the field Delivery date, whish is set in Date data type. The expected result that I am hoping for is that the system would prompt out a warning message. ...read more.

Middle

My result show that 2 record in customers table now I need to be cross checking from the customers y results from my customer table As seen before I have only two record in the query record I got only two record of mrs in the table as well which means that my parameter value works perfectly:) Testing plan 6 Now I would be carrying out my testing on my criteria which I have set upped. I will be adding a parameter value in the query company's Name and then I would be relating the result from the customer table. I expect that the results I get are correct Testing 6 In the screen shot above I have opened the company's name query and inserted my parameter value emirates. Then I hit enter my results could be seen below. My result shows that I have 1 record in customers table now with the name of emirates. I need to be cross checking from the customers y results from my customer table Test plan 7 I would be carrying out a testing on a query that I made which was Price. ...read more.

Conclusion

I expect that my parameter value displays no results Testing 10 Here I have added an invalid data which was random characters and my result bleow displays no results which means that I have achieved my expected results which also means that my system works. Testing plan 11 Now I would be carrying out my testing on my report and I would be seeing that the Report parameter value works, I also need to change the title of the report from the design view Testing 11 I have opened the my PIA product detail report, so when I double clicked the report the parameter value came up so I opened it by typing in PIA. My results are shown below Know I would be editing the report firstly I am going to change the parameter value to emirates and also changing its heading as it was in the desired outcomes, My emirates records showed up which I knew from the previous testing it only had one record which can also be seen below +- In this screen shot I have changed the title to emirates product details the new report could be seen below. ?? ?? ?? ?? Zaid Tariq 1/16 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software 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 GCSE Software essays

  1. Unit 4 Multimedia -Review for Product 1 KS3 Strategy Presentation

    meets its aim, if noone understands the words, then the text would not be understood, this means that the message would not effectively go through to the audience and so will not achieve its aim. The presentation does describe its purpose and who will benefit from it, but however as

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    Once I had inserted them, I arranged them so that they formed a border at the top of the worksheet, to make it look professional and eye-catching. Although, the teacher will know what the name of the school is, I have included it to show that it does belong to

  1. AQA GCSE ICT Specification B

    11. There must be a 'Total Cost' box on the order sheet, calculating the sum of 'Personalization' and 'Basic' costs. Open a filled order sheet Check that the 'Total Cost' box calculates the sum of 'Personalization' and 'Basic' costs.

  2. ICT BTEC UNIT 2 - REPORT

    From what I have observed both "Magix Website Maker" and "First Page V3 Final" are very basic and have some issues, although small can become very annoying when you put the program into action. Although I don't like Magix Website Maker I must admit that it has one good thing

  1. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    There I am going to create a new sheet by taking brouchers then menu as my option and here I will automatically have 2 sheets with 3 sides each. 2. To surf the net and collect Pictures and see samples of logos, I will directly go on the net and

  2. Spreadsheet for a basketball company

    specified me the details of the ticket verbally in which I took note of. Other expenditures like food, drinks etc Mrs Supru, the accoutant Past records which were manually written in paper. Selling price of food and drinks Mrs Supru, the accoutant Past records which were manually written in paper.

  1. Project 1b; Film Database

    Generally, customers are more willing to spent money on a movie with longer running time. Customers could ask for a long running time, so this can be searched for. * Year - This tells when a movie was first released.

  2. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    if I set the quantity between 1 and 50, if someone will accidentally press the wrong amount that is outside the limit, like 51 or 0 the cell will read error, this cell will be calculated by a formula.

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