The Query Properties dialog box enables you to set properties for a Database Query. Options displayed in this dialog box are based 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. These Query Types are:

Delete query

Deletes one or more records from the Database, according to condition(s) you set.
If the Delete query is selected, the available tabs are:

Insert query

Adds a new record to the specified table of the 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 set in this dialog box.
If the Select query is selected, the available tabs are:

Update query

Updates records in the database based on condition(s) you set in this dialog box.
If you choose Update Query, the dialog box will contain:

Delete tab

If you choose Delete tab, the Tables drop-down list will be displayed. Use this to select an entire table where record(s) must be deleted.

Insert tab

The Insert tab includes two sections:
(i) the Tables drop-down list, where you can choose a table to insert records.
(ii) the Fields and Values section. In this section, 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 a query, select it and click Clear.

Select tab

The Select tab includes three sections:
(i) the Tables drop-down list. You can use this to choose the table where the record(s) must be selected
(ii) Available Fields
(iii) Selected Fields

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

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).
(ii) the Fields and Values section where you can assign values to fields. To assign 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 the field to be omitted from the query, select the field and click Clear.

Order tab

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

The Available Fields section lists all the fields from the current table. The Fields to Order By section lists all fields from various tables. These fields will be used in the current query to show sorting order in the feedback on your web page. To select a field(s) from the current table, select it (them) 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 the fields of the current table, click Add All >>. To remove a field(s) from the list displayed in the Fields to Order By section, click Remove <. If you want to remove all selected fields, click Remove All <<. The field name in the Fields to Order By section will have a small arrow to the left of its name. The direction of this arrow indicates whether the 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.

Criteria tab

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

Building binary operations is necessary to perform your Query. The Condition window helps you perform binary operations of the current query. The operations will appear in a form of a logical tree. The operations will be logically connected by AND/OR binary operations. This method will let you to construct a very complex condition tree.

To add a logical operation at the same level as the selected object is, click Add Logic. The Choose Logic Operation dialog box appears. Specify the  AND and OR logical operations.
To add a logical operation at the level higher than the selected object is, click Insert Logic. The Choose Logic Operation dialog box appears. Choose between the AND and OR logical operations.
To add a binary operation, click Add Condition. The Add Condition dialog box appears. Set the binary operation. For example: table_1.Field_1<>5
To delete a condition or a logic operation, select it in the condition window and click Delete.
To edit a condition or logic operation, select it and click Edit. The Choose Logic Operation or Add Condition dialog box appears.
To see a selected item in SQL click Show SQL. The Part of SQL Text dialog box appears where you can see a part of the SQL statement relevant to condition you chose.

Feedback tab

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

Select All Records to display all selected records from a database on one page.
Select Custom and enter a number of records to be displayed on a page. Pages are provided with automatic navigation from one to another.