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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.