Creating a View

Getting Started with OpenOffice.org 3.x

Chapter 8: 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
• Accessing other data sources
• Entering data in a form
• Creating queries
• Creating 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.

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 shown above. Or, it can consist of fields from more than one field as shown below.

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.