Append Query

The UK's most regular instructor-led training courses.
Training information: ms access training · Microsoft access courses · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2003

6 posts

ReplyTue 2 Jun 2009, 14:19Delegate Toby said...

Toby has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Excel Introduction course
Excel Intermediate course

Append Query

What is the append query used for?

Version	Date	Location	Places available	Book	Next place rate (£)
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Tue 23 Mar 2010	Bloomsbury	3		£224	£225
2003	Tue 30 Mar 2010	Bloomsbury	6		£199	£204
2003	Thu 22 Apr 2010	Southwark	5		£195	£200
2007	Tue 27 Apr 2010	Bloomsbury	4		£224	£225
2003	Fri 28 May 2010	Bloomsbury	9		£156	£161
2003	Wed 16 Jun 2010	Bloomsbury	8		£95	£100
Full Schedule: See all 20 Access Intermediate course dates. Bookings currently available until 17th December 2010.

870 posts

ReplyWed 3 Jun 2009, 16:33Trainer Rajeev said...

RE: Append Query

Dear Toby

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.

Append query is mainly used for copying and pasting records from one table to another. I believe the main advantage of using the append query is that you can set a specific criteria that it follows to append only specific records.

Please refer to the following link that provides you with more information about append query!!

http://www.databasedev.co.uk/append_query.html

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Wed 10 Jun 2009: Automatically marked as resolved.

· Microsoft Access Tighten your Security Controls
· Innovation with Microsoft Access
· Supersizing your databases via Microsoft Access
· User-Level Security In Access
· Microsoft Access, an Efficient Database Tool

Please browse our web site to find out more about
ms access training and other Microsoft training courses.

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips