How to Create a Delete Action Query in Microsoft Access

Video Transcript

"Hi, my name is Chip Browne and I teach computer programming and MicroSoft Office applications at a local business college, Steven Henagar, here in Utah. I also create practice tests for MicroSoft Office certifications. Today I'm going to teach you how to create a delete query in MicroSoft Office Access. MicroSoft Access is a registered trademark of MicroSoft Corporation. I'm not affiliated with MicroSoft Corporation. A delete action query in MicroSoft Access is based upon the delete statement of SQL. The syntax of the delete statement is 'delete' followed by an optional table, name, dot, asterisk, followed by the table from which you want to delete the records, followed by the criteria which will determine which records to delete. Let's create one. Click on the 'Create' tab, and in the other group click 'Query Design'. Next, select the table from which you want to delete the records. Up here choose 'Delete' to change the query type from a Select statement to a Delete statement. Next, choose the field which has the criteria for the deletion. Next, choose a value for the deletion. Let's go and look at the table. It has a ship city, and two orders have been shipped to Boise. Now let's look at the SQL that has been generated. Here's the SQL syntax. To view SQL, click 'View' and SQL View. Delete followed by the optional table name, dot, field name or asterisk, followed by the table, followed by the 'Where' clause, which has the criteria. Let's run this query now. Now, we'll look the the Orders table. We'll see these two records have been deleted. If we close this window, and run it again, we'll see that they aren't showing up in our query results. This is how you can create a 'Delete' action query from scratch. For more information, visit me, Chip Browne. com. That's Browne with an e."