• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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 having to teach users how to write SQL. Or, you could create different views as record sources for different forms to simplify application maintenance.

  • They can be used to transfer or transform data— Sometimes data is moved from one database to another, as in the daily routines that summarize data warehouse information into its related data mart for use by executive query and reporting systems. In other cases, data must be rearranged for download into other products or formats, as in the example of a scheduled event that extracts server data into delimited files for use by Excel or Word. In both scenarios, a view is the best tool for grouping specific columns and records into an appropriate format.

  • They can help with security— Views are often used to enforce a security model. Frequently, user permissions are removed from server tables so that users can't connect to server tables and edit the data directly. Then, various views are created that provide access to certain rows and columns to specific user groups as their needs require. Security is added to each view to restrict access to the targeted user group. To prevent users from modifying or seeing the SQL statement for a view, you can encrypt a view to lock everyone (including the creator/owner) out of its design.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint