You are here: Defining Files and Fields > Defining Access Database Tables > Select Tables

Select Tables

Select the desired table(s) from the database.

Note: If the Edit Query checkbox is unchecked then the next two panels are skipped and you advance directly to the Final panel.

To select columns and to edit the Where and Order clause, de-select Define Multiple Tables, select Edit Query and click [Next].

To create a custom SQL Query, check the Create SELECT checkbox and click [Next]. Enter/paste a valid SQL Select statement in the SQL SELECT dialog that appears and then click [OK] to advance to the Final panel.

Identify Relationship

If more than one table is selected, and Define Multiple Tables is de-selected, you will need to specify the key fields to be used to join the selected tables. Click [OK].

The Select Tables dialog now displays the specified join criteria. Click [Next].

Define Multiple Tables

To define multiple tables independently at one time, select Define Multiple Tables.

After selecting the desired tables, clicking [Next] will advance you directly to the Final panel.

Each table layout will be named based on the table name, and the selected tables can either be flattened or read directly.