MS Access

Resolved · Low Priority · Version 2003

Thu 21 May 2009, 15:59 Delegate 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:18 Trainer 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 courses

	98.8 % recommend us
	More live stats...

Training information:

Access tip:

Choosing data types in Access

Not 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.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips