OpenOffice.org Base: Editing Information in a Database
Mar 19, 2009, 14:32 (0 Talkback[s])
(Other stories by Bruce Byfield)
WEBINAR: On-demand webcast
How to Boost Database Development Productivity on Linux, Docker, and Kubernetes with Microsoft SQL Server 2017 REGISTER >
"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."