O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

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

WORKING WITH VIEWS

If you've ever worked with Access queries, you are familiar with the concept of views. In an Access Project, a view is a SQL statement saved to the server that selects, filters, or groups data from one or more tables. Views have various uses in your Project:

  • They simplify the way users look at data— If your application users are allowed to create their own Access reports, work with data in a datasheet window, or perform ad hoc queries from Excel or a query tool, a view may provide a tool for customizing the columns or rows exposed to various users. For example, you could create different views for different types of users, based on security needs or aptitude. Views are a great way to summarize data into specific subsets without ...

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