caslegal.blogg.se

If you are creating a new database, you are asked if you want to register it so that you can use data from it in other OpenOffice applications (a subject for another article). What happens on the next page of the wizard depends on your choice. Another option is to choose an or MS Excel spreadsheet, which is useful for when you want to explore Base quickly or when you want to convert a growing spreadsheet into a database. Besides formats such as MySQL and Oracle, Base also supports several other formats on the free desktop, including Mozilla, Evolution, and KDE address books. Connect to an existing database: Make a new database in one of the other formats supported by Base.Open an existing database file: Edit a Base database that is already created.Create a new database: Make a new database in Base's native HSQL format.You have three choices, but what they are is obscured slightly by the wording and order of choices in the wizard:

Your first step is to choose a database with which to work. To begin customizing a database, select Database from the initial screen or File -> New -> Database from the menu. Setting up a basic database in Base consists of two parts: configuring the database, and adding at least one table to it. Fortunately, Base makes setting up a database easy, giving you a more efficient way of handling data than a spreadsheet. Despite their widespread use, in some ways they have never lost that mystique - so much so that many desktop users will stretch the use of spreadsheets to cumbersome lengths rather than consider setting up a database. Home | About OpenOffice.When databases became available for the personal computer in the mid-1980s, they quickly gained a mystique as the ultimate productivity applications.

Now you can enter new data, or copy current data into the new row or column on the spreadsheet. A new blank column will appear to the left of the column that was originally selected. Left-Click the Insert menu and select Column.

To add a column to the spreadsheet, select any cell in the column to the right of where the new column will be. A new blank row will appear above the row that was originally selected. Left-click the Insert menu and select Rows. To add a row to the spreadsheet, select any cell in the row below where the new row will be. This section will describe how to do this. Sometimes we need to ad new rows or columns into our spreadsheet. Home | About | Tutorials | FAQs | Sitemap | Help