Query Wizard
The Query Wizard helps you to design a database query. The saved query can be called later, either from the graphical user interface, or using the automatically created SQL language command.
Specifies the table to create the query, and specifies which fields you wish to include in the query.
Specifies the sorting order for the data records in your query.
Specifies the search conditions to filter the query.
Specifies whether to display all records of the query, or only the results of aggregate functions.
This page is only displayed when there are numerical fields in the query that allow the use of aggregate functions.
Specifies whether to group the query. The data source must support the SQL statement "Group by clauses" to enable this page of the Wizard.
Specifies the conditions to group the query. The data source must support the SQL statement "Group by clauses" to enable this page of the Wizard.
Assigns aliases to field names. Aliases are optional, and can provide more user-friendly names, which are displayed in place of field names. For example, an alias can be used when fields from different tables have the same name.
Enter a name of the query, and specify whether you want to display or to modify the query after the Wizard is finished.
Voltar
Apresenta as escolhas na caixa de diálogo da etapa anterior. As configurações atuais permanecem alteradas. Esse botão só estará ativo a partir da página dois.
Avançar
Clique no botão Avançar, e o Assistente utilizará as definições da caixa de diálogo atual e passará para a próxima etapa. Na última etapa, esse botão se transforma no botão Criar.
Concluir
Efetua todas as alterações e fecha o assistente.
Cancelar
Clicar em Cancelar fecha a caixa de diálogo sem salvar as alterações.
Cancelar
Fecha a caixa de diálogo e descarta todas as alterações.
Query Wizard - Field selection