Otherwise, just as when you edit fields, you add new entries at the bottom. With this selection, you see the fields listed at the top of columns and the individual records in rows. If you want to add a record to the database, select Open from the context menu in the Tables pane, or double-click the table to open the editing window. You also can alter, delete or move existing records using the same technique. When you are done, right-click on the gray left-hand column to select the new field, and use the context menu to cut and paste it into the position you want. 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. 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. As with other fields, you need to enter a name in the first column and a field type in the second column. Click the first vacant role to start adding a new field. If you want to add a field to the database, select Edit to open a view of the table. Then, select the Table in the Tables pane, and right-click for the context menu. 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.

It is not hard to do, but some users find it intimidating and may prefer one of the other methods.

Whichever way you create a form, you can then use it as a more user-friendly way to edit your database.Įditing a table directly is the purist's way of adjusting a database. If you created a database using an existing Calc or MS Excel spreadsheet, you must edit the spreadsheet itself-in Base, the database will open read-only, and you will be unable to edit it.įor other databases, you have three choices: editing the tables directly, using the form wizard to create a form or using the design view to create a form. Once you have a database set up, sooner or later you will want to edit its tables or add a new record.

Open office base