Moving records with append and delete queries


show more Moving records with append and delete queries provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Moving records with append and delete queries

There are a variety of queries that you can use to modify your data. These are called Action Queries. When you want to move records from one table to another, combine an Append query and a Delete query. An Append query will add records that match your criteria to the end of another table. Then changing that same query to a Delete query will remove them from the original table. This has some nice practical uses. For example, may be once the Sales Rep leaves your company, you'd like to move them to a table of past employees, instead of looking at the fullest of everyone who have ever worked at your company.

The first thing I need to do is to create the new table to move the records into. It needs to have all the same fields and field names as the original content. So I'll close this table. I'll right-click on SalesReps in the navigation pane, and choose Copy. I'll right-click on SalesReps again, and then choose Paste. I'll change the name to SalesRepsArchive. I'll move t...

Moving records with append and delete queries
Video duration: 4m 31s 3h 43m Intermediate

Viewers:

Moving records with append and delete queries provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...