Model Database Views

A database View defines a subset of the database, aggregated into a dynamic 'virtual' Table.

Access     Tools | Database Builder | Right-click on Views Package | Add new View

A View element is immediately added to the Package, with the name highlighted for change. Type an appropriate name.

To define the database View, double-click on it. The View: <view name> dialog displays.

·The Database field defaults to the DBMS for which you are defining the database
·In the Notes field, type some notes on, or a description of, the View
·In the View definition field, type the full view definition; the code editor provides Intelli-sense for basic SQL keywords and functions


To delete a database View, right-click on the View name and click on the Delete <view name> option. A prompt displays to confirm deletion of the View and its contents; click on the Yes button.


·If you create a database View element external to the Database Builder, in any part of the model other than the Views Package, that View element is automatically reassigned to the Views Package


Learn more