Click it to make it visible at the right end of the toolbar. Scroll down to near the bottom to find the Data Sources button. To make it visible, right-click the Save button to open this toolbar. The Data Sources icon is not usually visible on the Standard toolbar.

To open the browser, use View > Data Sources, or press the Ctrl+Shift+ F4 keys, or click the icon on the Standard toolbar. The data source browser in Writer and Calc provides access to tables and queries of all registered databases under their registered names. The name serves as an alias, which can also be used in queries to the database. Give the database itself a suitably informative registered name, for example the name of the database file. Using Tools > Options > LibreOffice Base > Databases > New, you can register a database for subsequent use by other LibreOffice components.įind the database using a file browser and connect it to LibreOffice in a similar way as for a simple form.

Many functions, such as printing labels or using data for form letters, require the registration of a database in the configuration of LibreOffice. External forms can also interact directly with Base, provided that the path to the data sources is supplied. This means that the use of Base is not necessarily tied to the registration of databases in the configuration of LibreOffice. With Base, you can use documents in LibreOffice Writer and Calc in various ways as data sources. Other versions of LibreOffice may differ in appearance and functionality. Please direct any comments or suggestions about this document to the Documentation Team’s mailing list: you send to a mailing list, including your email address and any other personal information that is written in the message, is publicly archived and cannot be deleted. You may distribute it and/or modify it under the terms of either the GNU General Public License ( ), version 3 or later, or the Creative Commons Attribution License ( ), version 4.0 or later.Īll trademarks within this guide belong to their legitimate owners.

Libreoffice base access