Section 140. Access an Existing Database

140. Access an Existing Database


Just jump right in!


135 Create a Database

You can use any database within Base or any other component if that database is registered as a data source . Typically, when you create a database in Base, you register it so that it can be used as a data source by any component (see 135 Create a Database ). But what about databases that were created using some other program such as Calc, Microsoft Excel, Microsoft Access, or Thunderbird (an email program with an address database)? In this task, you'll learn how to register such a database so that you can use it whenever you want, throughout For example, you can use a registered database in Base or in a Writer Mail Merge operation, or you can copy its data into a Calc spreadsheet.

After creating a database in Base, do not follow these steps to open it again for editing. Instead, open an existing Base database from any component (and start Base at the same time) by choosing File, Open or by clicking the Open button. If you're not running right now, you can open an existing Base database by double-clicking the database file in Windows Explorer.

140. Access an Existing Database


If you start Base from the Start menu, you'll have only two options, as you'll learn in this task: to create a new database, or to register and edit a database created in some other application such as dBASE or Microsoft Access.

To use a database created in Calc (as explained in 76 Create a Calc Database ) within another component such as Base or Writer, you'll need to register it by following the steps given in this task.

After registering a foreign database (such as a Microsoft Access database) and converting it to format, you can remove the original version from your system if you decide you don't need it. Choose Tools, Options,, Databases. Select the database to remove and click Delete.

Click New, Database

In any component, click the New button on the Standard toolbar and choose Database from the menu. Base starts and displays the Database Wizard.

Select Database Type

In Step 1 of the Database Wizard , select Connect to an existing database. Select the type of database you want to register from the Database type list. In this example, I wanted to convert an Excel database for use in Base, so I chose Spreadsheet . You'd make this same choice to register a Calc database. Click Next .

Select Database

In Step 2 of the Database Wizard , click Browse. Change to the folder that contains the database file you want to open, select it, and click Open. You're returned to the Database Wizard .

If a password is required to access the database (if you or someone else password-protected the file), enable the Password required option. Click Next.

Register Database and Click Finish

In Step 3 of the Database Wizard, select the Yes, register the database for me option.

Disable the Open the database for editing option, unless you need to make changes to the database before you use it. If you do select this option, you might also be able to build the tables yourself, rather than letting create them by selecting Create tables using the table wizard option (if present). Click Finish .

Save the Database

The Save As dialog box appears. will convert the database to Base format, register it for use, and save it in a new file. Select the folder in which you want to store the new database, and enter a name in the File name box. Base automatically adds the extension .odb to the filename. Click Save. The converted database is saved, and it can now be used within any program.

If you opted to edit the data source, the converted file is opened in Base so that you can make changes.

View Data Source

To view any registered data source from within Calc, Writer, or Impress (if you're creating a spreadsheet slide), choose View, Data Sources or press F4 .

The Data Source pane appears above the document window. Click the plus sign in front of the data source you want to use. Click the plus sign in front of Tables , and the tables in the database are listed. Click one of these tables to view its data.


If you must enter a password to access a data source, you'll be prompted for it when you click the plus sign in front of that data source to view its contents.

After a table is displayed, you can drag and drop a single row, column, or all the data into the component you are currently using (Calc, Writer, or Impress). You can also drag information from a component file (such as a Calc spreadsheet) into a Base database file.

To edit a data source in Base, right-click the source and choose Edit Database File from the context menu. 2, Firefox, and Thunderbird for Windows All in One
Sams Teach Yourself 2, Firefox and Thunderbird for Windows All in One
ISBN: 0672328089
EAN: 2147483647
Year: 2005
Pages: 232
Authors: Greg Perry © 2008-2017.
If you may any questions please contact us: