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 ...
Get F. Scott Barker's Microsoft® Access 2000 Power Programming 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.
