Enlarge or reduce the size in which the table is displayed by positioning the mouse cursor on a border or on a corner and dragging the table until it is the desired size. To move tables, drag the upper border to the desired position. You can resize and arrange the tables according to your preferences. Another option is to press the Delete key. You can use the Delete command to remove the table from the Design View. To remove the table from Design View, click the upper border of the table window and display the context menu. While designing a query, you cannot modify the selected tables. When you open the query design for the first time, you see a dialog in which you must first select the table or query that will be the basis for your new query.ĭouble-click fields to add them to the query. Note: the table displayed is only temporary. The query result is displayed in a table similar to the Data Source View. If you want to test a query, double-click the query name in the database document. In the top of the query Design View window, the icons of the Query Design Bar and the Design bar are displayed. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press Command To define a query, specify the database field names to include and the criteria for displaying the fields. The lower pane of the Design View is where you define the query. To create a query, click the Queries icon in a database document, then click Create Query in Design View. The Query Design window layout is stored with a created query, but cannot be stored with a created view. Selecting the Create View command from the Tables tab page of a database document, you see the View Design window that resembles the Query Design window described here.
0 kommentar(er)
