Detailed operation process of creating access delete query

Establishing a delete query operation in Access may be complicated, so a detailed operation process is required. In this article, PHP editor Apple will introduce you to the specific steps of creating a delete query in Access. From selecting the data source to specifying the deletion conditions, the step-by-step explanation will help you easily master how to create a delete query in Access. Read on below for a complete how-to guide.

1. Click Create - Query Design on the menu bar.

2. In the pop-up table display dialog box, select the order table and click the Add button

3. Click [Delete] on the menu bar to open delete design.

4. Drag the employee ID into the design form below.

5. In the same way, drag the asterisk to the table below.

6. Write =3 in the condition column.

7. Click the view above the menu bar to view the records to be deleted.

8. Click the Run button to delete these records directly.

The above is the detailed content of Detailed operation process of creating access delete query. For more information, please follow other related articles on the PHP Chinese website!