SQLzoo.net

CREATE a VIEW.

Access
A view is a named SELECT statement. In this example we show only European countries, we also show the population in millions. Note how the columns of the table may be named.	Run the tidy code silently Run set up code CREATE VIEW v_europe AS SELECT name, population AS pop FROM world WHERE region='Europe'; SELECT * FROM v_europe
Specific to Access
A view is called a query in Microsoft Access. Use DROP TABLE to remove a view.