Delete Query in Access

Delete Query Tutorial

The Delete query in MS Access SQL command used to remove one or more rows of data from a relational database table.  The number of rows deleted is dependent upon the existence and criteria within the where clause of the delete query.  The basic syntax of the Access Delete query is:

Delete Table Name.* From Table Name Where some criteria;

Note that using an Access delete query without the where clause will delete all rows from the specified table.

The asterisk in Table Name.* is a wildcard character and refers to all fields within the table.  You may only delete entire records rather than values in particular fields therefore the asterisk is mandatory.

If Table Name is a table which is defined as the master of a master-detail relationship and the cascade delete property of the relationship is set to true then corresponding records in the detail table will also be deleted.

The delete method is often preferable to the drop table method, which completely removes the table from the database, because all of the characteristics of thetable remain intact – such as the indexes, relationships and primary keys.

Now with real column and table names:

Delete *  From M_Employees Where  Emp_Name = “Joe”;

The above query will delete all employees with an employee name of Joe.

Microsoft Office:
MS Access 2000 Through Access 2016 & Office 365

>>>>>NEW LINKS WILL BE HERE AFTER PAGES COMPLETED<<<<<< Open Email Using SendObject Access Download User Inactivity Logout VBA Code Disable Shift Key Demo Send Email Microsoft Access Tutorial Download (Advanced) Sequential Counter in Query Multi Select List Box Query Parameters Row Level Data Security Programming MS AccessSecurity Alternative Single User Inventory Calculations Download How To PerformMulti-User Inventory Calculations Make Dependent Combo Box Code MS Access Tutorial Union Query Example (Simple) Union Query (Advanced) Access Tutorial How ToFill Fields From Combo Box Use Global Variables as Parameters Continuous Form Dependent Combo Box How To Program Continuous-Continuous Master/Detail Forms Access Bar Chart / Bar Graph Programming Crosstab Query Example TransferText & OutputTo Microsoft Access DoCmd.OpenForm & OpenArgs VBA Example Running Sum Query Method Choose Command Dynamic SQL Order By Access Conditional Format Access Report Banding

Popup Form Control Method

Microsoft Office VBA, MS Access 2003, 2007, 2010, 2013, 2016

Scroll to top