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: ...
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.
