How to implement display query of multiple fields in access database

How to extract information from multiple fields from an Access database? PHP editor Banana will introduce in detail how to display multiple fields through query. This article walks you step-by-step through the steps of building a query, adding fields, and extracting data from the database. By reading the following content, you can easily learn how to query multiple fields from an Access database to meet your data extraction needs.

1. Open the access software.

2. Select the Create Query Design button.

3. Double-click the teacher1 table in the dialog box that pops up.

4. Then double-click the 5 fields in the figure below, "Number", "Name", "Gender", "Age" and "Professional Title".

5. Then click the Execute button operation.

6. You can see the query results.

7. Finally close the saved query.

The above is the detailed content of How to implement display query of multiple fields in access database. For more information, please follow other related articles on the PHP Chinese website!