EN/documentation/ooo3 user guides/getting started/creating a view

Getting Started with OpenOffice.org 3

Chapter 8. Getting Started with Base

< Previous Section

Next Section >

• Planning a database - DRAFT
• 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.

File:VacationsTable.png

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.

File:BaseFieldsView.png

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.