OpenOffice.org Base: Editing Information in a Database

Written By
BB
Bruce Byfield
Mar 19, 2009

“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

BB

Bruce Byfield

Linux Today Logo

LinuxToday is a trusted, contributor-driven news resource supporting all types of Linux users. Our thriving international community engages with us through social media and frequent content contributions aimed at solving problems ranging from personal computing to enterprise-level IT operations. LinuxToday serves as a home for a community that struggles to find comparable information elsewhere on the web.

Property of TechnologyAdvice. © 2026 TechnologyAdvice. All Rights Reserved

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.