The information in this article applies to:
SUMMARY
Novice: Requires knowledge of the user interface on single-user computers.
MORE INFORMATIONRushmore Query OptimizationMicrosoft Access uses an optimization method similar to that used by Microsoft FoxPro to speed up many types of queries.Automatic Joins for Fields with the Same NameEven if you have not defined relationships between tables, Microsoft Access automatically creates joins between tables when a query is initially created if the tables have matching fields with the same name and one of the fields is a primary key.Greater Updatability of Query FieldsWhen a query includes fields from more than one related table, you may be able to update data on both sides of the join in the same query.New Query Properties and Property SheetWith the new query properties, you can add input masks and formats to your queries, and you can limit the number of records displayed to a specified value. Query properties can be set in the property sheet.Query Datasheet FormattingAs with tables and forms, you can save your datasheet layout in queries. For example, if you freeze a column in a query datasheet, you can save the layout so it will appear the same way when you run the query again.SubqueriesYou can use SQL SELECT statements as subqueries within your expressions in the Criteria row of the Query window.Union and Data-Definition QueriesUsing SQL in Microsoft Access, you can create union queries and queries that create, change, or delete tables and indexes in Microsoft Access databases. Use the SQL Specific command on the Query menu in a query's Design view to create these types of queries.Improved SQL View WindowYou can enter any SQL statement in the improved SQL View window, including statements that you cannot create in the query's QBE grid. The menu and the toolbar buttons are also available when you are working in a SQL View window.SQL Pass-ThroughYou can pass SQL statements directly to SQL databases, providing improved connectivity in client-server relationships. You can use SQL pass-through queries as the source for a query, form, or report.REFERENCESFor more information about queries, search for "queries: <option>," and then view each of the topics using the Microsoft Access Help menu.
Keywords : kbusage QryOthr |
Last Reviewed: April 3, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |