Traditional Culture Encyclopedia - Photography and portraiture - Create a query in access to find and display the contents of the "Student ID" and "Name" fields of students with photography hobbies.

Create a query in access to find and display the contents of the "Student ID" and "Name" fields of students with photography hobbies.

1. First, open the established database degree and data table on the computer, and click "Create"-query the design, as shown below.

2. Then, in the displayed table window, click A under the table tab, and then click the Add button.

3. Next, double-click to add the tracking name and age in Table A. ..

4. After that, enter "

5. Then, click the current database in the window that forms the internal table, edit the table name, and then click the "OK" button in the upper right corner.

6. Finally, as shown in the figure, for data less than 20, a separate data table will be generated.