OpenOffice Tutorial: Insert a field in a table
- To insert a field within a table, first go to the tables list and right click on the name of the table you want to edit.
- Then, on the menu that opens click on the option "Edit."
- The table design view should open.
- To start inserting a new field, move your mouse to the left of any field name and right click on the blank area there. Don't worry about the position since this will not matter later.
- Next, on the menu that opens, click on the option "Insert Rows"
- Automatically the new row you've inserted will appear at the bottom of the fields. Now, type in the name you want for the field here.
- Next, if it is needed, change the new field's type here by clicking on it and then choosing a type from its drop down menu.
- Great, our new field "Address 2" is ready. The next step would be to re-order the fields so that our newest field is inserted below the field "Address."
- To do this, we shall "cut" some fields and paste them below "Address 2" to get the order we want.
- Start cutting cells by clicking and holding the left mouse button over the blank area to the left of the first field name that must be cut.
- Then, while still holding the button, move the mouse through the other fields that need to be cut.
- Once they are all selected, release the mouse button and right click over the fields. On the menu that opens click on the option "Cut."
- Good. The field "Address 2" has now moved up on the field list.
- Now, paste back the fields we've cut by right clicking below the "Address 2" field and selecting the option "Paste" on the menu that opens.
- Great! We have re-ordered the fields. Note that "Address 2" is now located here.
- Next, just click on this diskette icon to save your changes.
- Now, sometimes warning messages appear when doing changes to your table. Though at times there are problems with the settings, other times its the inevitable bug.
- In this warning message, one element of the table can't be changed and must be recreated. Just click yes to execute the recommended action indicated and save the table.
- Notice that the City field name has dropped down because of the bug we encountered. Please remember that in most cases the order of the fields are irrelevant to the database unless otherwise specified.
- Since in this example our only concern was to insert the "Address 2" field, we shall leave the movement of the city field as it is.
- Now, click on this "X" icon to close the table design view.
- Congratulations! You have learned how to insert fields within a table.
by Kaj Kandler
Insert a field in a table
This screencast demonstrates how to insert a field in a table. You learn:
- How to go to the design view of a table.
- How to add a new field.
- How to cut and paste fields.
- How to save the changes made to a table.
For advanced functionality with similar results see:
- Add a field for a table
- Delete a field in a table
- Enter data into a table
- Enter data into a table using the context menu
OpenOffice.org™ is a registered trademark of Oracle.
LibreOffice™ is a trademark of The Document Foundation.
Windows® is a registered trademark of Microsoft Corporation in the United States and other countries.