access method to create fuzzy query

What is the method of performing fuzzy query in Access? Fuzzy queries increase data flexibility by allowing users to find data without knowing exactly what to search for. PHP editor Youzi will introduce you to the specific steps of creating fuzzy queries in Access in detail, helping you easily implement fuzzy queries and improve data operation efficiency.

Open the database file.

Click the [Query Design] button in the [Query] group of the [Create] ribbon, and the system pops up the query designer.

Add the [tstud] table in the [Show Table] dialog box and close the [Show Table] dialog box.

Double-click the fields [Student Number], [Name], [Gender], [Age], [Enrollment Date], and [Resume] fields.

Enter: like "*Photography*" in the condition line of [Resume], and uncheck the [Show] checkbox.

Click the View button to view the results.

The above is the detailed content of access method to create fuzzy query. For more information, please follow other related articles on the PHP Chinese website!