Home   Fees/Services   Access Templates   Tutorials   Tutorial Downloads   Articles   Search   Contact  Privacy  Links
Delete Query Tutorial
Access Delete Query Example
Home > Tutorials > Query Tutorials > Delete Query Tutorial
 






Query Tutorials Index:
Too Complex Query
Aggregate Query
Not In Operator
Choose Function
Crosstab Query
Date Time Query
SQL Delete Query
External Table Query
Report Filter Query
Group By Query
Having Query Clause
Histogram Query
Access Append Query
Master Detail Update
Order By Query
SQL Parameter Query
Predicate Query
Self Join Query
Scalar SubQuery
Master Detail Query
Select Query
Access SQL Select Top
SQL Union Query
SQL Update Query
Custom Query Function

 

MultiSelect Parameter Forms Access Tutorial


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.



Our programming team has 15 members containing a wide variety of technical database knowledge and programming experience. Experts in small business management and scientific database programming.

Do you and your clients need access to data on the Internet? We can create a secure system to match your requirements perfectly.


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 the table 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.

More Access Delete Query Examples:

Docmd RunSQL Access Database Example

Visual Basic Select Case in Access

Concatenate Records Text Field







A Blue Claw Software Design Template:

Asbestos Survey Project Database
 









A Blue Claw Database Design Article:

How To Create Faster Access Databases
 









Blue Claw Database Design Downloadable Tutorial:
Inventory Calculations Download ( Single User)  








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


Contact Information
Copyright 2000-2017 Blue Claw Database Design
Development in Microsoft Access, Microsoft SQL/Server and Azure

See our SQL/Server Development and Access Migration Tutorials