Chapter 10Creating Views


In this chapter, you will learn the definition of a view and how views are used in Microsoft Access’s SQL view. You will learn how to create a view, filter a view, update data in tables through a view, and delete a view.





CREATE VIEW — Used to instruct the DBMS to create a new view.

DROP VIEW — Used to delete a view.

A view is a saved query that queries one or more tables. Views are commonly used to restrict data from users for security purposes, shorten complex queries, and combine data from multiple tables. A view is also commonly referred to as a virtual table because a view can be referenced in much the same way as a table. Keep in mind, though, that views are ...

Get SQL for Microsoft Access, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.