Microsoft KB Archive/112136

= ACC2: Overview of New Query Features in MS Access Version 2.0 =

Article ID: 112136

Article Last Modified on 6/24/2002

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q112136



Novice: Requires knowledge of the user interface on single-user computers.



SUMMARY
This article summarizes the new query features and functionality in Microsoft Access version 2.0. This information can also be found using the Microsoft Access Help menu by searching for "What's New in Microsoft Access Version 2.0."



Rushmore Query Optimization
Microsoft 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 Name
Even 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 Fields
When 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 Sheet
With 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 Formatting
As 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.

Subqueries
You can use SQL SELECT statements as subqueries within your expressions in the Criteria row of the Query window.

Union and Data-Definition Queries
Using 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 Window
You 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-Through
You 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.

