From the course: Access 2007: Shortcuts
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Moving records with append and delete queries - Microsoft Access Tutorial
From the course: Access 2007: Shortcuts
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. The Append Query will add records that match your criteria to the end of another table. Then changing that query to a Delete Query will remove them from the original table. This has some nice practical uses. For example, maybe once a SalesRep leaves your company, you'd like to move them to a table of Past Employees, instead of looking at the full list of everyone who's ever worked at your company. The first thing I'll need to do is to create a new table to move those records in to. It needs to have all the same fields and field names as the original content. So I am going to close my SalesReps table, right-click on it in the Navigation pane and copy it. Then I'll right-click on it again and choose Paste. I'll change the Table Name to SalesRepsArchive. I'll also change the Paste Options…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
-
Using wildcards5m 33s
-
Using IN instead of OR1m 34s
-
Hiding query fields50s
-
Changing captions1m 42s
-
Finding duplicate records2m 17s
-
Moving records with append and delete queries4m 32s
-
Using make-table queries2m 23s
-
Creating an update query2m 49s
-
Turning a query into a PivotTable2m 22s
-
Turning a query into a PivotChart2m 8s
-
Using SQL statements2m 27s
-
-
-
-
-
-
-