Linux Today: Linux News On Internet Time.

OpenOffice.org Base: Editing Information in a Database

Mar 19, 2009, 14:32 (0 Talkback[s])
(Other stories by Bruce Byfield)

"Editing a Table Directly
Editing a table directly is the purist's way of adjusting a database. It is not hard to do, but some users find it intimidating and may prefer one of the other methods.

"To edit a table in a database directly, open the database and change the view in the Database pane on the left side of the window to Tables. Then, select the Table in the Tables pane, and right-click for the context menu.

"If you want to add a field to the database, select Edit to open a view of the table. Click the first vacant role to start adding a new field. As with other fields, you need to enter a name in the first column and a field type in the second column. You also can enter the field properties in the window of the pane that opens below the main editing window, setting whether the field is required, the number of characters it can contain and, optionally, a default value and example. In addition, back in the main window, you have the option of adding a brief description of the new field in the unnamed third column."

Complete Story

Related Stories: