Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
209 views
in Accounting System Using Database Management System by (15.2k points)

Briefly explain in steps the method of creating a query, using wizard.

Please log in or register to answer this question.

1 Answer

0 votes
by (15.7k points)

In order to create a query using Wizard, the following steps are required.

1. Select Queries from Objects list given in LHS (Left Hand Side) of Database window.

2. Double click at Create Query by Using Wizard given on the RHS (Right Hand Side). Immediately, there is a window titled ‘Simple Query Wizard’ that prompts the user to select a field from a table or an existing query that is to be included in the query being created. Many such fields may be selected according to the information requirement of the query.

The tables (or queries) being chosen represents the data source of the query being created. The fields being selected imply the data items to be displayed by the query. Use arrow buttons or double click at the list of fields on LHS of this window to select fields.

3. Click at Next after the desired fields have been selected. If the selected fields include a number or currency field, the designer is prompted to choose an option button to specify whether the query to be created is a summary or detail query.

  • If details option is chosen, the execution of query results in displaying records from data source.
  • If summary option is selected, the user is prompted to indicate the type of summarisation required: Sum, Average, Minimum and Maximum with respect to the field of summarisation. Clicking at check boxes against different types of summarisation specifies this. Click OK.

4. Click at Next and specify the name of the query being created % Finish to save and execute the query. The results of the query are displayed in datasheet view.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...