The property sheet “Properties of query” serves for viewing and changing query properties: condition of searching records in a query, sorting records, presence and type of calculated fields, scheme of joining tables in a query and permissions of the current user to the query. The data in the property sheet is organized as a set of pages. To display the necessary page it is required to click the corresponding tab.
Permits viewing and changing condition of searching records in a query. | |
Allows viewing and changing sorting condition, that is, the order of displaying records in a query. Permits enabling or disabling display of identical (duplicated) records in a query. | |
Permits viewing or changing the set of calculated query fields. | |
Allows viewing and changing scheme of joining tables in a query. | |
Permits viewing permissions of the current user to the query. |
OK | The button serves for confirming performed changes of query properties and closing the property sheet. |
Cancel | The button serves for canceling all changes of query properties and closing the property sheet. |
Command Properties for a query
 |  |
