However, the initial selection of a table/ query in the second row of QBE grid restricts the choice of fields to the selected table/ query only. Such tables or queries constitute the data sources shown after FROM clause of SQL statement. (v) The name of table or query is displayed, in accordance with selection of fields. This process of selection constitutes the data items to be displayed by SELECT clause of SQL statement. The process is repeated for second and subsequent columns of grid to include more fields in the query. (iv) Click at field row of first column of QBE grid to select the fields to be included in the query. (iii) Click at View item of Menu bar % Total and then % Table Names. If closed, the Show Table Window can be recalled by a right click at upper pane % show table. The Show Table Window is meant to add tables, queries or both to the upper pane of Select Query Window. The row of this grid shows 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 field or fields to restrict the query results. The upper pane is meant to display data sources (Tables or Existing Queries) and the lower pane, which is also called Query By Example (QBE) grid, has one column each for field to be included in query being created. The Select query window is vertically divided into two panes, upper pane and lower pane. (ii) Access responds by displaying a Select Query and Show Tables Window. (i) Select Queries from Objects list given in LHS of database window, Double click at Create Query by Using Design View given on the RHS. Design Method In order to create a query by design method, the following steps are required
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |