98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » MS Access
MS Access
Resolved · Low Priority · Version 2003
Thu 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?
Fri 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.
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. |
Access tip:Choosing data types in AccessNot sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field. |
