Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.7 released

 

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

Apache Events

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.