Creating a View

Getting Started with OpenOffice.org 2.x

Chapter 10: Getting Started with Base

< Previous Section

Next Section >

• Planning a database
• Creating a new database
• Creating database tables
• Creating a View
• Defining relationships
• Creating a database form
• Using data sources in OOo
• Creating queries and reports

< Previous Page

Next Page >

A View is a query. Because of this, the details of how to create and use a View are in the Creating queries section.

File:VacationsTable.png

Figure 11: View of some fields from the Vacations table.

A View is also a table. Its fields come from the fields of one or more tables of the database. It provides a way to look at a number of fields without regard to the table to which any of the fields belong. A View can consists of some of the fields on one table as in Figure 11. Or, it can consist of fields from more than one field as in Figure 12.

File:BaseFieldsView.png

Figure 12: View of fields from the Fuel and Payment Type tables.

Data can not be entered into a View like it can be added to a table. It is strictly for viewing data which has already been added.