Access getting started tutorial 9.6 query the data table View

We have added all the required fields to the query. Now let's take a look at the results of the created "query. As mentioned in the previous lesson, "tables" can be switched between the design view and data table view, and "query" can also be switched between the design view and data table view. Switch the table to the data table view to view the "query" result.

We have added all the required fields to the query. Now let's take a look at the results of the created "query. As mentioned in the previous lesson, "tables" can be switched between the design view and data table view, and "query" can also be switched between the design view and data table view. Switch the table to the data table view to view the "query" result.

We have added all required fieldsQueryNow, let's take a look at the created"Query.

As mentioned in the previous lesson, "tables" can be designedViewAndData TableViewSwitch,"QueryYou can also designViewAndData TableViewSwitch. Switch tableData TableView, You can see"Query. In AccessViewSwitching between instances is very simple. As long as you move the mouse to the first tool button in the upper left corner of the toolbar, a"View"Prompt label, click it to start fromQueryDesignViewSwitchData TableView.QueryOfData TableViewIt looks like a table in the previous lesson, but there are still many differences between them.

InQueryData TableCannot add or delete columns, and cannot be modifiedQueryField name. This is becauseQueryThe generated data value does not actually exist, but is dynamically transferred from the table object. It is an image of the table data.QueryOnly tell Access what data is needed, and Access will find the data values from the table and reflect themQueryData TableThat is to say, these values areQuery. The target field we just selected is to tell Access which tables and fields are needed, and Access will list the data in the field into a table and feed it back to us. Of course inQueryWe can also use various expressions to calculate the data in the table to generate a newQueryField.

InQueryOfData TableAlthough Columns cannot be inserted, columns can be moved. The moving method is the same as the moving method of columns in the table in the previous lesson.QueryOfData TableYou can also change the column width and row height, and hide and freeze columns.