OpenOffice.org Base: Editing Information in a Database

"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:

• OOo Compare: Inadequate(Mar 13, 2009)
• OpenOffice extensions - When good gets better!(Mar 09, 2009)
• OpenOffice 3.1 is FAST!(Feb 28, 2009)
• OpenOffice.org Base: Creating basic databases and tables(Feb 19, 2009)
• OpenOffice.org - The Fun Has Gone?(Jan 30, 2009)