User: clu Date: 06/05/10 07:26:24 Added: /dba/www/QA/ General_Testcases.html
Log: add new page File Changes: Directory: /dba/www/QA/ ======================= File [added]: General_Testcases.html Url: http://dba.openoffice.org/source/browse/dba/www/QA/General_Testcases.html?rev=1.1&content-type=text/vnd.viewcvs-markup Added lines: 151 ---------------- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>OpenOffice.org Database QA</title> <meta http-equiv="content-type"content="text/html; charset=ISO-8859-1"> <meta http-equiv="Content-Style-Type" content="text/css"> <style type="text/css"> @import "/css/dba.css"; .available_in_1x_not_used { background-color:#CCFFCC; } .available_in_20_not_used { background-color:#CCFFFF; } .available_in_680_not_used { background-color:#FFFFCC; } </style> </head> <body> <b>Project Sections</b>: <a href="/index.html">Home</a> | <a href="/howto/index.html">HowTo's</a> | <a href="/specifications/index.html"><b>Specifications</b></a> | <a href="/FAQ/index.html">Tips 'n' Tricks</a> | <a href="/downloads/index.html">Downloads</a> | <a href="/miscellaneous/index.html">Miscellaneous</a> | <a href="/drivers/index.html">Drivers</a><br/> <hr/> <div class="dba"> <h1>Database Access - QA: general Testcases</h1> </div> If you have any questions, anything to add etc. please contact: <a href="mailto:[EMAIL PROTECTED] test">[EMAIL PROTECTED]</a>.<br> If you want to support oo by testing or adding your testresults, please join the <a href="http://qa.openoffice.org";>OpenOffice.org QA project</a> and add your values in <a href="http://www.sunvirtuallab.com/tcm2/tcm_login.cgi";>TCM tool</a> or execute one of the following testcases and send the result to the respective QA member.<br><br> <div class="dba_light"> <table cellpadding="0" cellspacing="0" width="100%"> <tr class="MainTableHeader"> <td colspan="2">available Testcases: (with short content description)</td> </tr> </table> </div> <p> <a href="#db-wizard">Database Wizards general</a> - (Create Database Wizard, Table Wizard, Query Wizard, Form Wizard, Report Wizard)<br> <a href="#further-testcase">further testcase</a> - (in progress) </p> <div class="dba_light"> <table cellpadding="0" cellspacing="0" width="100%"> <tr class="MainTableHeader"> <td colspan="2">Testcase: Database Wizards general</td> <a name=db-wizard> </tr> </table> </div> <p> 0. take a database of your choice<br> <br> - Create Database Wizard -<br> <br> 1. open the database wizard (from menue: file/new/database)<br> -> database wizard appears<br> 2. push 'next' button ('create a new database' is default)<br> 3. push 'finish' button<br> -> save dialog appear<br> 4. give the database any name (f.e. testdb) & save<br> -> database design window appears<br> <br> - Table Wizard -<br> <br> 5. click on the 'tables' container<br> -> corresponding 'tasks' appear<br> 6. choose: 'use wizard to create table...'<br> -> table wizard appear<br> 7. choose any 'sample table' and select some fields (by marking them and using the 'arrow buttons')<br> 8. push the 'next' button<br> 9. try the '- + up down' buttons and then push the 'next' button twice (to get to teh 'create table' page)<br> 10. insert any tablename and push 'finish'<br> -> 'insert data' window appear<br> 11. close 'insert data' window<br> <br> - Query Wizard -<br> <br> 12. click on the 'queries' container<br> -> corresponding 'tasks' appear<br> 13. choose: 'use wizard to create query...'<br> -> query wizard appear<br> 14. choose any table and select some fields<br> 15. push next<br> 16. choose any field from 'sort by' listbox and push 'next'<br> 17. insert any 'condition' and push 'next'<br> 18. choose radiobutton 'summary query' and any 'aggregate function' with corresponding field<br> 19. try the '-' button ('aggregate function' field disappear)<br> 20. push the '+' button and insert any 'aggregate function' again and push 'next'<br> 22. click on any 'group by' field and change the order ('up & down' buttons) and 'next'<br> 23. insert any 'grouping condition' and 'next'<br> 24. change any 'alias' name (by overwriting an existing one) and 'next'<br> 25. insert any query name and push 'finish'<br> -> 'query result' window appear<br> 26. close the window<br> <br> - Form Wizard -<br> <br> 27. click on the 'forms' container<br> -> corresponding 'tasks' appear<br> 28. choose: 'use wizard to create form...'<br> -> form wizard appear<br> 29. choose any table, select some fields and push 'next'<br> 30. check the 'add subform' checkbox and 'next'<br> 31. choose any table, select some fields and push 'next'<br> 32. insert some 'joined' fields and 'next'<br> 33. try any 'arrangement' and 'next'<br> 34. set any 'data entry' and 'next'<br> 35. choose any 'form style' and next<br> 36. give the form a name and push 'finish'<br> -> 'insert form data' window appear<br> 37. close 'insert form data' window<br> <br> - Report Wizard -<br> <br> 38. click on the 'forms' container<br> -> corresponding 'tasks' appear<br> 39. choose: 'use wizard to create report...'<br> -> report wizard appear<br> 40. choose any table, select some fields and push 'next'<br> 41. change some 'label' names and 'next'<br> 42. insert a 'grouping' field and 'next'<br> 43. choose a 'sorting' and 'next'<br> 44. choose any 'layout' and 'next'<br> 45. choose 'static report' and 'finish'<br> -> 'report' window appear<br> 46. close 'report' window<br> <br> - finish - </p> <p> created by <a href="mailto:[EMAIL PROTECTED] testcase: database wizards">clu</a> </p> <div class="dba_light"> <table cellpadding="0" cellspacing="0" width="100%"> <tr class="MainTableHeader"> <td colspan="2">Testcase: further testcase</td> </tr> </table> </div> <p> <a name=further-testcase> text for further testcase </p> </body> </html> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
