User`s guide

Database Explorer
7-95
Examples
Display Data from a Single Database Table
Set up the data source for the tutorial.mdb database and connect to this database. For
details, see “Microsoft Access ODBC for Windows”.
Display data in the Data Preview pane by opening the database table of interest in
the Database Browser pane on the Database Explorer Toolstrip. When you select
a database table in the Database Browser pane, the table is highlighted and a
corresponding entry displays in the SQL Criteria panel. Enter query conditions for the
selected table in the SQL Criteria panel.
For any given table, you can select the table information in these ways:
• Click to highlight the database table name. Clicking the database table name does not
display data in the Data Preview pane but does update the SQL Criteria panel.
• Select (All) to choose all table columns and display them in the Data Preview pane.
• Select specific check boxes to choose individual table columns and display them in the
Data Preview pane.
Note: The order of the columns in the Data Preview pane matches the order in
which you select them in the Database Browser pane.