| Test Case AOOTest-1765: Create Table in Design View [Version : 1] | ||
|---|---|---|
| Author: | undefined - 15/11/2013 02:48:28 | |
| #: | Step actions: | Expected Results: |
| 1 | Launch AOO and Click "Database". | "Database Wizard" window pops up. |
| 2 | In Database Wizard, check option "open an existing database file" and select recently used db file "Test" from list box then click "Finish" | Existing database file "Test.odb" window opens up. |
| 3 | Click "Tables" then in the Tasks panel click on "Create Table in Design View". | Table Design window opens up with Field Name ,Field Type ,Description and in bottom pane is Field Properties. |
| 4 | Type "BirdName" as first Field Name and select default Field Type as "Text [VARCHAR]" and type in a description for field in the description area or leave description blank. | Under Field Properties it shows : Entry Required---no, Length---50, Default Value---Blank (which are default) or set as desired. |
| 5 | Click in the next row and enter "BirdLength" as next Field Name and change Field Type as "Number [Numeric]"and type in a description for field in the description area or leave description blank. | Under Field Properties it shows: Entry Required---No, Length---50, Decimal Places---1 or set as desired. |
| 6 | Click in the next row and enter "Dominant Color" as next Field Name and change Field Type as "Text[Varchar]" and type in a description for field in the description area or leave blank. | Under Field Properties it shows: Entry Required----No, Lenght----50,Default value----Blank or set as required. |
| 7 | Click the Close button. | A dialogue box opens up asking Do you want to save the changes? |
| 8 | Click the "Yes" button to save table design. | "Save As" dialogue box opens up. |
| 9 | Type Table Name as "Bird"(Do not use spaces in the name),then click "OK". | "No primary key" dialogue box open up. |
| 10 | Click "Yes" on "No primary key" dialogue box to create primary key. | It will returned to Database window and table appears in it with the name "Bird". |
| Execution type: | Manual | |
| Importance: | Medium | |
| Test Focus: | ||
| Feature first available at which release: | ||
| Automation script name: | ||
| Testsuite set: | Functionality | |
| Requirements | None | |
| Keywords: | None | |
