• 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

System Testing of project

Extracts from this document...

Introduction

Testing Test number Test How it will be tested Expected result Result 1 See if main menu macro works Implemented on each screen except main database. By clicking on this button it will take me to my other excel sheets Result: As you can see the test is working I can access other pages from the main menu page, in this screen I am accessing the order sheet page. Test number Test How it will be tested Expected result Result 2 See if add new stock macro works I will record new macro on the excel sheet The new stock information should be added to stock database Result: The results are as I expected when the user enters detail in the add new stock page this information. Will then be transferred to the stock database. Test number Test How it will be tested Expected result Result 3 See if add new supplier macro works I will record new macro on the excel sheet The new supplier information should be added to supplier database Result: As you can see the information from add new suppliers has been added to the supplier database, so the test is working. ...read more.

Middle

H-3 to h18 a total is worked Out. Result: The test is working as a total price is worked out after you add all the sums together. Test number Test How it will be tested Expected result Result 6 I will lock cells so user cannot change the formulae I will use lock cell function This means no one can edit these cells to change the formulae. Results: I am unable to touch any cell except the quantity sizes and the items sold, as you can see I am only able to put the mouse selection on those data names. So my test is positive and works. Test number Test How it will be tested Expected result Result 7 Able to print out order sheet of items purchased from supplier. Use a macro on the order sheet. By clicking the print macro this will give me a copy the order sheet. Result: The order sheet is printed out, by clicking on the print macro screen, I have attached a print out of the order sheet. ...read more.

Conclusion

Test number Test How it will be tested Expected result Result 11 Number validation Use validation to see if I can only enter values from >=1 , <=5000 If values entered go above 5000 an error message would appear. Result: The validation added means total amount cannot exceed �5000, if the total amount does go over �5000 an error message is shown just as above. Test number Test How it will be tested Expected result Result 12 Vlookup to find suppliers name using phone number Vlookup used manual entry of phone number and suppliers name should appear The suppliers name should instantly appear after entry of Phone number if not an error. First I typed in a Vlookup function, so it would look up the supplier's sheet in order to find the phone number. Result: As I have shown above when the Vlookup function is used the formula result shows a correct number. Test number Test How it will be tested Expected result Result 13 Password protected system Use password so only users and employees can use system When system is opened password would be needed for entry which end-user and his employees know. ?? ?? ?? ?? Tarif Talukdhar ...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 Information Systems and Communication 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 Information Systems and Communication essays

  1. Marked by a teacher

    Database Coursework on a Vehicle Rental System: Analysis

    5 star(s)

    date a rental is due back as well as the total price of the rental, and overdue fees will be calculated automatically and exponentially, with an additional charge for the number of miles of travelled. Queries will be able to be performed on the system for things such as a

  2. transmission of care values

    Other Factors Within Group Interaction Being concerned about self-image could affect any of the children within the group who may be shy about themselves, and may feel uncomfortable about being in this situation. One or more children within the group may dominate the interaction, stopping other children from expressing their ideas by talking over them.

  1. ict as level coursework

    This feature is extremely beneficial to the company as of it main concerns was how it took too long to work out the actual price of products because the previous method was simply worked out by the employee via paper and calculator which is prone to error.

  2. User Guide to my minibus hire database.

    The record will then be completely deleted from the database. Deleting a minibus record To delete a minibus' record simply click the "Delete Record" button as shown in the screenshot above. A warning message will then appear as shown above asking you to confirm the deletion of the record, click

  1. Cunha &amp;amp; Ribeiro Ltd: Stock Control &amp;amp; Invoice Database

    The Current System Fact Recording: 1 In order to confirm the problem given to me by Mr. Ribeiro, I have devised the following questionnaire for him to answer that also contains the answers that he has given me: 1. Is your current system electronic or paper-based?

  2. Database Coursework on a Rental System: Design

    Queries: - Queries can be used in Access to extract useful information from the database. There are various types of queries that can be used. Select queries extract data from tables based on specified values, find duplicate queries display records with duplicate values for one or more of the specified

  1. Evaluation of my database project for a car sales business.

    This table shows that the edited data has been stored on the database system Delete function: The new record that was created can be deleted by clicking on the Delete Record button. A dialog box appeared to confirm the delete action and I clicked on Yes to delete the selected record.

  2. ICT revision notes - IT project management

    âWhere there is pressure for the immediate implementation of something – so that the users can use part of the project early on. âWhere project team members are experienced – so that they can use their own experience to cut out steps which take time.

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