DELETE Statement (Microsoft Access SQL) [Access 2007 Developer Reference]

Creates a delete query that removes records from one or more of the tables listed in the FROM clause that satisfy the WHERE clause. ... Part Description table The optional name of the table from which records are deleted. table The name of the table from

msdn.microsoft.com