Quicker Access Queries

Access users rely on queries to manipulate and analyze their data, so it's important that queries be efficient and run quickly. To get the most from your queries, try applying the following tips:

• Include only the fields you really need.
• Avoid on-the-fly queries; use stored queries whenever possible.
• Compact and compile often.
• Avoid nesting queries.
• Don't use the asterisk (*) character in the query design grid; specify the individual field names instead.

Access Index

Main Index