Database Toolbox

Relational Display of Data

1. After executing a query, select Data from the Display menu.

1. The query results appear in a figure window.

   

   The display shows only the unique values for each field, so you do not read each row as a single record. For the basic.qry example, there are 10 entries in the StockNumber field, 8 entries in the January and February fields, and 10 entries in the March field, corresponding to the number of unique values in those fields.

2. Click a value in the display, for example StockNumber 400876, to see the associated values.

1. The data associated with the selected value is shown in bold and connected via a dotted line. For example, sales for item 400876 are 3000 in January, 2400 in February, and 1500 in March.

   

   As another example, click 3000 in the January field. It shows three different items with sales of 3000 units in January: 400314, 400876, and 400999.

   

3. Because the display is presented in a MATLAB figure window, you can use some MATLAB figure features. For example, you can print the figure and annotate it. To print it, select File -> Print. You can use other print features, such as, File -> Page Setup and File -> Print Preview. For more information, use the figure window Help menu.
4. If the query results include many entries, the display might not effectively show all of them. You can stretch the window to make it larger, modify the query so there are fewer results, or display the results in a table (see Report Display of Results in a Table).

Viewing Query Results

Chart Display of Results

© 1994-2005 The MathWorks, Inc.