• 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)

    list of vehicles due back on a certain day, a list of all overdue vehicles, the contact details of a particular customer, staff member or manufacturer contact and whatever else is considered during the design of the system. Problem with Current System After a careful analysis of the results from

  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

    Therefore this user requirement has also been fulfilled. All validation checks must work Unfortunately I was unable to put in any validation checks in my system at all. This is a problem for my system as errors can occur by the user especially when entering postcodes and telephone numbers.

  2. User Guide to my minibus hire database.

    To do this first open up the table located in the navigation pane to the right like so: Once you have the table open, simply click on the record you want to delete, right click, and select the "Delete record" option like so: Again you will be prompted with a

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

    Is your current system electronic or paper-based? The current system is paper-based. 2. Who are the users of your current system? I am the main user of the system 3. Do you think that your system is common within its sector? Yes, I think that most other furniture shops use mainly paper-based systems but they may have computers as well.

  2. Database Coursework on a Rental System: Design

    For example, in a field such as "title" that is to precede a customers name, the values that can go in this field are typically limited to Mr, Mrs, Miss and Dr. It makes no sense to allow users to manually type one of these values into the system each time there is a new customer.

  1. ICT Spreadsheet System

    > Locating details in the filing cabinet requires the searcher looking through loads of files to find the appropriate information. As it is paper based it can be damaged very easily - it is very fragile. Why computerisation will benefit the business?

  2. ICT revision notes - IT project management

    Advantages âIt allows for more user involvement as the customer can see what is being produced at each stage – this makes for a better solution as users have given their input throughout the development. âIt places higher emphasis on prototyping and user interface in the early stages – this means that there is less documentation and more deliverables.

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