Briefly explain in steps the method of creating a query, using wizard.
Briefly explain in steps the method of creating a query, using wizard.
The following are the steps involved in creating a query using the wizard method.
1. In the Database window, select 'Queries' from Object list given on the Left Hand Side (LHS) of the Database window.
2. Double click at 'Create Query' by using wizard given on the Right Hand Side (RHS) of the window. With this 'Simple Query Wizard' will be shown on the screen. Now, the user is required to select a field name from a table or from an existing query which should be included in the query being created.
3. Click 'Next' after the desired fields have been selected. In case, a number or currency field is included in the selected field, the user is asked to choose an option button to specify whether the query to be created is a summary or detail query.
4. Click 'Next' and specify the name of the query being created % 'Finish' to save and execute the query. The results of the query created are displayed in the datasheet view.
The following are the steps involved in creating a query using the wizard method.
1. In the Database window, select 'Queries' from Object list given on the Left Hand Side (LHS) of the Database window.
2. Double click at 'Create Query' by using wizard given on the Right Hand Side (RHS) of the window. With this 'Simple Query Wizard' will be shown on the screen. Now, the user is required to select a field name from a table or from an existing query which should be included in the query being created.
3. Click 'Next' after the desired fields have been selected. In case, a number or currency field is included in the selected field, the user is asked to choose an option button to specify whether the query to be created is a summary or detail query.
4. Click 'Next' and specify the name of the query being created % 'Finish' to save and execute the query. The results of the query created are displayed in the datasheet view.
