Describe in steps the design view method to create a query in MS Access.
Describe in steps the design view method to create a query in MS Access.
To create a query using design view method, the following steps are followed
Step1: Select 'Queries' from the object list given on the left hand side of the database window. Double click at 'Create Query by using Design View' given on the right hand side.
Step 2: With this, a 'Select Query' and 'Show Tables' window is displayed. The 'Select Query' window is divided into two panes namely, the upper pane (displays the data sources) and the lower pane also known as Query by Example (QBE) (displays column and row). The column of the lower pane displays the data sources. The row of the lower pane displays the field name, table (or query), sort order, whether the selected field is shown in the query results or not and also the criteria that have been applied to the fields to restrict the query results.
Step 3: Click at the 'View' item of the Menu Bar % Total and then % Table Names.
Step 4: Click at the 'Field Row' of the first column of the QBE and select the fields to be included in the query. The process is repeated for the subsequent columns of the QBE to include more fields in the query. This process of selection contains the data items that are to be displayed by the SELECT clause of the SQL statement.
Step 5: Now, in accordance to the selection of the fields, the name of the table or query is displayed. Such tables or queries constitute the data sources shown after the FROM clause of the SQL statement.
Step 6: Click at 'Row of the low pane' to specify the group by clause and aggregate functions to create a summary of the query is created.
Step 7: Click at 'Row of the low pane' to specify the sort order (Ascending or descending). The selected fields for sort order are shown after ORDER BY clause of the SQL statement in which ascending order is a default choice.
Step 8: Click at row to display the selected field in the query result.
a) Click at row of the grid to specify the criteria to limit the records to be displayed by the query being created. The specified criteria result is shown after the WHERE clause of the SQL statement.
b) Click File % Save (or Press Ctrl + S) to save the query. Now, a dialog box appears that asks the user to specify the name of the query being created.
To create a query using design view method, the following steps are followed
Step1: Select 'Queries' from the object list given on the left hand side of the database window. Double click at 'Create Query by using Design View' given on the right hand side.
Step 2: With this, a 'Select Query' and 'Show Tables' window is displayed. The 'Select Query' window is divided into two panes namely, the upper pane (displays the data sources) and the lower pane also known as Query by Example (QBE) (displays column and row). The column of the lower pane displays the data sources. The row of the lower pane displays the field name, table (or query), sort order, whether the selected field is shown in the query results or not and also the criteria that have been applied to the fields to restrict the query results.
Step 3: Click at the 'View' item of the Menu Bar % Total and then % Table Names.
Step 4: Click at the 'Field Row' of the first column of the QBE and select the fields to be included in the query. The process is repeated for the subsequent columns of the QBE to include more fields in the query. This process of selection contains the data items that are to be displayed by the SELECT clause of the SQL statement.
Step 5: Now, in accordance to the selection of the fields, the name of the table or query is displayed. Such tables or queries constitute the data sources shown after the FROM clause of the SQL statement.
Step 6: Click at 'Row of the low pane' to specify the group by clause and aggregate functions to create a summary of the query is created.
Step 7: Click at 'Row of the low pane' to specify the sort order (Ascending or descending). The selected fields for sort order are shown after ORDER BY clause of the SQL statement in which ascending order is a default choice.
Step 8: Click at row to display the selected field in the query result.
a) Click at row of the grid to specify the criteria to limit the records to be displayed by the query being created. The specified criteria result is shown after the WHERE clause of the SQL statement.
b) Click File % Save (or Press Ctrl + S) to save the query. Now, a dialog box appears that asks the user to specify the name of the query being created.
