Views are virtual tables based on the result-set of a
SELECT statement that lets you combine tables and present the data as if the data were coming from a single table. You can add SQL Functions, Joins, WHERE, GROUP BY, ORDER BY, or HAVING clauses to a view, to present exactly the data you want to the user.
You will create and edit a view both diagrammatically using a database diagram, and declaratively using the Edit View dialog, shown below. To begin creating a view, you will drag and drop a
View component onto the diagram.