

This will allow you to share this data with others using different database programs. By saving the Tables in csv format they can be imported into an Access database, and probably other database programs. Also unlike Writer and Calc, where you can save a file in MS office format, Base does not have this facility. From there you can open, edit, rename or delete an object.As said MS Access can not open the odb files created by LO Base.

Database Objects ListĪll the objects that we create for a given type are listed in this Window. For example the tasks for Tables include to Create a Table in Design View or Use Wizard to Create Table. Database Tasksįor each database object type, the Tasks window lists the available tasks along with a description. We will explain these objects in detail in the next lessons. Together, these objects allow you to enter, store, analyze, and compile data however you want. This file format is actually a container of all elements of the database, including forms, reports, tables, and the data itself.īase main window besides the Title Bar, Main menu and Toolbars, consists of three window panes: Database Object types, Database Objects list and Tasks.ĭatabases in LibreOffice Base are composed of four objects: Database files in Open Document Format are stored with the *.odb extension. Make sure the option Open the database for editing is selected and click Finish.īefore opening the database for editing, Base will ask you to name and save your new database. For example you can access data from a Calc spreadsheet or from a Writer document when using the Mail Merge function.

Registering a database in LibreOffice means that other components can have access to the data. In the next step leave the default options. Select the first option to create a new database using the embedded database system HSQLDB. For example it can conect to an SQL database.
