append queries

[johnny b.]

I am a newbie to access and I would like someone to
explain how an append query works, and what some of the
typical uses are. I would also like to know the general
procedure for running an append query.

thanx
j

 

[Peter]

An append query simply adds records to the end of an
existing table. Lets say you have a database of all books
which is periodically updated and that you wish to decant
only specific types of books into an existing table. You
would then use an append query to select the books based
on your criteria to add to the table you already have.
Best way to learn is to do it. Open a new append query and
follow the wizard.

Good luck.