Database Overview

Working with databases in Collabora Office

Data Source View

Choose View - Data Sources or press + Shift + F4 keys to call the data source view from a text document or spreadsheet.

On the left you can see the Data source explorer. If you select a table or query there, you see the contents of this table or query on the right. At the top margin is the Table Data bar.

Data Sources

Address book as data source

View data source contents

Menu bar of a database file

Forms and Reports

Create new form document, edit form controls, Form Wizard

Entering data versus editing form

Report Wizard

Queries

Create new query or table view, edit query structure

Query Wizard

Enter, edit and copy records

Tables

Create new table, edit table structure, index, relations

Table Wizard

Enter, edit and copy records