Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

OpenOffice 3.x Getting Started Guide
Previous Page Home Next Page

Creating a table by copying an existing table

If you have a large collection of music, you might want to create a table for each type of music you have. Rather than creating each table from the wizard, you can make a copy of the original table. Each table can be named according to the type of music contained in it. Possible names could include Classical, Pop, Country and Western, and Rock among others.

  1. Click on the Tables icon in the Database pane to see the existing tables.
  2. Right-click on the CD-Collection table icon. Select Copy from the context menu.
  3. Move the mouse pointer below this table, right-click, and select Paste from the context menu. The Copy table window opens.
  4. Change the table name to Pop and click Next.
  5. Click the >> button to move all the Fields from the left window to the right window and click Next.
  6. Since all the Fields already have the proper File Type formating, no changes should be needed. However, this is the time and place to make these changes if they are needed. (See Caution below for the reason why.) Click Create. The new table is created.
Image:documentation_caution.pngOnce tables have been created using the wizard, editing them should be very limited if any editing is done at all. Fields can be added or deleted. But adding a field requires taking the time to enter the data for that one field for every record having an entry for that field. Deleting a field deletes all the data once contained in that field. Changing the field type of a field can lead to data being lost either partially or completely. When creating a new table, it pays to create the fields with the correct names, length and format before data is added.
Image:documentation_caution.pngTables can be deleted in a very simple way. But doing so removes all of the data contained in every field of the table. Unless you are sure, do not delete a table.

To delete a table, right-click it in the list of tables. Select Delete from the context menu. A popup window asks if you are sure you want to delete the table. Once you click Yes, the table and its data are gone forever unless you have a backup.

Top of page


OpenOffice 3.x Getting Started Guide
Previous Page Home Next Page

 
 
  Published under the terms of the Creative Commons License Design by Interspire