Query Wizard

Query Wizard - Field Selection

Specifies the table to create the query, and specifies which fields you wish to include in the query.

Query Wizard - Sorting Order

Specifies the sorting order for the data records in your query.

Query Wizard - Search Conditions

Specifies the search conditions to filter the query.

Query Wizard - Detail or Summary

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.

Query Wizard - Grouping

Specifies whether to group the query. The data source must support the SQL statement "Group by clauses" to enable this page of the Wizard.

Query Wizard - Grouping Conditions

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.

Query Wizard - Aliases

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.

Query Wizard - Overview

Enter a name of the query, and specify whether you want to display or to modify the query after the Wizard is finished.

Balik

Melihat pemilihan dalam dialog yang dibuat pada langkah sebelumnya. Pengaturan saat ini tetap tidak diubah. Tombol ini hanya dapat diaktifkan dari halaman dua dan seterusnya.

Lanjut

Klik tombol Selanjutnya, dan wahana pandu menggunakan dialog pengaturan saat ini dan hasilnya untuk langkah selanjutnya. Jika Anda dalam langkah terakhir, tombol ini akan menjadi Buat.

Selesai

Menerapkan semua perubahan dan menutup wahana pandu.

Batal

Mengklik Batal menutup suatu dialog tanpa menyimpan sebarang perubahan yang dibuat.