• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Test Plan for my database

Extracts from this document...

Introduction

Test Plan Databases Test No. Related Objective Purpose of Test Test Data (Extreme or Valid data) Expected Result Actual Result Screenshot reference Query - Overdue DVD using Range Check 1 Find out the DVDs, which should have been retuned, in the last week. (15/03/07) Extreme 15/03/07 1 entry 1 entry Screenshot_! 2 Extreme 22/03/07 3 entries 3 entries Screenshot_! 3 Valid 19/03/07 1 entry 1 entry Screenshot_! Query - Parameter Query - Surname 1 2 The query searches for any customer when the surname is entered into the parameter box. Jackson 0 entries There are no customers with the surname "Jackson" Pass - There are no customers with the surname "Jackson" on file. 2 Smith 1 entry Pass - There is one customer with the surname "Smith" on file. Screenshot_A 3 Roberts 1 entry Pass - There is one customer with the surname "Roberts" on file. Screenshot_B Query - Parameter Query - Certification 1 The query searches for any DVDs with the certification entered into the parameter box. ...read more.

Middle

Screenshot_J 3 15/06/1994 0 entries Pass - There are no customers with the DOB 15/06/1994 on file Data Validation - Initial Capital Letter 1 The data validation ensures a capital letter is used at the start of a word. (e.g. first name and surname). Patrick 1 entry Pass - "Patrick" matches the specified requirements of the input mask as the field automatically starts with a capital letter Screenshot_K 2 PATRICK Fail Pass Automatically changes the data to the specified requirements of the input mask. 3 pATRICK Fail Pass- Automatically changes the data to the specified requirements of the input mask. 4 PaTrIcK Fail Pass Automatically changes the data to the specified requirements of the input mask. Command Buttons 1 Command buttons allow the user to navigate within the database. "Add New Customer" Pass Pass - Performs the action specified by the name of the command button which adds a new customer to the database. ...read more.

Conclusion

Screenshot_S 9 "View Next Loan" Pass Pass - Performs the action specified by the command button which displays the information about the next loan in the database. Screenshot_T 10 "View Previous Loan" Pass Pass - Performs the action specified by the command button which displays the information about the previous DVD. Screenshot_U 11 "Add New Loan" Pass Pass - Performs the action specified by the command button which displays the information about the previous DVD. Screenshot_V 12 "Delete Loan" Pass Pass - Performs the action specified by the command button which displays the information about the previous Loan. Screenshot_W 13 "Close Database" Pass Pass - Performs the action specified by the command button which closes the database. Screenshot_X Macros 1 Performs more than one action at the same time. This macro is on each form except the switchboard and allows the user to navigate within the database "Back to Main Menu". Pass Pass - Performs the following actions: Saves the open form, Closes the current form and opens up the switchboard (main menu). Screenshot_Y ?? ?? ?? ?? Jess Kimber ...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 Management & Manipulation of Information 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 Management & Manipulation of Information essays

  1. Background and investigation for designing a database for a DVD rental shop.

    The member of staff then has to back track through the rental forms to find the rentals details, which is then signed off with the date returned. The membership card that is in the case is then returned to the member.

  2. Project Plan Forecast

    team and SAP team Oral Formal: Oral Presentation, staff round table, question and answer Oral Informal: Individual and Group Discussion Regularly-scheduled team meetings (2/weeks): and as needed 2 Network Design Stage July 1, 2007 July 30, 2007 Programmer and IT consultant Written Formal: Hard copy document Oral Formal: Video conferencing,

  1. Home Office LTD company. Database

    This screenshot above shows how using a macro will not allow the user to enter a new client on to the database. One way of resolving this issue is that the user can type the data in the spreadsheet under the column headings and under the other customers.

  2. A relative of mine works for a corporate firm on CRM (Customer Relationship Management) ...

    Jill Dyche (2002) agrees that treating customers like cattle is the antithesis of CRM and the main goal should be to "recognize and treat each customer as an individual" (p.7). This means that if one customer is dissatisfied, he will give a negative feedback to other customers.

  1. Intermediate GNVQ Sample Database Assignment - Bolton Tools Database

    48.75 � 60.00 � 70.70 � 75.00 22 � 42.50 � 55.25 � 68.00 � 80.75 � 85.00 23 � 45.00 � 58.50 � 72.00 � 85.50 � 90.00 24 � 47.50 � 61.75 � 76.00 � 89.55 � 95.00 Description of user's needs The manager wants a system which

  2. The Development of Object-Oriented Database Systems.

    and as such do not allow for user-defined data types. In comparison to the simplistic model of a relational database system, object-oriented database systems include features that allow for a user-extensible type system, and complex composite data values, thus enabling the modelling of much more complex real-life business and non-business systems.

  1. Video World Database as ICT project.

    Basically everything including customers, videos, staff and rentals are all written out manually onto a standard form every time something needed to be updated. There are a few problems with this filing system: Keeping track of when videos are due back.

  2. The application to be researched is a small company called RS EQUIPMENT. The company ...

    David Johnson) - I will gather information on the functions and activities of the I.T. department; * The users of the I.T. Department - Observation of the users will give me information on how work is organised and completed in the I.T.

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