Microsoft Office Tutorials and References
In Depth Information
Deleting data in tables with a Delete query
Deleting data in tables with a Delete query
A Delete query allows you to delete data from a table either by
specifying filtering criteria or by using data in other tables or
queries to limit the data that is being deleted. As with all action
queries, you cannot undo the operation, so making a backup of
your database before you execute a Delete query is important.
4
1
Delete data in a table
1 Start with a select query including your table, and click Delete.
2 Select a field to filter the data.
3 Type the filter criteria.
4 Click Run.
5 Click Yes.
5
2
3
CAUTION When using Delete queries, always make sure that
you add filter criteria to avoid deleting all the data. After any
data is changed by the action queries, you cannot undo the changes.
Making a backup copy of the database is recommended before you
delete or otherwise modify your data.
Search JabSto ::




Custom Search