Difference between revisions of "QA/Tescase"
Liupingtan (talk | contribs) |
(+cat) |
||
(13 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
+ | |||
==General Testing Test Cases == | ==General Testing Test Cases == | ||
Line 5: | Line 6: | ||
|- | |- | ||
| | | | ||
− | <center> | + | <center>'''Component'''</center> |
| | | | ||
− | <center>''' | + | <center>'''Function Category(top suite)'''</center> |
| | | | ||
− | <center>''' | + | <center>'''Function(2nd suite)'''</center> |
| | | | ||
− | <center>'''Test | + | <center>'''Function Point(3rd suite)'''</center> |
+ | | | ||
+ | <center>'''Test Case Design/Summary(test case)'''</center> | ||
|- | |- | ||
| | | | ||
Line 17: | Line 20: | ||
| | | | ||
Database Wizard | Database Wizard | ||
+ | | | ||
+ | <center>Create Embedded database</center> | ||
| | | | ||
Create embedded database | Create embedded database | ||
Line 35: | Line 40: | ||
| | | | ||
− | Connect to an existing database | + | <center>Connect to External business database</center> |
+ | | | ||
+ | Connect to an existing database via JDBC | ||
| | | | ||
The testing cover: | The testing cover: | ||
Line 53: | Line 60: | ||
| | | | ||
− | Connect to an existing database | + | <center></center> |
+ | | | ||
+ | Connect to an existing database via ODBC | ||
| | | | ||
The testing cover: | The testing cover: | ||
Line 66: | Line 75: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Connect to an existing Speadsheet | Connect to an existing Speadsheet | ||
Line 79: | Line 90: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Connect to an existing Text | Connect to an existing Text | ||
Line 97: | Line 110: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Connect to an existing Microsoft Access 2007 | Connect to an existing Microsoft Access 2007 | ||
Line 109: | Line 124: | ||
| | | | ||
− | Connect to | + | <center></center> |
+ | | | ||
+ | Connect to address book''' '''(Microsoft Outlook) | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
address book file also can be opened by | address book file also can be opened by | ||
open text | open text | ||
Line 121: | Line 139: | ||
| | | | ||
+ | | | ||
+ | <center>Register databse</center> | ||
| | | | ||
Register a databse and Use it | Register a databse and Use it | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
# Register database automatically | # Register database automatically | ||
# Register database manually | # Register database manually | ||
Line 135: | Line 156: | ||
| | | | ||
− | Database design entry | + | Database design entry |
| | | | ||
− | Entry | + | <center>Entry</center> |
+ | | | ||
+ | Database objects | ||
| | | | ||
The testing cover: | The testing cover: | ||
# Database objects: Table, Query, Form, Report | # Database objects: Table, Query, Form, Report | ||
− | |||
# Report: | # Report: | ||
# Tasks zone | # Tasks zone | ||
# Description | # Description | ||
# Object Zone | # Object Zone | ||
− | |||
− | |||
# Preview | # Preview | ||
# Status bar: include info about DataBase type, database name/database file path, user, IP. | # Status bar: include info about DataBase type, database name/database file path, user, IP. | ||
Line 154: | Line 174: | ||
| | | | ||
− | + | ||
| | | | ||
− | Create | + | <center>Table</center> |
+ | | | ||
+ | Create table in design view | ||
| | | | ||
The testing cover: | The testing cover: | ||
Line 168: | Line 190: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Use Wizard to create table | Use Wizard to create table | ||
Line 184: | Line 208: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Create View | Create View | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Total same as Query Design Windows | Total same as Query Design Windows | ||
can edit and edit in SQL view. | can edit and edit in SQL view. | ||
Line 196: | Line 223: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Table Data View | Table Data View | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Provide Data Filter and Data Statistics | Provide Data Filter and Data Statistics | ||
Line 206: | Line 236: | ||
| | | | ||
− | + | ||
| | | | ||
− | Relation | + | <center>Relation</center> |
+ | | | ||
+ | Relation View | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Tools->Relationships to pop up Relationship Design Window | Tools->Relationships to pop up Relationship Design Window | ||
Drag and Drop or insert->New Relation | Drag and Drop or insert->New Relation | ||
Line 217: | Line 250: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>Query</center> | ||
| | | | ||
Create query in design view | Create query in design view | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Field Alias,Table.Sort.Visible | Field Alias,Table.Sort.Visible | ||
Function button: Run query, Clear query, Switch design view on/off(switch with SQL editor to check before save, after save this button is disabled | Function button: Run query, Clear query, Switch design view on/off(switch with SQL editor to check before save, after save this button is disabled | ||
Line 230: | Line 266: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Use wizard to create query | Use wizard to create query | ||
Line 246: | Line 284: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>Form</center> | ||
| | | | ||
Create Form in design view | Create Form in design view | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Need macro to activate event | Need macro to activate event | ||
|- | |- | ||
Line 257: | Line 298: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
User Wizard to create Form | User Wizard to create Form | ||
Line 263: | Line 306: | ||
# Field selection | # Field selection | ||
# For table and query | # For table and query | ||
− | # Specify | + | # Specify a subform |
# Layout of created form. Arrange of main form, Arrange or sub form. | # Layout of created form. Arrange of main form, Arrange or sub form. | ||
# Specifies the data handling mode for the new form. | # Specifies the data handling mode for the new form. | ||
Line 272: | Line 315: | ||
| | | | ||
− | + | ||
| | | | ||
− | + | <center>Report</center> | |
+ | | | ||
+ | The report of fields | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
For table and query | For table and query | ||
Line 293: | Line 339: | ||
| | | | ||
− | Main Function/ | + | Main Function |
+ | | | ||
+ | <center>FileSave</center> | ||
| | | | ||
Save/Save As | Save/Save As | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
save file to different types. | save file to different types. | ||
Check the appearance and properties of saved files. | Check the appearance and properties of saved files. | ||
Line 304: | Line 353: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>FileSend</center> | ||
| | | | ||
− | + | Send | |
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Send with different style | Send with different style | ||
|- | |- | ||
Line 314: | Line 366: | ||
| | | | ||
− | + | ||
| | | | ||
− | FileOpen | + | <center>FileOpen</center> |
+ | | | ||
+ | Open | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Open/ save/ reopen different type of files, | Open/ save/ reopen different type of files, | ||
Check files can be opened correctly. | Check files can be opened correctly. | ||
Line 325: | Line 380: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>File Editing</center> | ||
| | | | ||
Editing | Editing | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Check the appearance of Editing operation ,such as undo/redo delete edit | Check the appearance of Editing operation ,such as undo/redo delete edit | ||
|- | |- | ||
Line 335: | Line 393: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>File UI</center> | ||
| | | | ||
Ui | Ui | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Do some operations to check the UI presents correctly. | Do some operations to check the UI presents correctly. | ||
|- | |- | ||
Line 345: | Line 406: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>Copy/Paste/Paste Special</center> | ||
| | | | ||
Copy/Paste/Paste Special | Copy/Paste/Paste Special | ||
Line 360: | Line 423: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>Export and import data of base</center> | ||
| | | | ||
Export and import data of base | Export and import data of base | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Export data from base | Export data from base | ||
+ | |||
Import data to base | Import data to base | ||
Line 372: | Line 439: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>Register database and integrate Usage</center> | ||
| | | | ||
Register database and integrate Usage | Register database and integrate Usage | ||
Line 395: | Line 464: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>Tools</center> | ||
| | | | ||
Tools/SQL for testing sql command | Tools/SQL for testing sql command | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Tools->SQL for test sql command. | Tools->SQL for test sql command. | ||
Line 407: | Line 479: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Tools/Exension manager | Tools/Exension manager | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Add extension plugins. Common used extensions | Add extension plugins. Common used extensions | ||
|- | |- | ||
Line 417: | Line 492: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Tools/Options<nowiki>/Openoffice.org</nowiki> Base connection pool | Tools/Options<nowiki>/Openoffice.org</nowiki> Base connection pool | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Connection pool for performance, but only some defined drivers, these drivers are not used frequently | Connection pool for performance, but only some defined drivers, these drivers are not used frequently | ||
|- | |- | ||
Line 427: | Line 505: | ||
| | | | ||
Accessibility | Accessibility | ||
+ | | | ||
+ | <center>Keyboard Navigator and accelerators</center> | ||
| | | | ||
Keyboard Navigator and accelerators | Keyboard Navigator and accelerators | ||
Line 435: | Line 515: | ||
all test cases with just the keyboard" and refer the expected | all test cases with just the keyboard" and refer the expected | ||
result(navigation and accelerators) to AOO product Help | result(navigation and accelerators) to AOO product Help | ||
+ | |- | ||
+ | | | ||
+ | |||
+ | | | ||
+ | |||
+ | | | ||
+ | <center></center> | ||
+ | | | ||
+ | |||
+ | | | ||
+ | |||
|} | |} | ||
+ | |||
+ | [[Category:Quality Assurance]] |
Latest revision as of 15:33, 23 September 2013
General Testing Test Cases
|
|
|
|
|
Base |
Database Wizard |
|
Create embedded database |
The testing cover:
|
|
Connect to an existing database via JDBC |
The testing cover:
| ||
|
Connect to an existing database via ODBC |
The testing cover:
| ||
|
Connect to an existing Speadsheet |
The testing cover:
| ||
|
Connect to an existing Text |
The testing cover: open text
open csv(address book file)
open custom type file
| ||
|
Connect to an existing Microsoft Access 2007 |
The testing cover:
| ||
|
Connect to address book (Microsoft Outlook) |
The testing cover: address book file also can be opened by open text open csv(address book file) open custom type file | ||
|
Register a databse and Use it |
The testing cover:
| ||
Database design entry |
|
Database objects |
The testing cover:
| |
|
Create table in design view |
The testing cover:
| ||
|
Use Wizard to create table |
The testing cover:
| ||
|
Create View |
The testing cover: Total same as Query Design Windows can edit and edit in SQL view. | ||
|
Table Data View |
The testing cover: Provide Data Filter and Data Statistics | ||
|
Relation View |
The testing cover: Tools->Relationships to pop up Relationship Design Window Drag and Drop or insert->New Relation | ||
|
Create query in design view |
The testing cover: Field Alias,Table.Sort.Visible Function button: Run query, Clear query, Switch design view on/off(switch with SQL editor to check before save, after save this button is disabled | ||
|
Use wizard to create query |
The testing cover:
| ||
|
Create Form in design view |
The testing cover: Need macro to activate event | ||
|
User Wizard to create Form |
The testing cover:
| ||
|
The report of fields |
The testing cover: For table and query Specifies the table or query for which you are creating the report Label the field to the report Group records in a report Select the fields by which to sort the report. Fields can be sorted by up to four levels, each either ascending or descending. Grouped fields can only be sorted within each group. Layout of data, layout of header and footer | ||
Main Function |
|
Save/Save As |
The testing cover: save file to different types. Check the appearance and properties of saved files. | |
|
Send |
The testing cover: Send with different style | ||
|
Open |
The testing cover: Open/ save/ reopen different type of files, Check files can be opened correctly. | ||
|
Editing |
The testing cover: Check the appearance of Editing operation ,such as undo/redo delete edit | ||
|
Ui |
The testing cover: Do some operations to check the UI presents correctly. | ||
|
Copy/Paste/Paste Special |
The testing cover: 1.Copy/paste/table 2.Copy/paste special table 3.Copy/paste query/form/report 4.Copy/ paste to Writer/Calc to Calc, will auto copy the data to writer, will design table colume | ||
|
Export and import data of base |
The testing cover: Export data from base
| ||
|
Register database and integrate Usage |
The testing cover:
Operations in Scenario 3 Drag and Drop table or query in navigate tree to sheet, All definition and data will copy to Sheet/Writer page Data to text:Click Upper left corner to select all data in specified registered database, then click "Data to text" button. All definition and data will copy to Sheet Data to fields: Define fields with 2 ways, Add Insert->Fields->Other, define your fields in "Database" tab. Mouse select field name,drag and drop field name to writer document。 Then select specified record then click "Date to field", field data will copy to specified field. Mail Merge: Mail Merge Wizard entry, this function is commonly used | ||
|
Tools/SQL for testing sql command |
The testing cover: Tools->SQL for test sql command. | ||
|
Tools/Exension manager |
The testing cover: Add extension plugins. Common used extensions | ||
|
Tools/Options/Openoffice.org Base connection pool |
The testing cover: Connection pool for performance, but only some defined drivers, these drivers are not used frequently | ||
Accessibility |
|
Keyboard Navigator and accelerators |
The testing cover: Make sure you can perform all test cases with just the keyboard" and refer the expected result(navigation and accelerators) to AOO product Help | |
|