Database Toolbox

Display Data

After executing a query, select Data from the Display menu to see a relational view of the data. The query results appear in a figure window.

Using the Data Display

• The display shows only the unique values for each field. For the example above, 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. Therefore, do not read each row of the table as a single record.
• Click on a value in the display, for example, the StockNumber 400876, to see the associated values. The data associated with the selected value is shown via a dotted line. For this example, sales for item 400876 are 3000 in January, 2400 in February, and 1500 in March.
  
  

• The example below shows the results of clicking on 3000 in the January field. There are three different items with sales of 3000 units in January, 400314, 400876, and 400999.
  
  

• Make changes to the data display as needed. For example:
• Resize the figure.
• Annotate the figure using the Tools menu and the annotation buttons in the toolbar . Use the figure window's Help menu for instructions.
• Perform other figure functions, such as printing the figure.
• If the search results include many entries, the chart might not effectively show all of them. Instead, drag the window to make it larger, narrow the search so there are fewer results, or use Display Report.

See Also

• Display Menu
• Visual Query Builder Dialog Box

Display Menu

Display Chart, Charting Dialog Box