OpenOffice.org 2, Firefox, and Thunderbird for Windows All in One [Electronic resources]

Chapter 10. Using Calc as a Simple Database

IN THIS CHAPTER:

75 About Calc Databases

76 Create a Calc Database

77 Import Data into a Calc Database

78 Sort Calc Database Data

79 Filter Data That You Want to See

80 Compute Table Totals and Subtotals

Although OpenOffice.org includes a full-featured

database program called Base, it also supports the use of Calc-based database tables from which you can store, edit, sort, and report from the data.

If your data management needs are simple, you can use Calc's database features to store and organize lists of information without leaving the friendly confines of your Calc spreadsheet.

If your needs are more complex, however, you'll want to explore OpenOffice.org Base, a

relational database program comparable to Microsoft Access that lets you create tables, forms, reports, queries, and views. You can also use Base to define relationships between different sets of data. That being said, you might still want to start working with databases in Calc so that you can learn some simple database concepts that will support

all your data management needs.

KEY TERM

Database A collection of data that is often organized in rows and columns to make searching and sorting easy to do.75 About Calc Databases ) before you can fully master Calc's capability to process database data.