MS Access

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

Resolved · Low Priority · Version 2003

1 post

ReplyThu 21 May 2009, 15:59Delegate Stuart said...

Stuart has attended:
Access Intermediate course

MS Access

Is it good practice to create "chains" of queries (which use data from other queries, which use data from other queries etc.) to produce a final table of results or is it better to use a series of action queries which are run in a particular order to create a table and manipulate the data in it?

Version	Date	Location	Places available	Book	Next place rate (£)
Access VBA 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Wed 24 + Thu 25 Mar 2010	Southwark	8		£445	£450
2003	Wed 5 + Thu 6 May 2010	Bloomsbury	10		£275	£280
2003	Mon 28 + Tue 29 Jun 2010	Bloomsbury	10		£275	£280
2003	Wed 4 + Thu 5 Aug 2010	Bloomsbury	10		£275	£280
2003	Thu 9 + Fri 10 Sep 2010	Bloomsbury	10		£275	£280
2003	Wed 27 + Thu 28 Oct 2010	Bloomsbury	10		£275	£280
Full Schedule: See all 7 Access VBA course dates. Bookings currently available until 6th December 2010.

635 posts

ReplyFri 22 May 2009, 15:18Trainer Carlos said...

RE: MS Access

Hi Stuart

The problem of Action Queries is that the action is permanent. So a Make Table query creates a physical table in your database.

Chains of queries are more useful because, while slow, do not change the look of the database.

You should never create a table as a one off, but create it if you are going to make use of it regularly.

Hope this helps

Carlos

Fri 29 May 2009: Automatically marked as resolved.

· Have You Ever Wanted To Create A Combo Control On An Access Form?
· Microsoft Access Flaws and Ways to Overcome Them
· Why a Microsoft Access Course Could Change the Way You Do Business
· The Three Classes of Databases
· Use Microsoft Access to manage your work/life balance

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

Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms and Conditions

MS Access

MS Access

RE: MS Access

Related articles

Access tip:

Action queries