How to work with columns

Load one of the DBs used in the previous lessons:

(1) Click on the Vizubi tab in the ribbon.
(2) Click on the Open button in the Database group.
(3) Browse until you find “C:\Documents and Settings\All Users\Documents\Vizubi\SampleData\” then select “getting started.ndb”.
(4) Click on the Open button to load the file.

(1) Click on the Edit button in the Database group of the ribbon. This will open the Vizubi Editor.

(1) Click on the column in the table you want to modify.
(2) This will activate the Column Tools tab.

To hide a column:

(1) Click on the Hide and Unhide button in the Column Options group. This will open the Hide and Unhide Columns window.
(2) Uncheck the columns you don’t want to view in the Visible column.
(3) Click on OK to confirm.

Now only the columns checked in the Hide and Unhide Columns window are visible.
Although they are not visible, the columns and the data in the columns have not been deleted.
You can unhide columns by opening the Hide and Unhide Columns window and selecting those columns you want to see.

To delete a column:

(1) Click on the column you want to delete. This will activate the Column Tools tab.
(2) Click on Delete Column. This will open the Confirm window.
(3) Click on Yes to confirm deletion.

(1) The column selected has been deleted permanently.
(2) Click on the Hide and Unhide button.
(3) The deleted column is no longer on the list in the Hide and Unhide Columns window.

If there were relationships between this column and columns on different tables, those relationships will be deleted.

To rename a column:

(1) Double click on the column you want to rename. This will open the Modify Column window.
(2) Type the new name in the Label box.
(3) Click on Confirm to confirm the changes.

(1) OrderID now has a new name: OrderCode.

Any relationships that existed between that column and columns in other tables will be maintained.

To modify data format:

(1) Click on the column whose format you want to change (in this case TotalPrice).
(2) Click on the arrow to the right of Format box to open the dropdown menu.
(3) Select a new format (for example: Number (Decimal) ).

(1) The TotalPrice column now shows decimal values.