• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Using Specialized Queries > Copying Data to a Table

Copying Data to a Table

Like most Windows-based programs, Access has cut-and-paste functions to move records from one table to another. You can also write a query to automatically add records from one table to another table.

For example, you may want to append records from one table to another if you purchased a number of new books for your library while on a trip. You can enter records for those new books in a new table using an Append query. The new table must have the same structure as the table you're appending the records to.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint