Creating a View

From Wiki
Jump to navigationJump to search


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.
Documentation caution.png 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.


Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).