Designing Queries and Views
The Query and View Designer can help you create and maintain the data retrieval and data manipulation portions of your application.
- How to: Open the Query and View Designer
Provides steps for opening a new or existing query or view in the Query and View Designer.
- Comparison of Queries and Views
Points out the similarity and differences between queries and views.
- Navigating in the Query and View Designer
Provides a list of key combinations and mouse operations you can use in the Qeury and View Designer.
- Query and View Designer Tools
Provides links to topics describing the various components of the Query and View Designer.
- Types of Queries
Lists procedural topics on how to create various types of queries, such as UPDATE, DELETE, and MAKE TABLE queries.
- Working with Views
Defines "view" and describes the operations you can perform on views.
- Working with Data in the Results Pane
Describes what you can do with the results returned by a query or view and provides links to procedural topics.
- Performing Basic Operations with Queries
Lists topics on creating, modifying, running, and copying queries as well as basic topics on sorting, ordering, and printing query results.
- Specifying Search Criteria
Lists rules and conventions for creating queries, as well as procedures on how to use criteria to get specific results.
- Expressions in Queries
Provides links to topics such as how to use expressions in queries, what logical operators, and how to include user-defined functions in queries.
- Querying with Joins
Lists topics on using joins to query multiple tables, such as how to create outer joins and how to join tables automatically.
- Querying with Parameters
Lists topics for creating queries with parameters, which allow a different value to be used each time you run the query.