O'Reilly logo

StarOffice™ 5.2 Calc Handbook by Joe Habraken

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding Calc Database Design

Your Calc databases will not look much different from your other spreadsheet files. In fact, Calc spreadsheet databases are called flat file databases because they consist of a single, large table of data. Relational databases like StarOffice Base allow you to place the data in smaller related tables (hence the name relational), which actually allows for greater manipulation of the data.

Note

If you find that Calc isn't doing all the “database things” that you need it to do, you can import your Calc databases into Base. This is discussed later in the chapter.

An important prerequisite for designing your Calc databases is to understand the terminology that is used to refer to the different parts of a database: ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required