To browse a view
Click the Views icon from the tree. A list of all the views in the database will appear beneath the Views icon.

Select the view you want to browse from the list of views. The view appears in the panel to the right.

Click the Browse data tab in the panel on the right. The Browse data window opens in the panel on the right.

To quickly browse the view page by page use the Page Up and Page Down buttons.
Click the First button to jump to the first entry in the view.
Click the Last button to jump to the last entry in the view.
Click the Filter button to set sort rules for browsing the view. The Data Filter dialog box appears.

Enter a WHERE clause or an ORDER BY clause to filter the data when browsing a view.
NOTE WHERE statements must follow SQL syntax. See the section on Constraint Syntax at the end of chapter 4 for more information.
Related topic: