O'Reilly logo

SQL for Microsoft Access, 2nd Edition by Neal A. Berkowitz, Cecelia L. Allison

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10Creating Views

Introduction

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.

Keywords

CREATE VIEW

DROP VIEW

Definitions

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required