Test Plan for my database

Jess Kimber Test Plan Databases Test No.Related ObjectivePurpose of TestTest Data(Extreme or Valid data)Expected ResultActual ResultScreenshot reference Query – Overdue DVD using Range Check1Find out the DVDs, which should have been retuned, in the last week. (15/03/07) Extreme 15/03/07 1 entry 1 entry Screenshot_!2Extreme22/03/073 entries 3 entriesScreenshot_!3Valid19/03/071 entry 1 entryScreenshot_! Query – Parameter Query - Surname12 The query searches for any customer when the surname is entered into the parameter box. Jackson0 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_A3 Roberts 1 entry Pass – There is one customer with the surname “Roberts” on file.Screenshot_B Query – Parameter Query - Certification1The query searches for any DVDs with the certification

Password

Confirm Password

I agree to the terms of service and privacy policy

This is a preview of the whole essay

entered into the parameter box. 127 entries Pass Screenshot_C2110 entries Pass – There are no DVDs with certification “11” as it an invalid DVD certification.3 1514 entriesPassScreenshot_D4 183 entriesPassScreenshot_E Query – Parameter Query - Genre1 The query searches for any DVDs with the genre entered into the parameter box. Family 6 entries PassScreenshot_F2 Science Fiction 0 entries Pass – There are no “Science Fiction” DVDs, however an abbreviation of this would be “Sci Fi” which is a valid genre.3Comedy6 entriesPass – There are 6 “Comedy” DVDs on fileScreenshot_G4 Sci Fi6 entries Pass – There are 6 “Sci Fi" DVDs on file. Screenshot_HInput Mask – Date of birth – DD/MM/YYYY1The input mask (00/00/0000;0;_) ensures data is entered in days, months and years. E.g. 10th April 1992 would be 10/04/1992.88/88/88880 entries Pass – This entry does not match the requirements of the input mask.Screenshot_I224/10/19861 entry Pass – There is one customer with the DOB 24/10/1986 on file. Screenshot_J315/06/19940 entries Pass - There are no customers with the DOB 15/06/1994 on fileData Validation – Initial Capital Letter1The data validation ensures a capital letter is used at the start of a word. (e.g. first name and surname).Patrick1 entryPass – “Patrick” matches the specified requirements of the input mask as the field automatically starts with a capital letterScreenshot_K2PATRICKFailPass Automatically changes the data to the specified requirements of the input mask.3pATRICKFailPass- Automatically changes the data to the specified requirements of the input mask.4PaTrIcKFailPass Automatically changes the data to the specified requirements of the input mask.Command Buttons1Command buttons allow the user to navigate within the database.“Add New Customer”PassPass – Performs the action specified by the name of the command button which adds a new customer to the database. Screenshot_L2“Delete Customer”PassPass – Performs the action specified by the name of the command button which deletes the customer from the database. Screenshot_M3“View Next Customer”PassPass – Performs the action specified by the name of the command button which displays the information for the next customer in the database.Screenshot_N4“View Previous Customer”PassPass – Performs the appropriate action specified by the name of the command button which views the information for the previous customer in the database.Screenshot_O5“Add New DVD”PassPass – Performs the appropriate action specified by the command button which adds a new DVD in the database.Screenshot_P6“Delete DVD”PassPass – Performs the action specified by the command button which deletes the DVD from the database.Screenshot_Q7“View Next DVD”PassPass – Performs the action specified by the command button which displays the information about the next DVD database.Screenshot_R8“View Previous DVD”PassPass – Performs the action specified by the command button which displays the information about the previous DVD in the database.Screenshot_S9“View Next Loan”PassPass – Performs the action specified by the command button which displays the information about the next loan in the database. Screenshot_T10“View Previous Loan”PassPass – Performs the action specified by the command button which displays the information about the previous DVD.Screenshot_U11“Add New Loan”PassPass – Performs the action specified by the command button which displays the information about the previous DVD.Screenshot_V12“Delete Loan”PassPass – Performs the action specified by the command button which displays the information about the previous Loan.Screenshot_W13 “Close Database”PassPass – Performs the action specified by the command button which closes the database. Screenshot_XMacros 1Performs 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”. PassPass – Performs the following actions: Saves the open form, Closes the current form and opens up the switchboard (main menu). Screenshot_Y