The Query Properties dialog box enables you to set properties for a Database Query. Options displayed in this dialog box depend on the Query Type you have selected in the Database Query dialog box. For each type of query, there is a different set of tabs. The Query Types are:

Delete query

Deletes one or more records from your Database, according to  condition(s) you set.

If Delete query is selected, the available tabs are:

Insert query

Adds a new record to a specified table of your database.

If Insert query is selected, the available tab is:

Select query

Selects and displays records from a specified database. This will be based on condition(s) you choose in this dialog box.

If Select query is selected, the available tabs are:

Update query

Updates records in your database depending on condition(s) you choose in this dialog box.

If you choose Update Query, the dialog box contains:

The Delete tab

If you choose the Delete tab, the Tables drop-down list will be displayed. Choose a table you want to delete record(s) from.

The Insert tab

The Insert tab includes two sections: (i) the Tables drop-down list, where you can choose a table to insert records into; (ii) the Fields and Values section, where you can assign values to  fields. To assign a value, select a field and click Edit. The Set Value dialog box will be displayed. Now set a value for the selected field. If you want a field to be omitted in the query, select the field and click Clear.

The Select tab

The Select tab includes three sections: (i) the Tables drop-down list, where you can choose a table to select record(s) from; (ii) Available Fields, and (iii) Selected Fields.

The Available Fields section lists all fields from a chosen table. The Selected Fields section lists all fields you have selected from various tables. These are the tables that are contained or included in a current database. These tables are the ones listed in the drop down menu. Fields you select and see in the selection field section will be displayed in a feedback on your web page. If you want to select field(s) from your current table, select it in the Available Fields section, and click Add >. The field(s) will be added to the Selected Fields section. If you want to select all fields of your current table, click Add All >>. To remove  field(s) from your list of selected fields, select it and click Remove <. If you want to remove all of your selected fields, click Remove All <<.

The Update tab

The Update tab includes the following sections: (i) the Tables drop-down list, where you can choose a table to update your record(s), and (ii) the Fields and Values section. In this section you can assign values to your fields. To set a value to a field, select the field and click Edit. The Set Value dialog box will be displayed. Here you can set a value for the selected field. If you want a field to be omitted from your query, select the field and click Clear.

The Order tab

The Order tab includes the following sections: (i) the Tables drop-down list, where you can choose a table you want. In this table, select fields you want your query to be ordered by; (ii) the Available Fields and (iii) the Fields to Order By.

The Available Fields section lists all fields of the current table. The Fields to Order By section lists all the fields you chose  from various tables. These fields will be used in a current query to show a sorting order in a feedback on your web page. To select field(s) from a current table, select it in the Available Fields section, and click Add >. The field(s) will be added to the Fields to Order By section. If you want to add all fields of your current table, click Add All >>. To remove field(s) from a list displayed in the Fields to Order By section, click Remove <. If you want to remove all selected fields, click Remove All <<. A field name in the Fields to Order By section will have a small arrow to its left. The direction of this arrow indicates whether your sorting will be ascending or descending. If the arrow points upward, the sorting will be ascending. If the arrow points downward, the sorting will be descending.

The Criteria tab

The Criteria tab includes the Condition window and condition managing buttons/controls.

The Condition window displays binary operations of your  current query. The query will be performed if the conditions are satisfied. You must build the binary operations. These will be displayed in a form of a logical tree. The operations are logically connected by the AND/OR binary operations. These enable you to construct a very complex condition tree.

To add a logical operation at the same level with a selected object, click Add Logic. The Choose Logic Operation dialog box will be displayed. Here you can specify AND and OR logical operations. To add a logical operation at a level higher than a selected object, click Insert Logic. The Choose Logic Operation dialog box will be displayed. Here you can choose between the AND and OR logical operations. To add a binary operation, click Add Condition. The Add Condition dialog box will be displayed. Here you can set the binary operation. For example: table_1.Field_1<>5
To delete a condition or a logic, select it in the condition window and click Delete. To edit a condition or a logic, select it and click Edit. Either the Choose Logic Operation or the Add Condition dialog box will be displayed.

The Feedback tab

The Feedback tab enables you to customize feedback properties of your query.

The Style section enables you to choose whether a feedback will be displayed in a Table or List format. In the Result Portion you can enter a number of records to be displayed for each feedback on your web page.
The Show Image As section provides you with two options. (i) One option displays images included in a feedback as  Embedded objects. (ii)The other option displays links to them. (Linked). The Enumeration check box is available only for the List feedback. It toggles on/off enumeration of query results on  your web page.
The Fields Caption check box is available only for the List feedback. It toggles on/off display of field captions in a  feedback.
The Border check box toggles on/off display of borders in a  feedback table in your web page.
The Alignment section enables you to set alignment of data  columns of a feedback table displayed on your web page.