access+training+courses - Import data

Hi Lu,

On your Access Introduction course, you were introduced to Queries. These were examples of what are termed Select Queries. However, within the Query design view, Append Query can be selected from the Query menu option.

I would suggest attending the lintermediate course to learn about other query types. See link below

https://www.stl-training.co.uk/access-courses-in-london-2003-intermediate.php

I have also provided an MS office resource that discusses the topic further.

http://office.microsoft.com/en-us/access/HA100765261033.aspx

Hope this helps