Creating a Database

Once you've spent some time planning out your database, you're ready to enter the data on the sheet. Once you've entered the data, you will need to define the database area and the criteria and extract ranges (if you plan on using advanced filters). We will discuss how to define the criteria and extract ranges later in the chapter.

To Create a Database Table

The database table consists of field headings and records.

1.
Open a new Calc spreadsheet (select File, point at New, and then select Spreadsheet, or open an unused sheet in the current spreadsheet file).
2.
In the first row of the database table, enter the field headings for the table.
3.
Enter the records for the table, starting with the row that immediately follows ...

Get StarOffice™ 5.2 Calc Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.