Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » MS Access
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Access
Resolved · Low Priority · Version 2003
Reply
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?For upcoming training course dates see: Pricing & availability
RE: MS Access
Hi StuartThe 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.
|
 |
|
» Forum post: Excel |
How do you protect a worksheet
