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

• Microsoft Access version 2.0

SUMMARY

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

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

MORE INFORMATION

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.

REFERENCES