• 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

    I had mentioned earlier on, the slides aren't in the right order so it actually confuses the audience about what it what. If the slides were put in the right order and simple vocabulary was used, then everything would be clearly understood.

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

    Additionally, the hyperlinks are included to make the spreadsheet look more professional. To add hyperlinks you do the following: 1)Choose a picture/icon you want to hyperlink. I decided to have a picture of a house, on each results page and on my annual report, to show that if you clicked

  1. ICT BTEC UNIT 2 - REPORT

    Both of these packages seem to be built to make it easier for you and these fantastic packages are: * Adobe Dreamweaver CS3 * Xsite Pro The only thing I would say lets it down for Adobe Dreamweaver is its price at the minimum of �399 which is hardly a

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

    The first sheet willl have the front page, middle page and the last page. This first sheet will only contain information about the restaurant such as the contact, map, the history of the restaurant etc. the second sheet will also have 3 sides all containing the different dishes their prices.

  1. Spreadsheet for a basketball company

    The version of the Excel that is included is more than capable of delivering proficient result. Since Microsoft Office includes MS Outlook , it can be utilized for an alternate source of data collection and contact with the customers. 2.3.

  2. Project 1b; Film Database

    One thing that makes Excel partly suitable for this task is the typed in data enabled of being in a variety of formats.

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

    By this I am referring to, that it is hard to change the spreadsheet into a fashionable and nice display, as it is specifically designed for calculating data and producing information from it. This is why it is often a good idea to copy and paste your work from a spreadsheet to a Word processor when displaying work.

  2. implementation report

    by wizard' Appendix 12 Appendix 12 shows that when I clicked on the tab 'create form by using wizard' the following wizard appeared asking me to choose the table I want the form to contain , so I clicked on loans, because I wanted to make the loans form.

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