Show Panes Command (View Menu)

   

Displays a submenu that enables you to hide and show panes. Choose the name of the pane to hide or show. If only one pane is visible, you cannot hide it. Used in the Query and View designers.

Diagram

Displays the Diagram pane, which displays the input sources (tables or views) you are querying. Each input source appears in its own window showing the available data columns as well as icons that indicate how each column is used in the query. Joins are indicated by lines between the input source windows.

Grid

Displays the Grid pane, which contains a spreadsheet-like grid in which you specify query options, such as which data columns to display, what rows to select, how to group rows, and so on.

SQL

Displays the SQL statement for the current query. You can edit the SQL statement created by the Query Designer or you can enter your own SQL statement. It is particularly useful for entering SQL statements that cannot be created using the Diagram and Grid panes, such as Union queries.

Results

Displays the Results pane, which shows a grid with the results of the most recently executed Select query. You can modify the database by editing values in the cells of the grid, and you can add or delete rows.