Why This Chapter Is Important
A view is a saved SELECT statement. A view can retrieve data from one or more tables. Once a view is created, you can select data from a view just as you can select it from a table. Views allow you to select data; they cannot update data (although you can update the data in the result of a view). For example, a T-SQL UPDATE statement in a stored procedure updates data. Although you cannot use a T-SQL UPDATE statement in a view, you can update the results returned from a SELECT statement.
Views have several advantages. They allow you to:
Join data so that users can easily work with it
Aggregate data so that users can easily work with it
Customize data to users' needs
Hide underlying column names from users
Limit the columns ...
Get Alison Balter's Mastering Access 2002 Enterprise Development 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.
